osCmax v2.5 User Manual
Page 1 of 3 123 LastLast
Results 1 to 10 of 28

Database import from oscommerce to oscmax --- Error

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 ...

      
  1. #1
    New Member
    Join Date
    Feb 2008
    Posts
    25
    Rep Power
    0


    Arrow Database import from oscommerce to oscmax --- Error

    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 01:07 AM.

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Database import from oscommerce to oscmax --- Eroor --- Please read

    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 Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    New Member
    Join Date
    Feb 2008
    Posts
    25
    Rep Power
    0


    Default Re: Database import from oscommerce to oscmax --- Eroor --- Please read

    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. #4
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Database import from oscommerce to oscmax --- Eroor --- Please read

    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 Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    New Member
    Join Date
    Feb 2008
    Posts
    25
    Rep Power
    0


    Default Re: Database import from oscommerce to oscmax --- Eroor --- Please read

    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. #6
    New Member
    Join Date
    Feb 2008
    Posts
    25
    Rep Power
    0


    Arrow Re: Database import from oscommerce to oscmax --- Eroor --- Please read

    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. #7
    New Member rkah's Avatar
    Join Date
    Feb 2008
    Location
    Midwest
    Posts
    21
    Rep Power
    0


    Default Re: Database import from oscommerce to oscmax --- Eroor --- Please read

    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.

  8. #8
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: Database import from oscommerce to oscmax --- Eroor --- Please read

    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 Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  9. #9
    New Member
    Join Date
    Feb 2008
    Posts
    25
    Rep Power
    0


    Arrow Re: Database import from oscommerce to oscmax --- Error

    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. #10
    Active Member
    Join Date
    Aug 2007
    Posts
    145
    Rep Power
    5


    Default Re: Database import from oscommerce to oscmax --- Error

    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.

Page 1 of 3 123 LastLast

Similar Threads

  1. how to import my old database
    By plus766 in forum osCommerce 2.2 Installation Help
    Replies: 2
    Last Post: 01-26-2007, 10:24 AM
  2. how do i convert oscommerce database backups to oscmax?
    By chuan in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 10-07-2006, 06:43 PM
  3. OSCMax v2 - Stuck on New Installation Database Import
    By Geno11x11 in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 12-04-2005, 09:27 AM
  4. Error Import database
    By dc25 in forum osCommerce 2.2 Installation Help
    Replies: 0
    Last Post: 12-07-2003, 11:08 PM
  5. Database import
    By sverker in forum osCommerce 2.2 Installation Help
    Replies: 4
    Last Post: 11-24-2003, 12:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •