homepage Welcome to WebmasterWorld Guest from 54.224.75.101
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
Pubcon Website
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library : Charter : Moderators: physics & whoisgregg

Databases Forum

    
Backup of Massive MySQL InnoDB Databse
Ian Cunningham




msg:1579997		 12:37 pm on Sep 11, 2005 (gmt 0)

I'm currently running a site with a huge 20GB InnoDB MySQL database on Windows 2003/IIS. My method of backup is to simply stop the MySQL service and make a copy of the "data" directory. However, this results in downtime and isn't easily automated.

Does anyone have a better solution so that I could make a constant backup whilst live? I can't afford the InnoDB live backup tool, but there must be other ways around it?

 

txbakers




msg:1579998		 2:33 pm on Sep 11, 2005 (gmt 0)

I use something called PeerSync which can read open files for backup. It's about 98% accurate as far as I can tell. The best result is to shut down and copy, but the PeerSync has worked for me.

Then, once the copy is made, I don't have to shut down to take it off site.

Ian Cunningham




msg:1579999		 3:03 pm on Sep 11, 2005 (gmt 0)

Have you tried this for really large DB's before?
txbakers




msg:1580000		 3:51 pm on Sep 11, 2005 (gmt 0)

not that big
Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved