14 messages in com.mysql.lists.win32Re: Scheduled backups
FromSent OnAttachments
James Dickson17 Aug 2005 13:02 
Daniel da Veiga17 Aug 2005 13:05 
Peter Monk17 Aug 2005 20:47 
Jonathan G. Lampe18 Aug 2005 06:43 
Dan Baker18 Aug 2005 10:22 
Daniel da Veiga18 Aug 2005 13:02 
Peter Monk18 Aug 2005 22:34 
Peter Monk18 Aug 2005 22:39 
Peter Monk18 Aug 2005 23:15 
Peter Monk19 Aug 2005 01:31 
James Dickson19 Aug 2005 01:31 
James Dickson19 Aug 2005 02:09 
Karam Chand19 Aug 2005 06:33 
Jonathan G. Lampe19 Aug 2005 06:50 
Subject:Re: Scheduled backups
From:Peter Monk (pete@uwi.com.au)
Date:08/18/2005 10:39:11 PM
List:com.mysql.lists.win32

Dan Baker wrote:

I'm curious to know what parameters you use to mysqldump?

mysqldump.exe -a -c -e -i -B -Q -u<user> -p<password> -r<destination file>
<database name>

I would like to get something that I can use to rebuild the database (with all tables), and re-populate every table. Have you tried using one of your .sql files to rebuild from scratch, and did it work correctly?

Yes, this creates a complete .sql file - I have, on another machine, gone into phpMyAdmin and imported the gzipped .sql file directly (phpMyAdmin can handle gzipped files now, yay!) and it has recreated the database perfectly.

This was my goal - to be able to have a nightly backup file that, in the event of our server failing, I could load on to any suitable machine and have running in very little time.

Peter.