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? 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). 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. 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. 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. 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
Archived
This topic is now archived and is closed to further replies.