WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Can't find any tables in wordpress database (7 posts)

  1. gpsfreak
    Member
    Posted 1 year ago #

    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.

  2. graphical_force
    Member
    Posted 1 year ago #

    Do you see anything when you click on the table in PhpMyAdmin?

  3. gpsfreak
    Member
    Posted 1 year ago #

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

  4. graphical_force
    Member
    Posted 1 year ago #

    Is that the only database you have in phpMyAdmin?

  5. gpsfreak
    Member
    Posted 1 year ago #

    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.

  6. gpsfreak
    Member
    Posted 1 year ago #

    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.

  7. gpsfreak
    Member
    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic