Dump MySQL database at selected times?

[marco-marco 0]

Is there a query which can be run that will dump the whole contents of a MySQL databse?

 

What im looking to do is construct some php code with a query to dump the contents of a databse every so often, for exampling setting up scheduled tasks on windows or cronjobs on linux to run this code every so oftem to produce a back up of the databse.

 

Marco

[shivabharat 0]

Have a look at this

 

http://www.mysql.com/doc/en/Backup.html

 

You can also do selective backups with SELECT * INTO OUTFILE \'file_name\' FROM tbl_name and restore with LOAD DATA INFILE \'file_name\'