mschneikert
asked on
got error 1044 when dumping MySQL 5.0 BD
Hi i'm trying to backup a mySQL database and i'm getting the following message at the bottom of this DOS text. I'm using windows 2003 server and mysql 5.0.
-------------------------- ---------- ---------- ---------- ---------- ---------
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>cd\
C:\>cd program files\mysql\mysql server 5.0\bin\
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u wikiuser -p wikidb>F:\C
TLWIKIBACKUP\ctlwiki101008 .sql
Enter password: ******
mysqldump: Got error: 1044: Access denied for user 'wikiuser'@'localhost' to dat
abase 'wikidb' when using LOCK TABLES
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u wikiuser -p wikidb>F:\C
TLWIKIBACKUP\ctlwiki101008 .sql
Enter password: ******
mysqldump: Got error: 1044: Access denied for user 'wikiuser'@'localhost' to dat
abase 'wikidb' when using LOCK TABLES
C:\Program Files\MySQL\MySQL Server 5.0\bin>
-------------------------- ---
Any ideas how I can get around this LOCKED TABLES error so i can backup the database?
Many thanks experts
--------------------------
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>cd\
C:\>cd program files\mysql\mysql server 5.0\bin\
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u wikiuser -p wikidb>F:\C
TLWIKIBACKUP\ctlwiki101008
Enter password: ******
mysqldump: Got error: 1044: Access denied for user 'wikiuser'@'localhost' to dat
abase 'wikidb' when using LOCK TABLES
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u wikiuser -p wikidb>F:\C
TLWIKIBACKUP\ctlwiki101008
Enter password: ******
mysqldump: Got error: 1044: Access denied for user 'wikiuser'@'localhost' to dat
abase 'wikidb' when using LOCK TABLES
C:\Program Files\MySQL\MySQL Server 5.0\bin>
--------------------------
Any ideas how I can get around this LOCKED TABLES error so i can backup the database?
Many thanks experts
you need to grant the LOCK TABLE permissions to that login.
ASKER
Thanks for this Angell - any ideas how i do this?
http://dev.mysql.com/doc/refman/5.0/en/grant.html
GRANT LOCK TABLES ON <dbname>.<tablename> TO 'wikiuser'@'localhost';
ASKER
ok my dbname is "wikidb" but i do not know the name of the table. Any idea how i find this out?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.