1044: Access denied for user 'username'@'localhost' to database 'database_name' when using LOCK TABLES
Solution :
Use --single-transaction with mysqldump.
Example :
Solution :
Use --single-transaction with mysqldump.
Example :
mysqldump --single-transaction --routines -u username -p database_name > database_name.sql