Jump to content


Photo

Dump MySQL database at selected times?


  • Please log in to reply
1 reply to this topic

#1 marco-marco

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.

Marco

#2 shivabharat

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

Posted 22 December 2003 - 05:07 AM

Have a look at this

http://www.mysql.com.../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\'


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