MySQL Backup - incremental

Posted by Tiffany Walker on Server Fault See other posts from Server Fault or by Tiffany Walker
Published on 2012-11-24T19:02:55Z Indexed on 2012/11/30 17:07 UTC
Read the original article Hit count: 228

Filed under:
|
|

I know that you can use mysqldump. I am currently dumping the following way:

${MYSQLDUMP} --single-transaction -u ${MUSER} -h ${MHOST} -p${MPASS} $db | ${GZIP} -9 > $FILE

From my understanding this locks the database and prevents any type of use of the database and can even lock up websites. Is there a better way to maybe do daily/hourly backups of the MySQL database should the database be in the 100mbs and even 1gbs in size?

© Server Fault or respective owner

Related posts about mysql

Related posts about backup