moving wordpress & upgrading

You cannot import a 1.2 db into a 1.5 db – it just does not work.

You need that export upgrading first.

Either:
– pass the sql file to someone who will upgrade it
– install a 1.2 blog, import the data, upgrade, export

I just upgraded the old blog at old domain to 1.5 (because it seemed easier than installing a 1.2 on my own at new place) and also did fresh install of 1.5 on new domain incase i broke something while trying to import db and then re-backed up/exported old domain db with 1.5 upgrade and when i tried to add it to new domain db i am getting categories table already exists error — this is it:

SQL-query:

— ——————————————————–
—
— Table structure for table wp_categories
—
CREATE TABLE wp_categories (
cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_name varchar( 55 ) NOT NULL default ”,
category_nicename varchar( 200 ) NOT NULL default ”,
category_description longtext NOT NULL ,
category_parent int( 4 ) NOT NULL default ‘0’,
PRIMARY KEY ( cat_ID ) ,
UNIQUE KEY cat_name ( cat_name ) ,
KEY category_nicename ( category_nicename )
) TYPE = MYISAM AUTO_INCREMENT =10

MySQL said: Documentation
#1050 – Table ‘wp_categories’ already exists

You need to use phpmyadmin to DROP all the tables in the new database first, then it should go okay.

that seemed to work fine (dropping the tables) — the posts made their way to the new installation — but once i logged in and went to “options” and put in the new correct domain name, it logged me out, and i couldnt get in with my password for my new domain or my old domain and when i got the login failure message it would take me to wrong location — for example it would go to https://newdomain.com/olddomainfoldername instead of the new location ….

i looked up the users table to see what the heck password i should be using and there was just a line of numbers that isnt my password.

hope this makes sense

Help please!

You need first to try making the site_url and home values correct. Do this by using phpmyadmin and looking inside the wp_options table – you must change both values though, not just the one.
There is some help at that tambawhatever link for that.

forgive my slowness… i am pretty much clueless about php/mysql (obviously)

so if my new installation already has correct info in options table for the new installation — then maybe I should just leave that instead of dropping it, importing table with old info and then having to change that to new? maybe i am screwing up by exporting/importing ALL tables? i really have no true understanding of what I am doing, just trying to follow directions that I can find.

all i really need to bring over is the posts, post archives, and categories …. should I be just exporting/importing the posts and categories tables and dropping those two tables before i import them or are there other tables that need to be imported too?

thanks for everyone’s help.

I’m a bit confused as to what is where.
From what I understand, you have created a new database, and into that imported new information.
When you then login at your new address, something breaks.
https://www.tamba2.org.uk/wordpress/site-url/
Using that, are both values correct ?
(Remember – no /index.php on the ends of the values, just addresses)

i am sure i am confusing the heck out of you all!

1. installation on new domain works fine before i mess with anything

2. i import all of the db tables from the old installation at old domain and everything seems imported fine, the posts are there and i can log in.

3. But when i log into admin and go to “options” and fix things (new domain address) it logs me out and wont let me back in as stated above

4. when i go into the options table and do as link you posted above says to do, … i still cant login and its doing the same wacky crap as posted above….not letting me login and looking like its going to new domain name but old wordpress installation foldername.

hm, I bet this didnt make anymore sense than last time. sorry, I’m trying!

3 sounds odd, and 4 sounds even odder.

When you put in the new ‘siteurl’ and ‘home’ values, do they look similar in style to this:
https:///www.example.com/blog

and you are definitely changing both the values ?

yeah, i followed the directions exactly and it was still doing that wacky crap ….I made even more new installations and imported again a couple times to be sure and same thing…. so I tried just importing everything except “options” and “users” tables and everything seems fine now as far as I can see with a little poking around — right logins and going to right pages — just seem to have lost my plug-ins but I can live with that. Hopefully there isnt deeper unseen hell to pay for what I’ve done to try to remedy the situation.

Thank you for all your speedy help, this is the first time I havent had to start over from the beginning when I’ve moved into new digs.

The problem is in wp_options then – the users table has no effect and could not cause the damage.

Quick note:

I was moving my blog to a new domain, I’d followed all the steps to the letter, but when viewing the blog on the new site, all the links were still pointing to the old domain. Drove me absolutely crazy.

Clearing out /wp-content/cache/ solved that pretty quick once I started thinking logically about it all.