Phpmyadmin Account Problem

[Lpe95]

Hey i made new database in phpmyadmin, and before i deleted my old one i downloaded my accounts after that i made new database, After it i want to put my old accounts database in phpmyadmin and this is coming. I also have tried to make new database and import accounts first after the tables but it happend same thing

Error
SQL query:

-- -- Dumpning av Data i tabell `accounts` -- INSERT INTO `accounts` (`id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_access`, `page_lastday`, `email_new`, `email_new_time`, `rlname`, `location`, `created`, `email_code`, `next_email`, `premium_points`, `nickname`, `avatar`, `about_me`) VALUES (1, '1', '1', 65535, 1362320533, '', '', 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2, '124124', '162734fec0b1cb988c0206946c0002a2387ac53f', 0, 1362321094, '[email protected]', '', 0, 0, 1, 6, NULL, NULL, NULL, 'Daniel', 'Somewher in sweden', NULL, NULL, NULL, 170, 'River', NULL, 'I won''t tell anything about me cause its not your bussines !'), (3, '4737390', 'c32d9cb2f11d990b8991dfea154543c39850ea1a', 0, 1362320533, '[email protected]', '', 0, 0, 1, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, 0, 'Gtttt', NULL, NULL), (4, '211955', '916c014031a7cd176ad393353f73429e8037e6c9', 0, [...]

MySQL said: 

#1062 - Duplicate entry '1' for key 'PRIMARY'

- - - Updated - - -

BUMP

 

[atyll]

It simply means you already have this table. Select your database, Go to Operations in Phpmyadmin and choose Drop Table, then try again

 

[Lpe95]

It simply means you already have this table. Select your database, Go to Operations in Phpmyadmin and choose Drop Table, then try again

It dosen't work to drop it

You are about to DESTROY a complete table! Do you really want to execute "DROP TABLE accounts"?

And then i click OK.

Error in Processing Request :
#1217 - Cannot delete or update a parent row: a foreign key constraint fails

I even tryed this but doesn't work



BUMP

 

[atyll]

It means that you are trying to cancel a row from one table, that contains a value present in at least one row in another table, and the foreign key constraint is there to avoid this from happening.
Drop the ENTIRE database, not just accounts.

 

[Lpe95]

It means that you are trying to cancel a row from one table, that contains a value present in at least one row in another table, and the foreign key constraint is there to avoid this from happening.
I asked you to drop the ENTIRE table, not just accounts.

i have done it and it happend same thing