Title: Problem restoring database from sql file Last modified: August 19, 2016 --- # Problem restoring database from sql file * [DSB](https://wordpress.org/support/users/dsb/) * (@dsb) * [17 years, 3 months ago](https://wordpress.org/support/topic/problem-restoring-database-from-sql-file/) * 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](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](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [17 years, 3 months ago](https://wordpress.org/support/topic/problem-restoring-database-from-sql-file/#post-1011106) * 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](https://wordpress.org/support/users/dsb/) * (@dsb) * [17 years, 3 months ago](https://wordpress.org/support/topic/problem-restoring-database-from-sql-file/#post-1011178) * 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](https://wordpress.org/support/users/figaro/) * (@figaro) * [17 years, 3 months ago](https://wordpress.org/support/topic/problem-restoring-database-from-sql-file/#post-1011179) * > 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 * [sql](https://wordpress.org/support/topic-tag/sql/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 3 replies * 3 participants * Last reply from: [figaro](https://wordpress.org/support/users/figaro/) * Last activity: [17 years, 3 months ago](https://wordpress.org/support/topic/problem-restoring-database-from-sql-file/#post-1011179) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics