New and ready to learn!

[ozogo]

wow. i actually have been able to get the diff file to run
all but one part// the orders section

!?

[ozogo]

Data base transfer no luck for me this week. I have learned alot. But the data is not falling into the correct places. It is breaking the site. the customers are not connecting with the orders. the products are not connecting with groups. It just isn't working. I am thinking that i'll need to go through the entire database line by line and match them up again but I don't have much faith that it is going to work when I do because I was sure I did that the last time I tried. If i can't get this database to transfer I don't know if it is worth doing.

[ridexbuilder]

Use mySQL Front - no more clues

[ozogo]

I can't get it to log into my data base.. this mysql front.. I'm cursed with ignorance. Sorry to have waisted all of your time..

[michael_s]

Check in your hosting account control panel. Your host may provide phpmyadmin or some other database editing tool. It does the same thing as mysqlfront, but will have local access to all your datbases. That gets you over the connection hurdle.

[ozogo]

Thank you, I was using my phpadmin for the last 2 weeks along with mysql diff.. I got it to fix all tables but orders section/ and it wouldn't change the laugauge so I did that manually. I have been unsuccessful so will try again. I assummed that ridexbuilder was pointing me in a direction that would help me migrate my osc to oscmax more efficiently that mysqldiff. One more rabbit hole to fall down.

Any thoughts on integrating quantity price breaks per product to oscmax? I'm not sure how to install it because the code has been changed and conflict for i think the customer group modifications.

if I make the oscommerse data base structure exactly like the oscmax structure / I can import oscommerce into oscmax and be done with it...

am I understanding this correctly?

Thanks

[michael_s]

Yes, that is the point of using mysqldiff to update the structure. It just takes a few minutes to update the structures, not sure why you are having so much trouble. The orders table should not give you any problems either, pretty straightforward.

Post the error you are getting and the the sql from mysqldiff (what it is trying to do to your original table).

[ridexbuilder]

I was eluding to making it (a good deal) easier to do the migration.
You need to allow your IP address to do Remote SQL, in cPanel.

Jeez, where's my white stick...
[No berating intended, for those Politically Correct-sensitive souls out there ]

[ozogo]

I posted the mysqldiff sql one before and was it caused havok with the forum somehow I was requested to delete it and did.

I have 3 assortments.

1. The opening lines on the diff file cause error:

#
# MySQLDiff 1.5.0
#
# MySQLdiff - checking for differences in database structures
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 25.03.2010 17:09
#
# --------------------------------------------------------
# Source info
# Host: localhost
# Database: fractals_noniheals
# --------------------------------------------------------
# Target info
# Host: localhost
# Database: fractals_hnoni
# --------------------------------------------------------
#
SET FOREIGN_KEY_CHECKS = 0;
#
# DDL START
#

I removed that...


2. the original mysqldiff sql/ problem = the defult 0 in the first line of each statement

Example: admin_id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,

Changed All:
admin_id int(11) NOT NULL COMMENT '' auto_increment,

3. The Order tables would not process

Actually in working with the order tables one line at a time: the add sections were all that would not go

ADD customers_dummy_account tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER customers_address_format_id,
ADD paypal_ipn_id int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER currency_value,
ADD fedex_tracking varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE utf8_general_ci AFTER paypal_ipn_id,
ADD purchased_without_account tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER fedex_tracking,
ADD shipping_tax decimal(7,4) NOT NULL DEFAULT '0.0000' COMMENT '' AFTER purchased_without_account,

ADD INDEX idx_orders_customers_id (customers_id), DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

*I added them manually eye to eye with the oscmax data base as reference.

4. In doing that I found that the launguage had a difference/ and in running a new mysqldif on the updated database I got a sql that attempted to change all of the laungauge settings but it didn't work

Example: collation latin1_swedish_ci / to uft8_general_ci

After I updated laugage manually for each line everything seemed to be accessible through the site but all a hodgepodge, nothing linking up.

Thank you,

John