• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 75
  • Last Modified:

Error establishing a database connection at http://nvbcl.org

Error establishing a database connection at http://nvbcl.org

updated a sql db username now getting this message. I've checked on how to fix but the fix isn't working:

I used this to repair:

define( ‘WP_ALLOW_REPAIR’, true );

now I get this:

WordPress
The wp_users table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_users' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_users table. Error: Table 'db12356_nvbvcl.wp_users' doesn't exist

The wp_usermeta table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_usermeta' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_usermeta table. Error: Table 'db12356_nvbvcl.wp_usermeta' doesn't exist

The wp_posts table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_posts' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: Table 'db12356_nvbvcl.wp_posts' doesn't exist

The wp_comments table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_comments' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_comments table. Error: Table 'db12356_nvbvcl.wp_comments' doesn't exist

The wp_links table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_links' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_links table. Error: Table 'db12356_nvbvcl.wp_links' doesn't exist

The wp_options table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_options' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_options table. Error: Table 'db12356_nvbvcl.wp_options' doesn't exist

The wp_postmeta table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_postmeta' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_postmeta table. Error: Table 'db12356_nvbvcl.wp_postmeta' doesn't exist

The wp_terms table is okay.

The wp_term_taxonomy table is okay.

The wp_term_relationships table is okay.

The wp_commentmeta table is okay.

Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.


wp_users: Table 'db12356_nvbvcl.wp_users' doesn't exist
wp_usermeta: Table 'db12356_nvbvcl.wp_usermeta' doesn't exist
wp_posts: Table 'db12356_nvbvcl.wp_posts' doesn't exist
wp_comments: Table 'db12356_nvbvcl.wp_comments' doesn't exist
wp_links: Table 'db12356_nvbvcl.wp_links' doesn't exist
wp_options: Table 'db12356_nvbvcl.wp_options' doesn't exist
wp_postmeta: Table 'db12356_nvbvcl.wp_postmeta' doesn't exist

I"m having issues finding where the table is to repair within the php admin window though. Anyone have any ideas or suggestions?
0
Quack
Asked:
Quack
  • 4
  • 2
  • 2
1 Solution
 
David SankovskySenior SysAdminCommented:
What sort of access do you have to server? or better yet, what sort of server is this?
If you have full administrative access to the entire server, you should be able to install phpmyadmin, if it's a shared server start by making sure that you have all the data in the wordpress configuration written down correctly, it's possible that WP can't find the tables because the db name is wrong.

Also, if it's a shared server but you are migrating from a previous hosting company, make sure you have a correct DB dump.
0
 
QuackdeveloperAuthor Commented:
Grid server via media temple...I can get into phphmyadmin but I'm not seeing any crashed table to repair
0
 
Alicia St RoseOwner & Principle Developer/DesignerCommented:
Hi! You need to update the database user name in the wp-config.php file.

wp-config.jpg
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
QuackdeveloperAuthor Commented:
I've tried a work around just to get the site back up but it didn't take. I've modified the wp-config file...tried the repair too...not working
0
 
QuackdeveloperAuthor Commented:
Ok...I went back to the previous db. Ran the repair process again. Got the same message/s about the tables.

Its saying these don't exist:

wp_users: Table 'db12356_nvbvcl.wp_users' doesn't exist
wp_usermeta: Table 'db12356_nvbvcl.wp_usermeta' doesn't exist
wp_posts: Table 'db12356_nvbvcl.wp_posts' doesn't exist
wp_comments: Table 'db12356_nvbvcl.wp_comments' doesn't exist
wp_links: Table 'db12356_nvbvcl.wp_links' doesn't exist
wp_options: Table 'db12356_nvbvcl.wp_options' doesn't exist
wp_postmeta: Table 'db12356_nvbvcl.wp_postmeta' doesn't exist
wp_termmeta: Table 'db12356_nvbvcl.wp_termmeta' doesn't exist

Is there a work around in wordpress for this? is there a way to find these? of course I don't have a db backup...my bad yes...Media Temple can provide one for $79.00 of course. may have to eat that and get this back up. lame.
0
 
David SankovskySenior SysAdminCommented:
What's the name of the DB you see in phpmyadmin? does it match the one in the error code?
Do you see a Database named db12356_nvbvcl?
if so, do you see the tables inside that DB?

Have you made sure that your DB username and DB Pass match the one in your wp-config.php file?

And no, there is no way around this, WP only works with a database.
0
 
Alicia St RoseOwner & Principle Developer/DesignerCommented:
Quack, you can, alternatively, install a database plugin and back your site up to dropbox, Google Drive, your server or have it emailed to you.

I like this one:

https://wordpress.org/plugins/updraftplus/

And it's not lame to back up your site regularly. It's actually recommended.
0
 
QuackdeveloperAuthor Commented:
there was no recourse from media temple for this so I was left "out in the cold" ... very disappointed with their efforts. This suggestion was the best way forward... Lessons learned. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now