Can’t backup database – Table doesn’t exist

  • Resolved dana_cz

    (@dana_cz)


    3 years, 12 months ago

    I’m managing a client’s website and I’ve set up Updraft Plus (free) to backup database every 14 days and files monthly. I run a manual backup of everything once at the end of the month when I’m updating WordPress, plugins and themes.

    Database was last automatically backed on Nov 19 with no errors. I tried to backup manually today, files were fine but the database gets stuck and never completes the backup. I get the error “table doesn’t exist”.

    Here’s the pastebin of the log.

    I’ve tried disabling plugins but that doesn’t work. I wonder where it gets the table name if it doesn’t exist and why the backup worked correctly 11 days ago (no updates were made of anything during that time).

    Thank you for any help!

    PS: Since Updraft didn’t work, I backed up my database through phpmyadmin.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author David Anderson

    (@davidanderson)

    Hi,

    It looks like your MySQL database has a corruption problem. The SQL command SHOW TABLES includes a table wp_mltlngg_translate in the list of tables; but when details about that table are sought, it turns out not to exist.

    If you run the SHOW TABLES SQL command in phpMyAdmin, does the table show up in that list?

    David

    Thread Starter dana_cz

    (@dana_cz)

    hi,
    yeah, the table shows up when I run the command.

    Thread Starter dana_cz

    (@dana_cz)

    I fixed this by reinstalling the plugin that creates those tables, then disabling and uninstalling. It got rid of the tables and now Updraft can back the database up with no problems.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can’t backup database – Table doesn’t exist’ is closed to new replies.