Title: Cannot import Last modified: August 19, 2016 --- # Cannot import * [mrflesh](https://wordpress.org/support/users/mrflesh/) * (@mrflesh) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/) * I just upgraded to 2.5 and now I can’t import my database. I just backed up in 2.3 and now when I try ti import it is telling me: * Please upload a valid WXR (WordPress eXtended RSS) export file. * What am I doing wrong? * According to my hosting service the data base is there, it just isn’t registering in wordpress. Viewing 8 replies - 1 through 8 (of 8 total) * Thread Starter [mrflesh](https://wordpress.org/support/users/mrflesh/) * (@mrflesh) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726619) * While looking around the export was saved to a .sql. Tried updating through my service provider phpmyadmin. They say the files are there but they are not showing up in wordpress. * [boober](https://wordpress.org/support/users/boober/) * (@boober) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726623) * is your config.php pointing to the correct database? you may have imported the sql to a new or different database, or with different suffix. * if all you were doing was an upgrade, why did you need to import your database? * Thread Starter [mrflesh](https://wordpress.org/support/users/mrflesh/) * (@mrflesh) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726629) * Hosting made error with another one of my blogs, also the previous installer had no ability to upgrade wordpress unless i did it manually. Since they have a new installer that they had to reinstall the other blog with I switched my current blog as well. I imported my old database into the new one, my hosting told me the file is there, but wordpress isn’t picking it up. What am i changing in the wp-config.php? Is there a way to convert the .sql file to a WXR and just import it through wordpress? * [Len](https://wordpress.org/support/users/lenk/) * (@lenk) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726638) * In your 1st comment you said you are getting this error message > “Please upload a valid WXR (WordPress eXtended RSS) export file.” * In your 2nd comment you said > “While looking around the export was saved to a .sql” * You’re not trying to upload a SQL file through the WordPress import interface are you? * Thread Starter [mrflesh](https://wordpress.org/support/users/mrflesh/) * (@mrflesh) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726641) * Initially yes that’s what I did I didn’t realize the backup and import feature used different file extensions. when I backed up my wordpress through backupwordpress it was saved as an SQl…i think as i can’t find any wxr. file extension on my harddrive. The only backups I can find are of my .sql backups * [Len](https://wordpress.org/support/users/lenk/) * (@lenk) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726648) * You’ll need to import that SQL file into your database using phpMyAdmin again. Easy instructions here, * [http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup) * Thread Starter [mrflesh](https://wordpress.org/support/users/mrflesh/) * (@mrflesh) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726652) * I got this error message * Error * SQL query: * — — Database: `hornymel_wrdp1` — — ——————————————————– — — Table structure for table `wp_ak_popularity` — CREATE TABLE `wp_ak_popularity` ( `post_id` int( 11) NOT NULL , `total` int( 11 ) NOT NULL , `feed_views` int( 11 ) NOT NULL , `home_views` int( 11 ) NOT NULL , `archive_views` int( 11 ) NOT NULL , `category_views` int( 11 ) NOT NULL , `single_views` int( 11 ) NOT NULL , `comments` int( 11 ) NOT NULL , `pingbacks` int( 11 ) NOT NULL , `trackbacks` int( 11 ) NOT NULL , `last_modified` datetime NOT NULL , KEY `post_id` ( `post_id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1; * MySQL said: Documentation #1050 – Table ‘wp_ak_popularity’ already exists * I did not get this error the first time I imported the database. Now popularity contest is broke in 2.5 and i had to remove the code from my blog for the rest of my theme to work. I can see all the files listed there. What do I do after I import it? Where do I use mysql commands? * I’t all been imported…the files are there. How do I clear the database for a clean import? * [Len](https://wordpress.org/support/users/lenk/) * (@lenk) * [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726678) * Podz had some excellent tutorials for beginners at his site. Look under PHPMYADMIN in left sidebar. * [http://www.tamba2.org.uk/wordpress/](http://www.tamba2.org.uk/wordpress/) Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Cannot import’ is closed to new replies. ## Tags * [Import problem](https://wordpress.org/support/topic-tag/import-problem/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 8 replies * 3 participants * Last reply from: [Len](https://wordpress.org/support/users/lenk/) * Last activity: [18 years, 1 month ago](https://wordpress.org/support/topic/cannot-import/#post-726678) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics