This is a discussion on Database import from oscommerce to oscmax --- Error within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; Hello, everyone i am new to oscmax, i have been using oscommerce till now and all was fine but to ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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 Last edited by chowhan; 02-27-2008 at 02:07 AM. |
|
#2
| ||||
| ||||
| 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.
__________________ Michael Sasek osCMax Developer osCMax Templates - Hundreds of premium quality templates. New designs every month! xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. |
|
#3
| |||
| |||
| 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 |
|
#4
| ||||
| ||||
| 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.
__________________ Michael Sasek osCMax Developer osCMax Templates - Hundreds of premium quality templates. New designs every month! xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. |
|
#5
| |||
| |||
| i can use phpmyadmin , but what do ihave to do there i just need products from the old database , which tables should i backup ? |
|
#6
| |||
| |||
| 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 |
|
#7
| ||||
| ||||
| 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. |
| The Following User Says Thank You to rkah For This Useful Post: | ||
chowhan (02-26-2008) | ||
|
#8
| ||||
| ||||
| 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.
__________________ Michael Sasek osCMax Developer osCMax Templates - Hundreds of premium quality templates. New designs every month! xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. |
| The Following User Says Thank You to michael_s For This Useful Post: | ||
chowhan (02-26-2008) | ||
|
#9
| |||
| |||
| 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 ??' |
|
#10
| |||
| |||
| 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. |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to import my old database | plus766 | osCommerce 2.2 Installation Help | 2 | 01-26-2007 11:24 AM |
| how do i convert oscommerce database backups to oscmax? | chuan | osCMax v2 Installation issues | 1 | 10-07-2006 06:43 PM |
| OSCMax v2 - Stuck on New Installation Database Import | Geno11x11 | osCMax v2 Installation issues | 2 | 12-04-2005 10:27 AM |
| Error Import database | dc25 | osCommerce 2.2 Installation Help | 0 | 12-08-2003 12:08 AM |
| Database import | sverker | osCommerce 2.2 Installation Help | 4 | 11-24-2003 01:26 PM |