Jump to content


Dump MySQL database at selected times?

  • Please log in to reply
1 reply to this topic

#1 marco-marco

  • Members
  • Pip
  • Newbie
  • 9 posts

Posted 21 December 2003 - 10:49 PM

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.


#2 shivabharat

  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 22 December 2003 - 05:07 AM

Have a look at this


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

Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users