Forums

[resolved] Database restored but no blog? (12 posts)

  1. jbevans
    Member
    Posted 3 years ago #

    For some reason, my site crashed. I do backup the site every day and have that backup on hand.

    After discussion with my hosting company, I deleted everything, reinstalled WordPress and attempted to restore the database. Using phpMyAdmin, I uploaded the database to wrdp_1. The upload finished with a note that "Import has successfully finished. 2340 queries finished." But when I go to the site and log-in it appears as nothing has been restored and the site looks like a brand new install.

    What am I missing?

    Thanks

  2. slylake
    Member
    Posted 3 years ago #

    First thing that leaps to mind for me is this question:

    Was the core file structure of WordPress that you re-installed to your site, after blowing away everything on your server, the same version of WordPress that your database is expecting?

    i.e. have you uploaded the most recent version of the wordpress install and a previous version's database?
    If so, you might need to "upgrade" the database by pointing your browser to the upgrade path.

    If not, please confirm.

  3. jbevans
    Member
    Posted 3 years ago #

    When the hosting company cleaned everything up, they left wrdp_1. However the new install created wrdp_2 and that is where I had to restore to, not _1. Doing so seem to work perfectly and the files were all visible on the back end. However I cannot get any of them to preview and I cannot see the site.

    I now get a 404 error that the requested url was not found on this server. So I need help with that now.

    Anyone?

  4. jbevans
    Member
    Posted 3 years ago #

    Slylake...

    The WordPress version now on the system is 2.6.5.

    The database was just 2.6.

    How to a re-point the browser to the upgrade path and upgrade the database?

    Thanks!

  5. slylake
    Member
    Posted 3 years ago #

    I'm still not 100% convinced that this is the problem. However, given that you have a backup, this is worth a try.

    URL for upgrade:
    http://www.YOURSITEHERE.com/INSTALL_DIRECTORY/wp-admin/upgrade.php
    *replace "YOURSITEHERE" with your actual site URL.
    *replace "INSTALL_DIRECTORY" to the directory you have installed WP to, if any.

    Full Upgrade instructions:
    http://codex.wordpress.org/Upgrading_WordPress

    Be interested to know how you go.

    If you have the 2.6 original install files lying around.. might be worth uploading that to a subdomain (such as http://sandbox.yourdomain.com) and then updating the wp-config.php with the original wrdp1 database details and seeing if it will work.

    Also, may be worth trying a backup from the day before or similar, i.e. a last known working backup.

  6. jbevans
    Member
    Posted 3 years ago #

    It is in the same sub directory the original one was in.

    The site is http://www.escoc.net

    The blog is at blog.escoc.net

    WordPress is installed in the root of blog.escoc.net.

    The original database is still present (wrdp_1) should it be deleted?

    I do not have the 2.6 install files.

    To be clear, the backend seems to work perfectly. It's only when I try to preview a post or View Site that I have a problem.

    Bryant

  7. slylake
    Member
    Posted 3 years ago #

    ahh!!

    abort everything I said.

    You've got the "dreaded white page" error.

    There seems to be an array of different reason for this error. Most that I have experienced myself first-hand have been courtesy of the theme in use.

    Firstly, try (via the admin panel) using a different theme. Does the site now display?

    Have you renamed the theme directory before re-uploading it to the host?
    Have you tried uploading your theme files again? (FTP can be flaky sometimes, especially if your host is on windows).

  8. jbevans
    Member
    Posted 3 years ago #

    That was it!

    The default theme was set. I changed to the WordPress Classic and it popped right up.

    Next I will re-load the theme I was using.

    If you are ever in coastal Alabama I know a great seafood place that I will take you to. Just let me know!

    Thanks

  9. slylake
    Member
    Posted 3 years ago #

    You beauty!

    If re-uploading it a couple of times doesn't help (also try removing the theme if you have a local copy of it and re-uploading it from scratch).

    Try to back-track your last steps with any "tweaking" you've done to the theme:

    - Renaming the parent directory/folder of the theme files.
    - Code edits within the .php or CSS pages
    - New plugins installed and activated etc

    Anything you can think of.. and try to roll back your changes step by step. Eventually one will make the old theme re-appear... As far as I can tell, the latest update to WordPress is essentially a security fix. As such, themes from the previous version should still work. (Hey, in theory everything works).

    Mate, if I am ever in coastal Alabama, I'd love that. Highly unlikely that I will be, as I am from the "Sunshine Coast" in Australia. But, the way this world spins, who knows what will happen next! :)

    Glad I could be of (very little) help. I'll keep checking the thread for a final resolution.

    Cheers,
    Dan

  10. jbevans
    Member
    Posted 3 years ago #

    Update.

    I reinstalled the theme from scratch along with the plug-ins. The front end is now visible. However the individual posts are not. In other words, I see them on the main page but when I try to click on one I get a 404 error.

    Any thoughts?

  11. jbevans
    Member
    Posted 3 years ago #

    Had to change the permalinks style which required recreation of the .htaccess file.

    All is now well.

  12. slylake
    Member
    Posted 3 years ago #

    Great to hear you got it all sorted out JB!

Topic Closed

This topic has been closed to new replies.

About this Topic