merge osc2 to oscmax2?

[chrismole]

I have an old store in the original osc2 format. I want to somehow merge all the data from the old osC2 store db to a new oscmax2 store db. Is it possible? I tried merging the databases with mysqldiff, but no luck (unless I did it wrong).

I would think there's some way to merge the data and fix one-off problems as I find them.

Any help is much appreciated.

C

[michael_s]

mysqldiff is the only way. You do not merge though. You upgrade the db structure of the osC standard database to match the structure of the osCMax2 db, then export the updated data from the osC standard database. Finally, import the data to the original osCMax 2 database. Done.

That is the easiest way to use mysqldiff to get the job done.

[chrismole]

Thanks for the help.

I tried your suggestion and ran into sql errors in phpmyadmin when running the mysqldiff-generated update script to run on the osc2 exported database. The script could not get past creating the first table (admin). This looks like it's going to be a tough nut to crack.

See the attachment for the sql error.

Any help is much appreciated. Could the error be related to the settings in mysqldiff that get prompted just before creating the update sql?

Thx,
C

[chrismole]

Anyone have any ideas on merging databases? Has anyone done it succesfully?

Thx,
C

[chrismole]

Ok, I got the databases merged, but when I try to bring up the store index page, I am getting session errors:

Warning: session_start(): open(SESSION_WRITE_DIRECTORY/sess_04da8a2b38472a96a9253cd0d3b756c9, O_RDWR) failed: No such file or directory (2) in /includes/functions/sessions.php on line 99

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /includes/functions/sessions.php:99) in /includes/functions/sessions.php on line 99

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /includes/functions/sessions.php:99) in /includes/functions/sessions.php on line 99
Illegal template directory!
Warning: Unknown(): open(SESSION_WRITE_DIRECTORY/sess_04da8a2b38472a96a9253cd0d3b756c9, O_RDWR) failed: No such file or directory (2) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (SESSION_WRITE_DIRECTORY) in Unknown on line 0

Does anyone know how these errors could be fixed? I did a code search for "SESSION_WRITE_DIRECTORY", but could not find it. As an all caps variable, I thought it would be plainly defined somewhere...

Any help is appreciated,
C

[spottedhaggis]

I am currently doing this exact same thing, and after a good 2 days fiddling, restarting it all, and trying again and again, I am now at a near 100% completed stage.

I have one more bug to get rid of. When in admin, goto customers, all clients are listed, goto edit and I get the following error message.

Warning: reset(): Passed variable is not an array or object in /home/***********/public_html/oscmax/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /home/***********/public_html/oscmax/admin/includes/classes/object_info.php on line 18

Other than that most, if not all (I am not done checking it all yet) is working, 580 products, 22 categories with sub categories, everything is so far so good.

incidentally, I have found that using an application called sqlyog works far better and is alot faster when working with 2 database files (can copy from one to the other in a click.

[kopoba11]

I woud recommend not to export configuration tables from Old version.
Just export customer and product data.
Do not export admin and configuration data.

The error you are getting with sessions, since they are in DB by they no longer exists, do not export session table.

Later

[tridian]

I am currently doing this exact same thing, and after a good 2 days fiddling, restarting it all, and trying again and again, I am now at a near 100% completed stage.

I have one more bug to get rid of. When in admin, goto customers, all clients are listed, goto edit and I get the following error message.

Warning: reset(): Passed variable is not an array or object in /home/***********/public_html/oscmax/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /home/***********/public_html/oscmax/admin/includes/classes/object_info.php on line 18

Other than that most, if not all (I am not done checking it all yet) is working, 580 products, 22 categories with sub categories, everything is so far so good.

incidentally, I have found that using an application called sqlyog works far better and is alot faster when working with 2 database files (can copy from one to the other in a click.

Hello Spottedhaggis, did the fix kopoba11 suggested work for you on this? I am having the exact same problem you did, I have everything ready to go w/ my migration but once I import my customer info, I keep getting the same errors that you received. I'm not that capable in mysql so kopoba11's suggestion isn't totally clear to me. Can you advise? Thanks very much!

[tridian]

Just a quick note to all say that the reason I was getting that PHP Error was because I had not populated the "address_book" in my osCMax database yet so that left the "customers_default_address_id" id unset thus giving me the error. Once I populated the address_book in the database, the problem was gone. I'm learning!