mardi 13 juillet 2010

Error 1044 in MySQL: Access denied when using LOCK TABLES



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

Aucun commentaire:

Enregistrer un commentaire