Importing sql to new version.

[Commie]

I had an older snapshot installed on another server that I no longer have access to. I had exported the data from OSC to an .sql file. I installed the latest version of OSC and want to import the .sql to the mySQL database.

 

Will this work? Or should I install the old snapshot, import the database then upgrade?

 

If I have to install an older snapshot where can I find them?

 

Thanks

[mattice]

It depends, if the snap is older and the db structure has changed it will NOT work and you should get the older version installed first and work from that. Or you could examine the db structure and manually / partially restore the db contents.

 

All older versions can be retreived from the CVS server at sourceforge.

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/tep/

 

HTH

Mattice

[Commie]

I don't remember which version I was using but it was the beta that was just turned into a milestone. My snapshot wasn't too old. I think it was the february of this year.

[kwit]

you should use mysqldiff.pl script included in extras of the MS1 package.

 

use

 

perl mysqldiff.pl olddatabase newdatabase >changes.sql

 

where new database is oscommerce.sql coming with MS1 and olddatabase is your old db.

 

just upload to mysql your old db and then upload

changes.sql - that should work.

 

Dmitry

[Commie]

Thanks, I'll give that a try

[falconpilot]

How do I import an SQL file to my database and will this screw up any of my data currently in my sql database. Thanks for your help.

 

falconpilot