Re: question about mysql backups

Jake -- ..and then Jake Malone said... % % hi, Hi! % % i have a script (run from cron) which backs up all files in a given % directory and outputs a zip file. what i want to do is backup the database Good enough. % in the same process and add it to the same zip file. i really like You can either make the mysql dump file first and include it or add it to the existing zip file, as you prefer. % phpmyadmin's way of backing up the DB, and was wondering if there was an % easy way to do essentially the same thing outside of phpmyadmin (i just need % to save the db structure, tables, and data into a single .sql file). thanks % in advance. Yep. For mysql dump needs, there's nothing like mysqldump -- see the man page (as well as, perhaps, the mysql general liist archives). % % -jake HTH & HAND :-D -- David T-G * There is too much animal courage in (play) davidtg@justpickone.org * society and not sufficient moral courage. (work) davidtgwork@justpickone.org -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!