Solved

got error 1044 when dumping MySQL 5.0 BD

Posted on 2008-10-10
5
816 Views
Last Modified: 2012-05-05
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

0
Comment
Question by:mschneikert
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22688355
you need to grant the LOCK TABLE permissions to that login.
0
 

Author Comment

by:mschneikert
ID: 22701498
Thanks for this Angell - any ideas how i do this?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22701727
http://dev.mysql.com/doc/refman/5.0/en/grant.html

GRANT LOCK TABLES ON <dbname>.<tablename> TO 'wikiuser'@'localhost';

Open in new window

0
 

Author Comment

by:mschneikert
ID: 22702043
ok my dbname is "wikidb" but i do not know the name of the table. Any idea how i find this out?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 22702374
you can use wildcards:
GRANT LOCK TABLES ON wikidb.* TO 'wikiuser'@'localhost';

Open in new window

0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MYSQL responding very slow 3 66
DNS/WINS in a domain 10 89
WordPress  Failed to Import Media 8 64
How can I use javascript variable in mysql query 21 37
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question