PHP system() and mysqldump

[MattHawkins]

Hello,

I have a backup script that calls the 'system()' function to execute 'mysqldump'. This dumps a MySQL database to file.

system() has been disabled for security reasons which is fair enough.

Is there any other way from within PHP that I can dump a database to file? I know I can use phpmyadmin to dump databases but I am after a mechanism that allows me to backup a database with one click from within my PHP pages.

Matt

[eUKhost.com]

Hello Matt,

You can setup a daily cron which will use mysqldump command and make a dump of the database in your hosting space. You can passon date command variable in the dump file name to have separate database dump file on each date.