I got an error while using mysqldump
mysqldump: Got error: 1044: Access denied for user x@y to database z when using LOCK TABLES
To solve this problem, either ask you administrator to grant you the lock privileges, or use the following command instead.
mysqldump -u username -p database --single-transaction >dump.sql
Hi, Be the first leave some reply
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...]
dba Ask TEM Dba
(0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5) (0.00 out of 5)