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?
QuackdeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.