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?
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?
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
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.
http://www.tamba2.org.uk/wordpress/