View Full Version : upgrading from 2.1 to 2.2

10-29-2003, 01:40 AM
I have running oscomerce 2.1 without problems....
I want to upgrade to 2.2
anybody could write a little HOW TO.????

Thanks in advance

10-30-2003, 09:52 AM
In all version of OSC (like MS2 and MS2-MAX) there is a perl utlity: \extras\mysql_diff\mysqldiff.pl

Utility to compare table definitions in two MySQL databases,
and output a patch in the format of ALTER TABLE statements
which converts the first database structure into in the second.
(takes MySQL database files or database name-direct)


Load your new version of OSC (like MS2 or MS2-MAX) database in to a new database and take your curent database version (or export your current one to a file) then use this perl script on both databases.

Good Luck

10-30-2003, 01:02 PM
MS2 and MS2-MAX, I didn't know MS2-MAX...

What is the differente betwen them.

mmmm so....
1.-I do a clean install of MS2.2........
2.-Convert database to new format WITH Mysqldifff
3.-Fix design and ccs styles....
4.-Pray hehehe

Thanks a lot.

10-30-2003, 01:40 PM
See - Project Progress on the left..... Find the link on the OSCDOX main page titled "AABox MS2-MAX v1.5 Released"

It has many of the popular MOD already installed like:

Basic Template Structure 1.0a Author: Brenden Vickery
Credit/Gift Voucher/Coupons 5.05 Author: Ian Wilson
Admin With Access Levels 2.1 Author: Zaenal Muttaqin
Download Controller v5.3 Author : Linda McGrath
And much more...

Setup and run a DEMO/TEST site for awhile. Import the default database. Use the perl script to make an ALTER table..... In phpMySQL create a copy of your live data - run the ALTER table on the copy and then try it on your DEMO/TEST site.