Transfer from OSC to OsCMax.

**pnunn** · 01-12-2005, 12:40 AM

Hi folks,

I've just been setting up a site with OSC for the first time and been getting there but its been a struggle.

I've finally got it sort of working (locally at this stage) and have done some configuration of the stylesheet and put some data in the database. I've installed some contributions (and had trouble with some) and have now... discovered Max (which I wish I'd found ages ago).

So.. is there an easy way of migrating from a standard OSC to a Max install without loosing all the data/attributes and css that I've got going so far?

Thanks.

Peter.

**michael_s** · 01-12-2005, 08:15 AM

Fairly easy if you are familiar with mysql.

You can save your stylesheet.css and replace the one in the osCMax template (/catalog/templates/[templatename]/. That will keep your style changes.

The database is where you will be tested if you do not have much mysql experience. Get a db comparison tool like mysqldiff (google it) and use it to compare data structures. Then, with the mysqldiff output, upgrade the database by running the output as a batch query using phpmyadmin or some other mysql front end (gui). I suggest making a copy of your database and running the query on the copy. That way if anything goes wrong (low risk, but better to be safe!) you have the original data safe and sound.

Then you will need to export the product, customer, attribute and order info to a batch file and import into the max db.

Here is a thread on upgrading Zencart to osCMax. It uses a different batch file, but the process is the same. It may provide some insight:

http://oscdox.com/PNphpBB2-viewtopic...t-zencart.html

**pnunn** · 01-13-2005, 04:08 AM

Thanks Michael,

I'll take a look at this and see how I get on. I'm guessing you think the move is worth the effort? I've finally got EasyPopulate working on the other site, but I'm not sure what else I'm missing out on to be honest.

Any comments?

P.

**paulzag** · 05-19-2005, 03:58 AM

Originally Posted by msasek

Then you will need to export the product, customer, attribute and order info to a batch file and import into the max db.

Here is a thread on upgrading Zencart to osCMax. It uses a different batch file, but the process is the same. It may provide some insight:

http://oscdox.com/PNphpBB2-viewtopic...t-zencart.html

And remember to export address_book table. I forgot it and just spent 45 mins trying to work out why I'd get errors when editing customers.

**mq-james** · 05-31-2005, 10:07 AM

Hi, I've had no joy with this, mysql diff I couldn't figure out, could you write a how to or something please? Thanks

**michael_s** · 05-31-2005, 10:41 AM

Sorry, I do not support mysqldiff. It comes with instructions on how to install and use it that are very easy to follow. I already wrote a how to several posts up.

**paulzag** · 06-01-2005, 05:06 AM

Originally Posted by mq-james

Hi, I've had no joy with this, mysql diff I couldn't figure out, could you write a how to or something please? Thanks

Make sure you are using the correct mysqldiff (google showed me a few).

http://www.mysqldiff.org/

is the one you want. It really is fairly self explanatory. Let me know if you're having problems (be specific) and I'll see if I can suggest anything.

Note: If you aren't comfortable using mysqladmin and similar tools then you should find someone who'll do the transfer for you.

Regards

Paulzag