Database import from oscommerce to oscmax --- Error

[chowhan]

Hello, everyone i am new to oscmax, i have been using oscommerce till now and all was fine but to make go better i got the oscmax installed . all went ok , , but as i restore the database to the new installed oscmax , all the Configuration from the oscommerce admin comes back. and when i go to the catalog/index it says that illegal tempate dirrectory , i want to change the template dirrectory to my_custom but the Configuration have changed and there is no link to change the dirrectory as after the restore it show me all how i had in oscommerce admin setup lots of defalt links from oscmax disappear. please someon ehelp me out i have beed read all the forum but no clue.

thanks

[michael_s]

Your mistake was to import the old osCommerce configuration to the new osCMax database.

You cannot just overwrite the oscmax db with the old oscommerce data. Start over with a fresh osCMax db and do not overwrite the configuration table with old oscommerce data.

[chowhan]

thanks for the reply but how can i do that the fro mmy database it dont copy the configration. Please i am very new to PHp so try to expain as you , thanks

[michael_s]

Read a tutorial for how to do it:
MySQL :: MySQL 5.0 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program

or use a frontend like phpmyadmin to do it.

[chowhan]

i can use phpmyadmin , but what do ihave to do there i just need products from the old database , which tables should i backup ?

[chowhan]

Ok Let me tell what i am doing, i am in phpmyadmin selecting the database , click export select the tables i want and export it , download it , is that all right till here and i think i have to run this database on clean oscommerce install ?please advice. i am very new to this . but i am trying to learn faster

[rkah]

The oscommerce and oscmax databases are not totally congruent. (the same) There are some minor differences in products table for sure. If I was doing this I would start with creating a db in mySQL called oscMAX. Then use the SQL script included in the /catalog/install directory to create the oscMAX database. Then create a totally seperate database in MySQL called old_osccommerce, reimport your old oscommerce data to there. Next start comparing the tables 1 for 1. you will see that a base oscommerce RC2a db is different from oscmax. Excel can be a great tool hashing out the differences, and adding the columns of data that are different.

[michael_s]

Yes, the databases structurally are different.

You cannot just move data between them. Use mysqldiff to upgrade the osCommerce database structure to match oscmax. Then you can do a 1:1 import from the osCommerce database to the osCmax db (products, categories, orders, customers tables).

Search these forums, there are several discussions about this very topic.

[chowhan]

thanks for the reply i used mysqldiff and after comparing the databases it gave me this code

#
# MySQLDiff 1.5.0
#
# MySQLdiff - checking for differences in database structures
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 26.02.2008 23:12
#
# --------------------------------------------------------
# Source info
# Host: rdbms.strato.de
# Database: DB380230
# --------------------------------------------------------
# Target info
# Host: rdbms.strato.de
# Database: DB377430
# --------------------------------------------------------
#

SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
CREATE TABLE administrators (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
user_name varchar(32) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
user_password varchar(40) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
PRIMARY KEY (id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

CREATE TABLE adsense_cc (
name varchar(100) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
active char(3) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
pages text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
position varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
placement char(3) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci,
css_suffix varchar(25) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci,
div_css_code varchar(50) NULL DEFAULT 'text-align:center;' COMMENT '' COLLATE latin1_german1_ci,
publisher_id varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
channel_no varchar(12) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci,
type varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
corners varchar(30) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
layout varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
border_color varchar(7) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci,
background_color varchar(7) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci,
link_color varchar(7) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci,
text_color varchar(7) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci,
url_color varchar(7) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci
) DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

CREATE TABLE meta_tags (
meta_id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
categories_id int(11) NOT NULL DEFAULT '0' COMMENT '',
manufacturers_id int(11) NOT NULL DEFAULT '0' COMMENT '',
keywords varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
description varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
title varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
PRIMARY KEY (meta_id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

CREATE TABLE sitemap_exclude (
exclude_id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
exclude_file varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_german1_ci,
exclude_type int(1) NOT NULL DEFAULT '0' COMMENT '',
is_box int(1) NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY (exclude_id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

#
# DDL END
#




SET FOREIGN_KEY_CHECKS = 1;













What do i have to do now ??'

[tcshadow]

read this thread... Converting DB from OSC2.2 to OSCMAX2.2

It explains a lot of the hurdles to be overcome... play with it for a day or 2 then if you still haven't managed ask again... Michael_s is very helpful but it's not nice to ask him to explain the same things over and over.