Posted 4 years ago #
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.
Posted 4 years ago #
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.
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?
Posted 4 years ago #
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?
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?
Posted 4 years ago #
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
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
Posted 4 years ago #
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?
Podz had some excellent tutorials for beginners at his site. Look under PHPMYADMIN in left sidebar.
This topic has been closed to new replies.
