Dump MySQL database at selected times?
Posted 21 December 2003 - 10:49 PM
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.
Posted 22 December 2003 - 05:07 AM
You can also do selective backups with SELECT * INTO OUTFILE \'file_name\' FROM tbl_name and restore with LOAD DATA INFILE \'file_name\'
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users