Title: Database Errors Last modified: March 18, 2025 --- # Database Errors * [themavo](https://wordpress.org/support/users/themavo/) * (@themavo) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/) * 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 1 year, 1 month ago by [themavo](https://wordpress.org/support/users/themavo/). Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/database-errors-84/page/2/?output_format=md) [→](https://wordpress.org/support/topic/database-errors-84/page/2/?output_format=md) * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18366867) * If your database can’t be found, it either has not been set up, or your username/ password is wrong so the server can’t connect to that database. The other error is only showing because the site can’t find the database to be able to check the tables. * Double check your database connection details in your wp-config.php file, and make sure that your database has the correct permissions set up for that user. * Moderator [threadi](https://wordpress.org/support/users/threadi/) * (@threadi) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18367142) * The above message indicates that although the connection to the database is working, an important database table is missing. I would recommend that you use a backup to restore the database. If you don’t have one yourself, ask your hoster’s support team about this. * [Shubham Patil](https://wordpress.org/support/users/iamshubhamsp/) * (@iamshubhamsp) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18367343) * Hello [@themavo](https://wordpress.org/support/users/themavo/) Try repairing your DB using phpmyadmin: [https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin](https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin) * Thread Starter [themavo](https://wordpress.org/support/users/themavo/) * (@themavo) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18368517) * Hi, [@catacaustic](https://wordpress.org/support/users/catacaustic/) * I looked in to my wp-config.php file and typed in my correct username and password. For some reason, those had both been missing. * There’s one more line that I’m unsure of: /** The database collate type. Don’t change this if in doubt. */define( ‘DB_COLLATE’, ” ); * That line I left alone. * However, even after inserting my username and password, I still receive the error that the database can’t be found. The error page looks a bit different though. But still no database found. * Moderator [threadi](https://wordpress.org/support/users/threadi/) * (@threadi) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18368521) * If the error message * > wp_options: Table ‘themavo.wp_options’ doesn’t exist in engine * or is it * > Database not found * ? * Thread Starter [themavo](https://wordpress.org/support/users/themavo/) * (@themavo) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18368528) * Thanks for your reply, [@threadi](https://wordpress.org/support/users/threadi/) * Right now, the entire site is simply housed on a dedicated external hard drive connected to my workstation. XAMPP software is installed so I can use that drive as a server. I connect to the site via localhost. After my initial work on the site is complete, I will move it to an actual webhost. * To create backups, I’ve just been copying all the files on that drive to a location on a separate drive. I actually have a few copies from different dates. * Given all that, what’s the best way to restore the database? Which specific files from the backup need to be copied back to the original WordPress drive? And in which folders should those files be copied from and to? * Thread Starter [themavo](https://wordpress.org/support/users/themavo/) * (@themavo) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18368541) * [@threadi](https://wordpress.org/support/users/threadi/) * Currently, when I try to connect to my WordPress dashboard via localhost, the message states: * **Error establishing a database connection** **This either means that the username and password information in your `wp-config.php` file is incorrect or that contact with the database server at `localhost` could not be established**… * This is after I had gone into the wp-config.php file and typed in the correct login credentials. * Moderator [threadi](https://wordpress.org/support/users/threadi/) * (@threadi) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18368679) * Then the credentials data is obviously not correct. Double check which are the correct ones. If you use XAMPP, you must be able to find the access data for your database in its administration or define it yourself. * Thread Starter [themavo](https://wordpress.org/support/users/themavo/) * (@themavo) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18369395) * [@threadi](https://wordpress.org/support/users/threadi/) * Um…Specifically, with XAMPP, how do I find my database’s access data or define it myself? When it comes to coding or server-related issues, I’m not savvy. * Moderator [threadi](https://wordpress.org/support/users/threadi/) * (@threadi) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18369401) * I do not know XAMPP for this, which is not a topic here in the forum. I would recommend you to contact their forum: [https://community.apachefriends.org/f/](https://community.apachefriends.org/f/) * Thread Starter [themavo](https://wordpress.org/support/users/themavo/) * (@themavo) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18371031) * Hi, [@iamshubhamsp](https://wordpress.org/support/users/iamshubhamsp/) * Just to be clear, the only file I’m trying to repair via phpMyAdmin the one named** wp-config.php**. Is that correct, or are there other files I’m supposed to be looking into as well? * I can’t seem to find a file with that name in phpMyAdmin. * Thread Starter [themavo](https://wordpress.org/support/users/themavo/) * (@themavo) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18371037) * Thanks, [@threadi](https://wordpress.org/support/users/threadi/) . I posted an inquiry at the Apache Friends discussion board. * Thread Starter [themavo](https://wordpress.org/support/users/themavo/) * (@themavo) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18371041) * Hello, [@catacaustic](https://wordpress.org/support/users/catacaustic/) Thanks for your input. * Inside the wp-config.php file, I corrected the username and the password. Are there other steps I must take within that file or elsewhere to ensure the correct permissions for a given user? If yes, please let me know. * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18371350) * If you are having this many problems with XAMPP then I’d suggest ditching that and using something like [Local](https://localwp.com/) for development. It takes away all of the issues that you’re facing now and sets it all up for you. * [Shubham Patil](https://wordpress.org/support/users/iamshubhamsp/) * (@iamshubhamsp) * [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/#post-18371734) * [@themavo](https://wordpress.org/support/users/themavo/) You will not get wp- config.php file in phpmyadmin. Can you try this few steps?1. **Incorrect database prefix** – Your table prefix might be different (e.g., `wp_` vs. `themavo_`). 2. **Incomplete migration** – If you moved the site, the database export/import may have failed.3. **Check if your DB is corrupted.** * **Enable WP Repair in `wp-config.php`** 1. Open your `wp-config.php` file in your root directory. 2. `define('WP_ALLOW_REPAIR', true);` 3. Save the file. Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/database-errors-84/page/2/?output_format=md) [→](https://wordpress.org/support/topic/database-errors-84/page/2/?output_format=md) The topic ‘Database Errors’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [optimization](https://wordpress.org/support/topic-tag/optimization/) * [repair](https://wordpress.org/support/topic-tag/repair/) * [WordPress](https://wordpress.org/support/topic-tag/wordpress/) * [wp_options](https://wordpress.org/support/topic-tag/wp_options/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 24 replies * 4 participants * Last reply from: [themavo](https://wordpress.org/support/users/themavo/) * Last activity: [1 year, 1 month ago](https://wordpress.org/support/topic/database-errors-84/page/2/#post-18379404) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics