Showing posts with label mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES. Show all posts
Showing posts with label mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES. Show all posts

Tuesday, August 20, 2019

mysqldump error

1044: Access denied for user 'username'@'localhost' to database 'database_name' when using LOCK TABLES

Solution :
Use --single-transaction with mysqldump.
Example :
mysqldump --single-transaction --routines -u username -p database_name > database_name.sql