Backing up large databases
 

Hey,
What's the best way to dump a huge database? Our server tends to crash at the very end of dumping... our site isn't too huge, but still pretty big (360,000+ posts). I haven't been experimenting too much simply because of not wanting to crash the site if I mess it up :p
- Jesse

We use MySQL replication and then a custom script copy the binary *.myd, *.myi, and *.frm. You could use a tool like mysqlhotcopy or mysqlsnapshot to do faster backups than using mysqldump.

I just copy the relevant database directory manually.

I have been using SQLyog to perform my backups. Works pretty nice and fast. I use the pro version, Anyone else use this and who has had to recover a backeup database using this tool. My database is about 300mb and I can backup in less then 10 minutes.

300 mb is relatively small. My database is 20 Gb. The chances of corruption is very high using indirect methods (I know from experience!).

Erin
Arent you one of the gods that run this site.hehehe

20 gigs! I feel like a small bug in the ocean now, thanks.. Just kiddin

Can you explain in more details how you are going your copies?

Found this, is this waht you guys are talking about?

http://www.vbulletin.com/forum/showthread.php?t=134821

Thank for the link, trackpads!

Np, I was looking for the same thing!! I tried this tonight and it works great!

Yeah. Since I don't have Telnet/SSH access with the server that my vB is on I've looked through various third party apps in hope to find a reliable backup. Mysqlhotcopy seems to be the choice.

*I also have that page bookmarked. :)

Then again, since I only have a 123MB database I could simply copy the files via Admin CP or phpMyAdmin.