Best backup system

[mrgrammar]

I have a rather extensive mysql database I developed for a client. Using phpMyAdmin, I can back everything up quickly using the Export function. However, when I'm done, my customer will need to do backups. I cannot give them access to phpMyAdmin, so they cannot use that export.

What is the best solution for providing them with a backup of all their tables and the data?

[bradgrafelman]

mysqldump is probably the most common solution.

[dagon]

i nun mysqldump and zip the file with a cronjob, then the client can download it via ftp if they want to.

[bretticus]

If you aren't a bash scripter, this project is really nice for getting the backup routine going:

http://sourceforge.net/projects/automysqlbackup/

I have been scripting in bash for 10+ years now but I just grabbed this the other day for a client to save some time and was pleased with it.