shamoon Posted November 15, 2007 Share Posted November 15, 2007 Hello All, I am trying to have a nightly backup of my databases, but the are rather large. I am currently using the "automysqlbackup" tool, which uses mysqldump, but the problem is that it locks the database while doing it's thing. Seeing as how the database is huge, it takes a few minutes and our site is down. Are there any other tools that anyone can recommend? Quote Link to comment https://forums.phpfreaks.com/topic/77520-mysql-backup-of-large-database/ Share on other sites More sharing options...
fenway Posted November 19, 2007 Share Posted November 19, 2007 Hello All, I am trying to have a nightly backup of my databases, but the are rather large. I am currently using the "automysqlbackup" tool, which uses mysqldump, but the problem is that it locks the database while doing it's thing. Seeing as how the database is huge, it takes a few minutes and our site is down. Are there any other tools that anyone can recommend? Try xaprb's MySQL Toolkit (a.k.a. Maatkit). Quote Link to comment https://forums.phpfreaks.com/topic/77520-mysql-backup-of-large-database/#findComment-394444 Share on other sites More sharing options...
Hooker Posted November 19, 2007 Share Posted November 19, 2007 You could always create a duplicate set of tables (ie. table1 = table1_backup) and select table1 into table1_backup then run your backup tool (and obviously empty "table1_backup" on completion. You might take a little hit on performance for the duration of the select but it would allow you to do live backups with little risk. Quote Link to comment https://forums.phpfreaks.com/topic/77520-mysql-backup-of-large-database/#findComment-394564 Share on other sites More sharing options...
fenway Posted November 19, 2007 Share Posted November 19, 2007 You could always create a duplicate set of tables (ie. table1 = table1_backup) and select table1 into table1_backup then run your backup tool (and obviously empty "table1_backup" on completion. You might take a little hit on performance for the duration of the select but it would allow you to do live backups with little risk. That's called replication. Quote Link to comment https://forums.phpfreaks.com/topic/77520-mysql-backup-of-large-database/#findComment-394568 Share on other sites More sharing options...
Hooker Posted November 19, 2007 Share Posted November 19, 2007 yep, was just trying to make it a little more understandable than "try replication" as its probably a better option than a straight backup of a live table. Quote Link to comment https://forums.phpfreaks.com/topic/77520-mysql-backup-of-large-database/#findComment-394573 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.