LeaseahB
Member
Posted 6 years ago #
I may be trying to do too many things at one time.
I had an existing WP 1.5 blog on the old web host. On the new web host, I did a fresh install of WP2 and had it create a new MySQL database. I have created a sql file of the old database. I'd like to be able to insert the posts from the old database into the new database. I'm getting an error that the column count doesn't match up (the new database has 3 extra columns in it). I'm hoping that someone has an easy answer for this :)
Thanks for any help you can give!
Lisa B.
You must upgrade the db.
Install 1.5.2 and import the .sql file
Then upgrade the blog to 2.0.1
Then export the .sql and import it into the new 2.0.1
You have to upgrade though or as you've found out it errors.
i am not savvy with databases
Okay - i want to do something simialr - but from 2.01 to a 2.01 version of the site.
But i want to change the domains completely.
i install new blog and then restore mySql file - and i find my self being redirected to different place - broken URLS etc. I try to edit the options but i find myself back at the old domain and the links all redirected to the new domain.
What do i need to remove/edited in the sql file to import everything [posts comments users categories ect ] into the new domain
Does this make any sense ?!
Find the wp-options table data in the .sql file. Search through it for the two areas with the old domain address and change them to the new domain address, following exactly the pattern shown in the old address. Then empty the wp-options table in your new install database, copy the entire wp-options table data from the .sql file into the sql query window, click go.
Then see where you are.
Many thanks vkaryl - worked like a charm !
gMk
vkaryl