Programmatically backing up (and sending by email) the full MySQL database via PHP

Question

I need to back up my MySQL database daily and preferably send it by email to the email address of my choice.

Can this be done? What is SQL to create a backup file? How can I add this file as an “attachment” to the sent message?

Thanks for the help, I really need to make these backups!

I know how to call a script via cronjob, so the daily thing is not a problem.

Answer 1

mysql_dump :

mysqldump <DB name> -u<user> -p<password> | gzip -c > /backup/`date +%Y-%m-%d`.sql.gz

mail ( , ).

Answer 2

exec, mysqldump , .

 mysqldump -u username -p password databaseName > databaseFile.sql

PHP .

, , , , .

Tom Tom, PHP Zlib GZIP " " zip PHP.

Answer 3

MySql Script

script MySQL , , / . .

http://www.dagondesign.com/articles/automatic-mysql-backup-script/

Answer 4

MySQL   =====================   http://restkultur.ch/personal/wolf/scripts/db_backup

, , .. ( , , - FTP ).