Database Info Won’t Show Up On Site After Being Restored

  • Resolved rjlicata

    (@rjlicata)


    14 years, 6 months ago

    Here’s a quick background on how I ended up here:

    My SimpleScripts page said my WordPress version needed an update. I updated it, but when I did something wasn’t right and my site was getting a bunch of error messages when I looked at it in my browser. I restored a previous version and things were ok, for the most part, but I was unable to open the plugins page on my WordPress Dashboard. Something about not enough memory (sorry, I’ve seen so many error messages I don’t remember exactly.)

    Anyway, somewhere throughout the process of me restoring older versions, then newer versions, then back to old, WordPress reinstalled itself. It didn’t overwrite any of my files (the site structure is still in perfect shape) but there are no longer any posts, pages or comments. The database is still there (according to phpMyAdmin), and I have a backup that I tried restoring, but for some reason it’s not linking to the WP install. It’s basically a “Hello World” WordPress site, with my theme and structure.

    I checked the WP-config and the database, username and password all seem to match up. phpMyAdmin shows all the tables still there and their contents seem correct too. It just won’t show up when I visit my URL in the browser.

    Any ideas? Please help. Thanks!

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

  • if all you say is true, then the $table_prefix in wp-config.php was changed
    make sure it is the same as the one in phpmyadmin

    Thread Starter rjlicata

    (@rjlicata)

    Thanks for the respone…

    I was hoping all that was true, now I’m not so sure. Where can I find the $table_prefix in phpmyadmin? I did some checking on other wp-config pages and the prefix is the same for all my wordpress installs.

    I’m fairly certain the username and database name is good. Is it possible the password is different? Does the new install give me a different password? How can I check the password in my database?

    Thanks again for your help and I’m sorry if I’m being a bonehead here. This is my first experience in the guts of a database and I’m trying to feel my way around.

    if you were connecting to the old database you would have never installed fresh
    log in to phpmyadmin
    click on the old database
    note the prefix in front of the table names – i.e. coments, options, etc.
    make sure this is the exact same as in wp-config.php you are using to connect to site

    Thread Starter rjlicata

    (@rjlicata)

    yes the prefix is the same both places.

    Thread Starter rjlicata

    (@rjlicata)

    Is there anything else I could be doing wrong? I’d really like to get this site back up and running.

    Thread Starter rjlicata

    (@rjlicata)

    It was a corrupt backup that I was using…Hostmonster helped me reinstall a backup they had. All is well.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database Info Won’t Show Up On Site After Being Restored’ is closed to new replies.

Tags