WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] Can't find any tables in wordpress database

[Resolved] Can't find any tables in wordpress database

  • After installing v3.5.1, I created a wordpress post, but can’t find it in the database. The database has no wp_posts table as expected, and in fact it has no tables at all.

    The post shows up fine after I publish it, then surf to it from another browser window. After making a change to it and press update, again I see the change in the post. I even surfed to from a different browser to rule out browser caching if that had anything to do with it.

    From the wp-config.php file, the db name is ‘wordpress’:
    define(‘DB_NAME’, ‘wordpress’);

    phpMyAdmin shows wordpress db exists, but is empty and I confirmed this by accessing mysql directly. After “use wordpress;” and then “show tables;”, mysql reports there are no tables in the ‘wordpress’ database.

    So, I can somehow make posts that I can see with the browser, but cannot find any tables in the wordpress database. Any suggestions? Thanks.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Do you see anything when you click on the table in PhpMyAdmin?

    After clicking on the wordpress database, phpMyAdmin only offers to create a new table. No tables were found.

    Is that the only database you have in phpMyAdmin?

    I have several databases, but the relevant one is the one named litereally, ‘wordpress’. wp-config.php contains the line,
    “define(‘DB_NAME’, ‘wordpress’);”

    I was able to successfully install wordpress and verify the tables exist in another environment, so I have confidence I followed the installation procedure.

    Thanks for the help, but I’m still stuck. Really bizarre.

    After starting over with a new install, I can now see the tables in the wordpress database. Still don’t understand why I couldn’t see the tables in the first install.

    Anyway, thanks.

    I’m marking this a resolved, even though the original mystery remains.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Resolved] Can't find any tables in wordpress database’ is closed to new replies.
Skip to toolbar