• I’m trying to repair my database but I’m receiving this error:

    wp_options: Table 'DBname.wp_options' doesn't exist

    Someone can help me?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Have you looked in the database to see if the table exists? Do you have access to some tool like PHPMyAdmin?

    Thread Starter rafaviana

    (@rafaviana)

    I checked and the table does not exist. Now I don’t receive any error when is repairing the database. I removed this line: define('WP_ALLOW_REPAIR', true); but when I try access wp admin, it sends me again to Repair Database page

    I’m just guessing, but have you tried adding the table? I think your DB got corrupted somehow. wp_options is a very important table, it holds all the main configuration options for your site. Just to be friendly, I’ve exported my wp_options table: https://pastebin.com/rEtfvjcM

    The site URL and admin email are the most important things to change. If you want to try it you could run that SQL in phpMyAdmin once you have made the relevant changes.

    How did this corruption occur? What version are you running? Does your host have a backup point that you can restore from?

    Thread Starter rafaviana

    (@rafaviana)

    I have a backup and I have tried to run SQL to import the table but phpMyAdmin can’t run this SQL because is bigger than allowed

    How this happens I don’t have idea, I think it was when I imported some specific tables from a backup and I broke everything but don’t know how it happened because I imported just 1 or 2 tables…

    I will ask my server admin to increase SQL maximum file size, this way I can import last backup

    You need proper access to do what you want, meaning perhaps a better host. php MyAdmin has limitations on most hosts, primarily because you are running a GUI web page and trying to do root access level operations.

    Ask for or get a host with shell access. Then use Putty or some other ssh terminal to access the server directly. Running a mysqldump or import should be a regular things that requires no thought. Best instructions that I know of: https://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

    Thread Starter rafaviana

    (@rafaviana)

    Thanks man! You turned on that light in my brain that I thought it was forgotten ??
    Sometimes I read and see on the foruns some tips to use terminal commands, etc.. but I don’t have idea how to do that and you show me what is that with few words!

    Thanks ??

    Awesome. So glad it helped. Level up, achievement unlocked. ??

    Thread Starter rafaviana

    (@rafaviana)

    Yes ?? although my server admin don’t give me shell access

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘"DB wp_options doesn't exist"’ is closed to new replies.