Re: question about mysql backups

these should help http://www.mysql.com/doc/en/mysqldump.html http://www.healyourchurchwebsite.com/archives/000572.shtml http://www.cgi-interactive.co.uk/mysql_dump.html Jake Malone wrote:

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 in the same process and add it to the same zip file. i really like 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. -jake