marco-marco Posted December 21, 2003 Share Posted December 21, 2003 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 Quote Link to comment Share on other sites More sharing options...
shivabharat Posted December 22, 2003 Share Posted December 22, 2003 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\' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.