The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

mysqldump: Got error: 1044 (3 posts)

  1. JohnP
    Posted 3 years 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?


  2. Tom Willmot
    Human Made
    Plugin Author

    Posted 3 years 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.

  3. JohnP
    Posted 3 years 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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • BackUpWordPress
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic