troubleshooting Question

How to backup a MySQL database that is too big to mysqldump? Cant take server offline.

Avatar of Octalys
Octalys asked on
LinuxHTMLMySQL Server
12 Comments4 Solutions949 ViewsLast Modified:
Hi,

How do I backup a MySQL database that is too big to mysqldump? Cant take server offline. The database is live and contains 20 million row of records.

I havent been able to backup it for a few months, the plan is to use mysql replication when we upgrade the code. But for now we just simple want a mysqldump, but when we try it, the whole servers stops doing everything else and only dumping the database. Which takes quite some time to finish, so how do people dump such big database on a live server?

Thank you.
ASKER CERTIFIED SOLUTION
Mysidia

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros