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?