Converting DB from OSC2.2 to OSCMAX2.2

[tcshadow]

I have it working now... It didn't want to work quite right doing the entire db at once so instead what I do is export the table I want, then drop that table out of my oscmax database and recreate it including all of the osc2.2 data from the export.

TY for all the help Michael... I appreciate the patience

[michael_s]

Yes, osCMax has lots of extra columns and tables. If you don't upgrade the osC 2.2 db to have them present with mysqldiff, you will get errors. That is the whole point of using mysqldiff.

Glad you have it working.

[drawed]

Sorry to beat this dead horse back to life but I figured I would share my struggle in hopes of helping others in the future. I marched through a bunch of the mysqldiff postings and feel I understand what is going on but I'm missing the final piece.

What I've done:
Created a temp_osc DB that received a copy of my live_osc DB
Dropped tables that I felt I didn't need (kept cust/product related)
Created a temp_max DB that received a copy of my fresh osCMAx DB

Generated the mysqldiff.sql and removed the problematic default = <foo> entries. (scrubbed.sql)
Imported the resulting scrubbed.sql to my temp_osc DB
Exported temp_osc DB after the import above. (final.sql)

When I attempt to import final.sql into temp_max DB I receive an error complaining about tables already existing. This isn't surprising as I the sql file is using a CREATE statement. Where did I go wrong? Should I have used a different option when I export/import? I was using the defaults of phpmyadmin.

SQL query:     
              --
-- Database: `temp_osc`
--
-- --------------------------------------------------------
--
-- Table structure for table `address_book`
--
 CREATE  TABLE  `address_book` (
 `address_book_id` int( 11  )  NOT  NULL  AUTO_INCREMENT ,
 `customers_id` int( 11  )  NOT  NULL default  '0',
 `entry_gender` char( 1  )  NOT  NULL default  '' COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_company` varchar( 32  )  default NULL  COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_company_tax_id` varchar( 32  )  default NULL  COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_firstname` varchar( 32  )  NOT  NULL default  '' COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_lastname` varchar( 32  )  NOT  NULL default  '' COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_street_address` varchar( 64  )  NOT  NULL default  '' COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_suburb` varchar( 32  )  default NULL  COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_postcode` varchar( 10  )  NOT  NULL default  '' COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_city` varchar( 32  )  NOT  NULL default  '' COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_state` varchar( 32  )  default NULL  COMMENT  '\0\0\0\0\0\0\0\0\0\0\0!\0\0\0',
 `entry_country_id` int( 11  )  NOT  NULL default  '0',
 `entry_zone_id` int( 11  )  NOT  NULL default  '0',
 PRIMARY  KEY (  `address_book_id`  ) ,
 KEY  `idx_address_book_customers_id` (  `customers_id`  ) 
) ENGINE  =  MYISAM  DEFAULT CHARSET  = latin1 AUTO_INCREMENT  =1;

          MySQL said:  
  #1050 - Table 'address_book' already exists

Thanks for the help. I look forward to using oscmax