MySQL Forums
Forum List  »  Backup

MS Backup good enough?
Posted by: Toob Ster
Date: December 21, 2005 10:24AM


I have a Windows 2003 Server (running as webbserver) that I backup every night using the Microsoft Backup util.

I simply make it copy inetpub so I can restore their websites. However I also take full backup of the "MySQL datafiles" directory. In the directory the following files are located:

/ibdata1 (20megs)
/data (folder)
/data/ib_logfile0 (85 meg)
/data/ib_logfile1 (85 meg)

/data/*a dir for each database.

So the above data is backed up every night.

However I wonder it this would be sufficient enough for a restore? I'm talking about simply replacing the whole structure shown above with the one in my backup.

Would that work or do I need to use some special MySQL backup utility?

Thanx in advance and merry x-mas to everyone!

Options: ReplyQuote

Written By
MS Backup good enough?
December 21, 2005 10:24AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.