CMS Made Simple Forums

I am trying desperately to move a CMSMS 1.11.7 installation to another server and am getting error messages in importing the MySQL database.

I am no expert on MySQl and therefore am asking for help. The message I get is:

Error

SQL query:

-- -- 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, 'Welcome to CJ Personal Image', 'content', 1, -1, 18, 1, '00001', 1, 'Home', 'home', 1, 1, 'html', 1, 1, '15', 'home', 'target,pagedata,extra1,extra2,extra3,image,thumbnail,searchable,disable_wysiwyg,image1,content_en', '', 'Home Page, shortcut key=1', '', '1', 1, '2006-07-25 21:22:31', '2013-10-04 15:31:53', 0, ''), (73, 'Products', 'content', 1, -1, 18, 5, '00005', 0, 'Products', 'products', 1, NULL, 'html', 1, 1, '73', 'products', 'content_en,searchable,extra1,extra2,extra3,pagedata,disable_wysiwyg,image,thumbna[...]

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

I really have no idea what to do next. Can anyone help please?

Sending MYSQL version 5.0.96
Receiving MYSQL version 5.5.32

Thanks

Martin

i bet that table exists and has data in it. did you drop and recreate the dababase?

rotezecke wrote:i bet that table exists and has data in it. did you drop and recreate the dababase?

Many thanks for your response.

I have now decided to do a clean install on the new server, and then copy the templates, stylesheets & content across. It is not a big site at all and everything has already been designed & created so it is just a copy job.

I therefore withdraw this post.

Thanks folks.