Guest Posted June 14, 2011 Share Posted June 14, 2011 I exported just the data from my old db (not the structure) and cleared all the default data from the 2.3.1. db as other instructions have said. I imported the data to my 2.3.1. database, which is a fresh install and a new database. I receive the following error: SQL query: -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`categories_id`, `categories_image`, `parent_id`, `sort_order`, `date_added`, `last_modified`) VALUES (21, NULL, 0, 0, '2010-02-03 14:00:44', NULL), (22, NULL, 0, 0, '2010-02-09 17:56:57', NULL), (23, NULL, 0, 0, '2010-02-09 18:06:19', NULL), (24, NULL, 0, 0, '2010-02-09 18:11:20', NULL), (25, NULL, 0, 0, '2010-02-09 18:16:20', NULL), (26, NULL, 0, 0, '2010-02-09 18:25:28', NULL), (27, NULL, 0, 0, '2010-02-10 12:26:11', NULL), (28, NULL, 0, 0, '2010-02-15 14:42:04', NULL), (29, NULL, 0, 0, '2010-02-15 14:56:40', NULL), (30, NULL, 0, 0, '2010-02-15 15:15:18', NULL), (31, NULL, 0, 0, '2010-02-15 15:36:57', NULL), (32, NULL, 0, 0, '2010-02-23 17:31:05', NULL), (33, NULL, 0, 0, '2010-02-23 17:55:08', NULL), (34, NULL, 0, 0, '2010-02-23 18:23:34', NULL), (35, NULL, 0, 0, '2010-02-24 15:31:07', NULL), (36, NULL, 0, 0, '2010-02-24 15:51:04', NULL), (37, NULL, 0, 0, '2010-02-24 16:11:57', NULL), (38, NULL, 0, 0, '2010-02[...] MySQL said: #1062 - Duplicate entry '51' for key 1 Any suggestions or is there a detailed description or info sheet on how to do this properly? I am going to be using new installs for all of my stores. Thanks, and help is appreciated. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.