There are only 2 category tables to mention:
zen_categories
zen_categories_description
I selected the Zen DB, clicked Structure, export, highlighted the 2 category fields, selected everything under SQL options except Structure and Complete inserts and saved AS. This is what I get.
--------------------------------------------------------------------------------
--- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Nov 29, 2007 at 09:35 AM
-- Server version: 4.0.16
-- PHP Version: 4.4.1
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT=0;
START TRANSACTION;
--
-- Database: `zenned_p_os2`
--
--
-- Dumping data for table `zen_categories`
--
--
-- Dumping data for table `zen_categories_description`
--
SET FOREIGN_KEY_CHECKS=1;
COMMIT;
Now, when I do the same to the OSC DB and then compare them, all it looks like I have to do is copy and paste the:
INSERT DELAYED IGNORE INTO `categories` (`categories_id`, `categories_image`, `parent_id`, `sort_order`, `date_added`, `last_modified`) VALUES
(1, 'KYO3021B.jpg', 0, 0, '2007-03-20 20:33:09', '2007-03-21 17:23:01'),
(2, 'clear.gif', 0, 0, '2007-03-20 20:33:09', '2007-08-03 21:32:14'),
(3, 'clear.gif', 0, 0, '2007-03-20 20:33:09', '2007-08-08 21:43:53'),
(25, 'futk6900-175.jpg', 23, 0, '2007-03-21 21:16:56', NULL),
and the rest into the appropriate area. I also tried a script someone (merlin) wrote to just insert in the SQL and run it. I did not see anything change. What's porting in programming terms?
Thanks for your help.



