Import MySQL DB Error

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Import MySQL DB Error

Postby Hawkeye2 » 23. March 2015 12:35

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
Hawkeye2
 
Posts: 6
Joined: 23. March 2015 12:16
Operating System: win7

Re: Import MySQL DB Error

Postby Hawkeye2 » 24. March 2015 02:55

Please disregard the above post. Solved. Primarily what we call "finger trouble" or dumb mistake!! Cheers.
Hawkeye2
 
Posts: 6
Joined: 23. March 2015 12:16
Operating System: win7


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 50 guests