This is the currernt table strucure
PHP Code:
CREATE TABLE games_developers (
developers_id int(5) NOT NULL auto_increment,
developers_name varchar(255) NOT NULL default ' ',
language_id int(5) NOT 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
