Looking for some assistance with the following please.
I am moving a xampp locahost site from an older PC to a newer one. After setting up the virtual host aspect and installing xampp I transferred the root directory from the old host to the new one in the htdocs directory. I exported the MySQL DB and saved it to a memory stick. I changed the new MySQL INI file to allow 8M uploads. The SQL file is 4.2M. When I try to import the DB I get the following error
which I find very confusing!
Error
SQL query:
--
-- Dumping data for table `cds`
--
INSERT INTO `cds` (`titel`, `interpret`, `jahr`, `id`) VALUES
('Beauty', 'Ryuichi Sakamoto', 1990, 1),
('Goodbye Country (Hello Nightclub)', 'Groove Armada', 2001, 4),
('Glee', 'Bran Van 3000', 1997, 5);
MySQL said:
#1062 - Duplicate entry '1' for key 'PRIMARY'
Xampp ver: win32-1.8.2-6-VC9
Thanks in advance .... Rod