For urgent reason like preventing website down when dumping MySQL, we need to skip lock-tables. You can use -–skip-lock-tables and –skip-add-locks option with mysqldump command. Example : mysqldump -u 412843_reebonzsg -p –skip-add-locks –skip-lock-tables db_name \ > dbfile_dump.sql