back up and restor mysql code...

[miles_rich]

does anyone have the code to back up mysql with 'Mysqldump'?? and the code to restore the dumped database through php??

[goa103]

hi,

mysqldump is an application. why would you want to use it throughout PHP ? maybe you want to use a PHP script to backup your MySQL DB. Am I right ? in that case I think you can use the exec PHP function. Don't forget to give the proper rights to your files and folders.

JM

[jowatkins]

You can back up your db and restore it form the cmd promt, or set up a cron job to do the backup periodically.

For MySQLDump, perform the function from the mysql/bin promt.

The command is :
c:\mysql\bin>mysqldump -h hostname dbname > c:/filename.txt

Then to retore, go to the mysql promt and do a source command :
mysql: source < c:/filename.txt