Database Errors

  • Hello.

    I’m creating a WordPress site on my local drive, via Elementor. (Once it is finished, it will be transferred to a webhost provider.) I’m close to completing it, but now I’m receiving an error that says my database cannot be found.

    I tried using the WordPress tool to repair and optimize the database, but it ultimately returned the following error:

    wp_options: Table ‘themavo.wp_options’ doesn’t exist in engine

    What should I do to fix this problem and regain access to my site?

    • This topic was modified 4 days, 2 hours ago by themavo.
Viewing 5 replies - 16 through 20 (of 20 total)
  • Thread Starter themavo

    (@themavo)

    @catacaustic

    Is this issue with the database most likely being caused by XAMPP or could it be something else? I’m so close to having the site be completed (at least this first version of the site) that I don’t know if if I really want to start changing server software at this point. XAMPP seems to have worked well enough until now.

    Thread Starter themavo

    (@themavo)

    Thanks for your tip, @iamshubhamsp

    Before I saw your latest post, I tried replacing the entire XAMPP > MySQL > data folder with a backup that I had. I still received the Error establishing a database connection message. Then, I tried replacing the same data folder with a version from an even older backup. Same error occurs. Again, I had been working on my site for a long time before and the connection to the database was not an issue. If a backup is not restoring the connection and the site, what is causing this issue all of a sudden?

    I never really moved/migrated the site anywhere. So far it’s only been on my localhost hard drive connected to my workstation.

    In any case, I’ll try the other steps you outlined in your message.

    • This reply was modified 1 day, 17 hours ago by themavo.

    @themavo You have one rather large problem that I can see now.

    MySQL does not like it when you copy data folders and files. If there’s even a small difference in versions, or something is not “just right”, it will fail. Copying databases is not the same as copying site files.

    The best way to copy databases is to import an SQL dump file that you exported from the original database. Anything else is going to be very fragile and has an extremely high chance of not working (as you’re seeing in your case).

    Thread Starter themavo

    (@themavo)

    Well, @catacaustic, as it stands, I’ve rather soured on MySQL because it’s so unreliable. So often the overall MySQL app doesn’t even start at all in XAMPP. Whenever that happens, I have to replace most of the files in the mysql > data folder with versions in the mysql > backup.

    Now there’s suddenly no connection at all to the WP database. What do I need to do now to have this site back on track again? There must be something…

    If that happens then it’s XAMPP doing something wrong. MySQL is very good and it normally doesn’t have issues unless you do something wrong. And if MySQL doesn’t start with XAMPP… don’t blame MySQL, blame XAMPP. Which is exactly why I suggested switching to Local before.

    As I said before. copying files is bad. Restoring from SQL dumps is good. Unless you can do that, then you really need to seek help in another forum dedicated to MySQL because it’s way outside of the scope of these forums.

    To be honest, if you can’t take the advice here, then there’s no point in trying to help.

Viewing 5 replies - 16 through 20 (of 20 total)
  • You must be logged in to reply to this topic.