migrating to new server

[SandyCee]

I cannot remember what I did for my last client, however it worked seemlessly.

Now I am trying to do the same thing for my own website and it just is not working.

I backed up using export on PHPmyAdmin for the entire data base - I deselected the structure so it was for data only.

Then on the new server I created a new database with the same name in the same directory (shop) and put the same admin in.

Now I am getting this error message.

Can someone please help me to find out where I need to make the change? I cannot go back to my old server and make another backup as the data base has been accidentally erased.

 

-- -- Database: `spiritco_osc3` -- -- -- Dumping data for table `action_recorder` -- INSERT INTO `action_recorder` (`id`, `module`, `user_id`, `user_name`, `identifier`, `success`, `date_added`) VALUES (2, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-21 03:09:46'), (3, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-23 01:15:42'), (4, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-23 02:09:09'), (5, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-23 03:22:03'), (6, 'ar_admin_login', 0, '', '123.51.32.217', '0', '2011-03-23 03:49:10'), (7, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-23 03:49:22'), (8, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-23 20:32:59'), (9, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-23 22:32:14'), (10, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-23 23:04:00'), (11, 'ar_admin_login', 1, 'sandy', '123.51.32.217', '1', '2011-03-23 23:12:21'[...]

 

MySQL said: Documentation

#1062 - Duplicate entry '2' for key 1

 

I realise the duplication entry can be fixed - just do not know where to go for this information.

 

Thanks so much - have spent too many days on this already going mad. last time I am sure I simply changed the name of the admin and all was well.