LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysql dupe entry error, how to avoid? (https://www.linuxquestions.org/questions/linux-software-2/mysql-dupe-entry-error-how-to-avoid-94868/)

hydro 09-20-2003 12:08 PM

mysql dupe entry error, how to avoid?
 
This is the currernt table strucure

PHP Code:

CREATE TABLE games_developers (
  
developers_id int(5NOT NULL auto_increment,
  
developers_name varchar(255NOT NULL default ' ',
  
language_id int(5NOT NULL default '0',
  
PRIMARY KEY  (developers_id,language_id)
TYPE=MyISAM

Somone moron designed the table this way, and entries are like

3, Bla bla, 0
3, Bla Bla in some other language, 1

Around 400 entires.

Now i need to move the database, so I dump it out, and try to import it into a new database. but I get dupe error

ERROR 1062 at line 720: Duplicate entry '219-1' for key 1

the import file is over 26mgs :(, and alot of dupes like those aboves. How can I avoid those errors and have my db like the old one


All times are GMT -5. The time now is 11:22 AM.