Jump to content

mysql question


Recommended Posts

Hello,

I am trying to export just my categories and products so that I can import them into another store. I dont want to export anything but product and category info.

I checked only the ps_product and ps_category and did a sql export.

When I go to my other store I get this error when importing

SQL query:

-- -- Dumping data for table `ps_category` -- INSERT INTO `ps_category` (`id_category`, `id_parent`, `level_depth`, `active`, `date_add`, `date_upd`) VALUES (1, 0, 0, 1, '2011-01-20 17:46:29', '2011-01-20 17:46:29'), (118, 108, 2, 1, '2011-01-25 14:58:25', '2011-01-25 14:58:25'), (120, 108, 2, 1, '2011-01-25 14:59:07', '2011-01-25 14:59:07'), (109, 108, 2, 1, '2011-01-25 14:29:44', '2011-01-25 14:29:44'), (108, 1, 1, 1, '2011-01-25 14:29:01', '2011-01-25 14:29:01'), (107, 1, 1, 1, '2011-01-25 10:43:22', '2011-01-25 10:43:22'), (119, 108, 2, 1, '2011-01-25 14:58:52', '2011-01-25 14:58:52'), (105, 1, 1, 1, '2011-01-25 09:15:24', '2011-01-25 09:15:24'), (106, 1, 1, 1, '2011-01-25 10:33:02', '2011-01-25 10:33:02'), (110, 108, 2, 1, '2011-01-25 14:30:26', '2011-01-25 14:30:26'), (116, 108, 2, 1, '2011-01-25 14:57:45', '2011-01-25 14:57:45'), (117, 108, 2, 1, '2011-01-25 14:58:07', '2011-01-25 14:58:07'), (121, 108, 2, 1, '2011-01-25 14:59:34', '2011-01-25 14:59:34'), (122, 108, 2, 1, '20[...]

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

What am I doing wrong, also what are all the ps_ tables I need to export to export my category and product info only?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...