5 ms·Dumping/Backing up Mysql Databases (Innodb) without locking tables.1 points by rishav 15y agorealschool 15y agoTry XtraBackup, it takes a little time to set up but its great and can be automated.