Moving products from v2.2 RC2a to a fresh 2.3.1

[hello6470]

Hi

 

I have a shop running on a v2.2 RC2a, and I've been thinking about finally changing it to fresh and clean 2.3.1 since the site had so many people participating in it that the code looks really bad and unstable.

 

My question is, how do I import all the products, categories, customers etc from my old shop to a new one?

 

 

I did the http://www.oscommerce.info/confluence/display/OSCOM23/%28SQL%29+%28UP%29+Update+Database+Field+Lengths suggested but whenever I install a new version, the database is cleared to default and I ran out of ideas...

[Guest]

You can import the categories, products, customers and orders to the new database using the phpmyadmin function of your hosting account.

 

 

 

 

Chris

[hello6470]

1. I install a new and fresh 2.3.1 on a new server with a new database

2. Modify the old database from 2.2 and export it to an archive

3. Import the archive to a new database over the one created with the install

 

 

Is that all ?

 

So far, unfortunately I get a

#1062 - Duplicate entry '58' for key 'PRIMARY'

error

 

Had to use REPLACE

 

now I don't see columns neither products on the shop, I think I have seen some article about this somewhere, hmm

 

also:

#1054 - Unknown column 'manufacturers_description' in 'field list'

[hello6470]

I don't know how I edited the post before because I don't see the EDIT button anymore :o.

 

I have added with ALTER TABLE a manufacturers description column and everything went well, now to fix the site to show the columns and products