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
