MySQL migration issue: lock tables

[pv]

Hello,
I issued the backupdb command as instructed, entered my password upon request, and got this:

mysqldump: Got error: 1044: Access denied for user 'tornado5_0-admin'@'%' to database 'tornado5_0' when using LOCK TABLES

Nothing that my ilk can comprehend, or know the slightest about trying to get around...so I'm looking for a little assist here.

TIA,
-Peeter

[williamt]

after mysqldump add --skip-lock-tables

[pv]

would you please write out the entire command containing the insert, verbatim. This will save head-scratching.

Thanks again.

[williamt]

I added it to our wiki but here it is also.

Code: Select all

mysqldump --skip-lock-tables -u YOUR_DATABASE_USERNAME -h YOUR_DATABASE_HOSTNAME -p YOUR_DATABASE_NAME > backup.sql

[pv]

This is what I get when I try your line:

$ mysqldump --skip-locks-tables -u tornado5_0-admin -h custsql.sonic.net -p tornado5_0 > backup.sql
mysqldump: unknown option '--skip-locks-tables'

What to do now? Hardly any time remaining, looks like I'll just have to trust this migration to be a non-issue...

Clarification of what is not right with this line would be fine, for the record and all...seems like I'm the only one interested.

[pv]

OK, I see the keystroke error in your (and the WIKIs) example: it should be "lock-tables", not "locks-tables". Works fine when that error is eliminated.

[williamt]

Thanks for catching my typo.