Importing product/manufactures/categories from old OSC sql databse

[Guest]

I had some problem when updateing osc, I'v got a old sql database with 200+ productes, categories, and manufactures etc. How can I easy import all of them into my new and working OSC?

 

I'v tried to replace the hole database with the old one, but it's not working, so now I think I need to import just

the section I want, into the new one.

 

Any one?

 

Please it's a bit urgent, because I'm supose to launch the site in a couple of dayes, and I don't have the time to add 200+ products manualy.

 

I'v got shell access to the server, and I'v phpmyadmin installed, that's my two options.

[♥Vger]

Take ALL of the product tables, including images links, from the old MySQL database and copy and paste them into a new text file. Then rename it with a .sql file extension (ignore the warning about changing the extension). Then go to your online database via phpMyAdmin, locate and click on the SQL tab and use it to import the products info from the old database into the new one using the Browse function to locate the sql file on your computer and then clicking the 'Go' button.

 

Vger

[Guest]

That was almost what I did, I took my to sql files, check the differents, and inserted all

insert_into_xxx and made a new .sql file, copy it to /admin/backups, and did a restore on my shop, it worked after some small changes.

 

but hey, thanks for the reply anyway.