Ernest Ho Diary

If you are getting the error mysqldump: Got error: 1044: Access denied for user 'user'@'server' to database 'db' when using LOCK TABLES

then the user does not have lock priviledges. Use a different user with adequate privileges. If you only have this user account, you can use the --single-transaction option to avoid the LOCK TABLES function of mysqldump. That is,

mysqldump -uyourusername -pyourpassword --single-transaction yourdb > yourdb.sql