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 Link to comment https://forums.phpfreaks.com/topic/1537-dump-mysql-database-at-selected-times/ 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\' Link to comment https://forums.phpfreaks.com/topic/1537-dump-mysql-database-at-selected-times/#findComment-5056 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.