Problem restoring database from sql file

  • DSB

    (@dsb)


    15 years, 1 month ago

    Using 2.7.1.

    I tried a manual upgrade from 2.7 to 2.7.1, and I’m not sure what happened, but my WP dashboard was completely messed up after that. I finally opted to clean everything WP-related out of my host/server, and start completely from scratch. Now I have a fully functioning WP version once again, but of course, all my old entries were wiped out.

    I have an xml file which goes to the end of November 08. I tried importing that, but it says the file is too big. I can not find php.ini anywhere on my server to change the file size allowed.

    I also have an sql file, which goes to the end of February 09. I would rather use this file, because I was using 2.7 when this file was created, instead of the 2.6 something that I was using when the xml file I mentioned above was created. I followed the directions posted here: http://codex.wordpress.org/Restoring_Your_Database_From_Backup.

    I got a message on phpMyAdmin saying “Import has been successfully finished, 12464 queries executed.” Yet, none of my entries show up.

    I need to restore them if at all possible, but at this point, I am not sure what to do.

    Does it look like I may have done something wrong after all?

    Is there a way to convert this sql file to xml, then have my host point out my php.ini file so I can change file size, then try to import it from the WP import tool?

Viewing 3 replies - 1 through 3 (of 3 total)
  • MichaelH

    (@michaelh)

    15 years, 1 month ago

    The .sql restoration should have restored your database tables. Your posts would be in the wp_posts table.

    Might also want to update your permalink structure.

    Thread Starter DSB

    (@dsb)

    15 years, 1 month ago

    This may sound really stupid, but how can I tell if my posts are there? I clicked on that table, and there are a lot of options there, such as post_author and post_date and so on. I’ve never had to do this before, so I am really lost and just followed the directions as best I could.

    I’m also not sure about how to update permalink structure. If by that you mean updating my blog to the permalink structure I had before, I have done that.

    Thanks so much for trying to help!

    figaro

    (@figaro)

    15 years, 1 month ago

    I got a message on phpMyAdmin saying “Import has been successfully finished, 12464 queries executed.” Yet, none of my entries show up.

    Look at the table prefix of the tables that were imported. They may be anything, but by default they are wp_

    Then look in your wp-config.php file and make sure the prefix defined there is the same as what you have in your database.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Problem restoring database from sql file’ is closed to new replies.

Tags