Backing up a 22 GB MySQL database daily
- by unknown (yahoo)
Right now I am able to do the backup using mysqldump. But I have to take down the web server AND it takes around 5 minutes to do the backup. If I don't take down the web server, it takes forever and never finishes + the website becomes inaccessible during the backup.
Is there a quicker/better way to backup my 22 GB and growing database?
All the tables are MyISAM.