How to Backup MySQL databases without interrupting MySQL?

view full story

http://linuxers.org – Normally when we create a backup of our MySQL using Mysqldump it creates a Read Lock on the database, so no changes can be made to the database at that time. It may take from a second to few minutes to take up backup of your database. So, sysadmin either prefer to stop MySQL or issue a READ lock on the MySQL table, so that database remains consistent. In this howto, i will demonstrate a method so that you can take up backup of your database without interrupting MySQL. In this howto i use a method that i discussed in my previous howto  (General)