WordPress.org

Ready to get started?Download WordPress

Forums

WordPress not recognizing imported database (14 posts)

  1. Elizabeth
    Member
    Posted 2 years ago #

    I recently experienced the WordPress White Screen of Death and after no success with any of the general workarounds found on the internet, I decided to reinstall in another area of my website and restore from my latest site backup.

    I first uploaded my large database via phpMyAdmin but had to split the files because they were too large for phpMyAdmin to handle; all the posts, tags, categories, etc. imported successfully into the database but did not show up in WordPress admin anywhere. All I had in WordPress was the default "Hello, world!" entry. Checked my wp-config.php file and all of the various bits and pieces pointed to the correct database using the correct username and password combos.

    I dropped my tables, started from scratch, and reinstalled using Big Dump so that I could upload my SQL database intact without splitting it. Basically ended up with the same results where despite the fact that all my usernames and passwords match and that various files are pointing to the correct database, nothing is showing up on the WordPress admin end.

    I am at a loss and have no idea where to go from here.

    WordPress version 3.2.1
    Database version 18226

    My current URL that I am working in with no success: http://killsmedead.com/x/
    (The theme is from my previous installation, so the "Not Found" errors are legitimate and not worrisome as the content there depends on category IDs that aren't yet set-up in this WP installation.)

    Related threads I have read but that have not helped:
    http://wordpress.org/support/topic/help-imported-database-dump-not-being-recognized-by-wp
    http://wordpress.org/support/topic/install-doesnt-recognize-restored-database

  2. esmi
    Forum Moderator
    Posted 2 years ago #

    What happens if you install WP and do not import your database? Right now, it sounds like you have a db issue.

  3. Elizabeth
    Member
    Posted 2 years ago #

    Nothing happens, or rather when I first installed WP but before I imported the database, everything was as it should be on a fresh install (i.e. "Hello, World", one test comment, etc.). After importing the database, nothing changed even though all of the content of the database is there when I look in phpMyAdmin.

  4. esmi
    Forum Moderator
    Posted 2 years ago #

    everything was as it should be on a fresh install

    And can you publish posts successfully?

  5. Elizabeth
    Member
    Posted 2 years ago #

    Yup!

  6. esmi
    Forum Moderator
    Posted 2 years ago #

    Definitely sounds like there's a problem in your original database. Do you have any older database backups?

  7. Elizabeth
    Member
    Posted 2 years ago #

    I have nine more back ups from the last month and am slowly working my way back through restoring each of them when the last one hasn't worked but so far they're all yielding the same results.

  8. esmi
    Forum Moderator
    Posted 2 years ago #

    Any chance you could restore one of these backups without using Big Dump - just in case it is causing an issue?

  9. Elizabeth
    Member
    Posted 2 years ago #

    Good idea. Tried uploading the oldest back up I have via phpMyAdmin (had to split the files because they were too big, so I used SQL Dump Splitter) but had the same non-results.

  10. esmi
    Forum Moderator
    Posted 2 years ago #

    Anything in your error logs?

  11. Elizabeth
    Member
    Posted 2 years ago #

    Nothing! It's a completely invisible problem, I have no idea what's going on.

  12. esmi
    Forum Moderator
    Posted 2 years ago #

    Anything if you turn debug on and enable error logging?

  13. Elizabeth
    Member
    Posted 2 years ago #

    At this point I've become frustrated enough that I'm just importing my entries via the exports of my WP posts that I've done semi-regularly over the last year or so. I'll probably end up missing about a month's worth of entries but it's better than nothing.

    Thanks for your help!

  14. esmi
    Forum Moderator
    Posted 2 years ago #

    Sorry I couldn't help you get to the bottom of this. I hope the posts export goes OK.

Topic Closed

This topic has been closed to new replies.

About this Topic