Live mySQL backup without locking tables By LotusshaneyNovember 12, 2015Tech As long as the engine is innodb mysqldump -u root -p --single-transaction -q database_to_backup >backup.sql