mysqldump: Got error: 1044 | WordPress.org

JohnP
(@johnp)

11 years, 1 month ago

I’ve installed BackUpWordPress on a second site, but when I try to do a manual database backup I get a bunch of errors, starting with:

mysqldump: Got error: 1044: Access denied for user ‘correct_username’@’localhost’ to database ‘xxxxx_org_-_wordpress’ when using LOCK TABLES
mysql_query(): Unable to save result set, /var/www/html/wp-content/plugins/backupwordpress/hm-backup/hm-backup.php, 1458

What should I do next?

http://wordpress.org/extend/plugins/backupwordpress/

Viewing 2 replies - 1 through 2 (of 2 total)

Plugin Author Tom Willmot
(@willmot)

11 years, 1 month ago

Hey John

Not sure what is going on there, the unable to save result set error could maybe be caused by your database tables needing a repair.

See http://codex.wordpress.org/Editing_wp-config.php#Automatic_Database_Optimizing for details of how to do that.

Thread Starter JohnP
(@johnp)

11 years, 1 month ago

Thanks Tom

I ran a complete database optimization and repair from PHP MyAdmin, but I still get the same error.

I then used the wp-config method you suggested which reports that 11 of my 20 tables are okay and optimized. I presume this script only repairs the core WP tables.

But the error: 1044 remains.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘mysqldump: Got error: 1044’ is closed to new replies.

In: Plugins
2 replies
2 participants
Last reply from: JohnP
Last activity: 11 years, 1 month ago
Status: not resolved