Database Import Fail
Posted: Fri Feb 03, 2012 7:51 am
Hi All.
I'm trying to set up a development machine on Windows 7 for my new graphic designer. I have no idea whether this problem is related to Windows or not, but i have never had problems with database imports before.
Dev system:
Server version: 5.5.20
Live system:
Server version: 5.0.92-server-log
When trying to import the database, i get the following error:
SQL query:
Could the problem be related to the different versions of mysql?
I'm trying to set up a development machine on Windows 7 for my new graphic designer. I have no idea whether this problem is related to Windows or not, but i have never had problems with database imports before.
Dev system:
Server version: 5.5.20
Live system:
Server version: 5.0.92-server-log
When trying to import the database, i get the following error:
SQL query:
Code: Select all
-- -- Dumping data for table `cms_content` -- INSERT INTO `cms_content` (`content_id`, `content_name`, `type`, `owner_id`, `parent_id`, `template_id`, `item_order`, `hierarchy`, `default_content`, `menu_text`, `content_alias`, `show_in_menu`, `collapsed`, `markup`, `active`, `cachable`, `id_hierarchy`, `hierarchy_path`, `prop_names`, `metadata`, `titleattribute`, `tabindex`, `accesskey`, `last_modified_by`, `create_date`, `modified_date`, `secure`, `page_url`) VALUES (15, 'Merlot171 Home', 'content', 1, -1, 23, 1, '00001', 1, 'Home', 'home', 1, 1, 'html', 1, 1, '15', 'home', 'target,pagedata,extra1,extra2,extra3,image,searchable,disable_wysiwyg,image1,thumbnail,content_en', '', 'Home Page, shortcut key=1', '', '1', 1, '2006-07-25 21:22:31', '2011-07-21 09:32:40', 0, ''), (16, 'Merlot171 Gallery', 'content', 1, -1, 23, 2, '00002', 0, 'Gallery', 'gallery', 1, NULL, 'html', 1, 1, '16', 'gallery', 'target,image,thumbnail,extra1,extra2,extra3,searchable,pagedata,disable_wysiwyg,content_e[...]
MySQL said: Documentation
#1062 - Duplicate entry '15' for key 'PRIMARY'