Database Repair: Table "new_db.wp_ " doesn't exist

  • Resolved coleen_s

    (@coleen_s)


    10 years, 3 months ago

    I am trying to connect my localhost website to my database but got this following errors:

    wp_users: Table ‘acs_db.wp_users’ doesn’t exist
    wp_usermeta: Table ‘acs_db.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘acs_db.wp_posts’ doesn’t exist
    wp_options: Table ‘acs_db.wp_options’ doesn’t exist
    wp_postmeta: Table ‘acs_db.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘acs_db.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘acs_db.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘acs_db.wp_term_relationships’ doesn’t exist

Viewing 5 replies - 1 through 5 (of 5 total)

  • At first glance, it would seem that you’re either logging in to the wrong database OR your local WP installation did not create the tables it needs OR the login you are using does not have read access to those tables.

    Is your database also local?

    If you have access to something like PhpMyAdmin, log in there and see if you can find those tables in the acs_db database.

    Hi,

    Match database name in wp-config.php with database under phpmyadmin.This error may be due to your mismatched database name.

    Thread Starter coleen_s

    (@coleen_s)

    Thanks for the quick response guys.

    @cmshelplive I am currently using Navicat to manage my database, tried installing phpmyadmin but cannot access it. I also checked the database information in wp-config.php and they were a match.

    @mizagorn Yes, the database is also local. I am using Navicat and not phpMyAdmin in managing my local database as I tried installing phpMyAdmin but I can’t access it. I checked the said tables and it’s really not in the database. I am now trying to see if my user information does not have read access to these tables.

    Thread Starter coleen_s

    (@coleen_s)

    I already determined the problem, the problem exist because of the table prefixes. The table prefixes of my database tables are “o5gbc_” while in my wp-config file it’s “wp_”. I configured my wp-config.php to fix the problem.

    Thanks for the help guys.

    Thank , This is all I need, happy

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database Repair: Table "new_db.wp_ " doesn't exist’ is closed to new replies.

Tags