This is a discussion on changing from ms2.2 to MAX 1.5.5 within the osCMax v1.7 Installation forums, part of the osCMax v1.7 Forums category; what steps have to be taken to transfer my data base (over 4000 products) from ms2.2 to the new structures ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| what steps have to be taken to transfer my data base (over 4000 products) from ms2.2 to the new structures in the Max 1.5.5? |
|
#2
| |||
| |||
| Guess hep is only available to those that rent space here? |
|
#3
| ||||
| ||||
| Geotex, did you ever think it was the weekend before Chirstmas, and we have lives???? This is a 100% volunteer forum. Sheesh, with that attitude, you are lucky I am in a good mood tonight. Usually I just ignore folks with bad attitudes. What you need to do is make a copy of your database. Then make a new DB that has the default MS2MAX structure. Then run mysqldiff (is included with the osCommerce and Max zip distros) to compare the copy you made with the MAX structure. Then copy the output and save it to a sql file on your computer. Then, run that batch file on your copied db. This will update the structures. Then you need to import the MAX data into the new structures in your database copy. So, export the data from the admin, admin_groups, configuration, configuration_groups, all the affiliate tables, and any other tables that are in the max database, but not in your original, to a batch sql file again. Then run that batch sql file on the copy. That is it. Of course, you will most likely hit some snags along the way, like sql errors becuase the addressbook table may use a different primary key, etc, in which case you will have to manually alter the table structure and data to tweak it. This entire scenario assumes you want to keep your entire existing database. If all you want is the products, run mysqldiff, and only use the sql that applies to the products tables. Then update the copy, and export the data. Then import it directly into the MAX database.
__________________ Michael Sasek osCMax Developer
|
|
#4
| |||
| |||
| Thanks for the reply. Sorry about the attitude. I do quite abit of volunteer consulting myself, so was really out of line. Anyway, your instructions are clear, and straight forward. Thanks again for the input. |
|
#5
| |||
| |||
| Quote:
EDIT: Nevermind, got Perl working with the help of a friend. But now when running the ALTER SQL commands generated by the mysqldiff.pl, I'm getting this: Quote:
|
|
#6
| |||
| |||
| I couldn't get the perl script to run or on the server due to data base security permissions (I'm on shared servers), or locally, on the Windows or Linux boxes (probably due due to my lack of knowledge of Perl). I compared the tables using mySQL Front, found the structures to be similar, then just emptied the tables I needed to transfer and uploaded an SQL file (no drop commands, just update) to populate all the products, customer and order tables. Left all the others populated with the MAX defaults. All seems to be working well, with no lost customers, orders, or products, passwords, addresses, etc. |
|
#7
| ||||
| ||||
| Geotex, Sandwich, the problem is that you are trying to change the primary key to a field that has non-unique data. You will have to change the 'address_book_id' data to be unique numbers. Then you should be able to change the primary key to this field.
__________________ Michael Sasek osCMax Developer
|
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| changing DATABASES? | doumawis | osCommerce 2.2 Installation Help | 2 | 02-08-2005 12:12 PM |
| URL changing in cart | leeb | osCMax v1.7 Installation | 5 | 01-16-2005 09:47 AM |
| Need help changing header | dave01978 | osCMax v1.7 Discussion | 2 | 12-14-2004 02:03 PM |
| changing the look of these pages | bagged89s10 | osCMax v1.7 Discussion | 1 | 12-19-2003 11:49 PM |
| Changing the stylesheet | mr_blue | osCommerce 2.2 Modification Help | 1 | 12-14-2003 11:16 AM |