SQL database import problem - Need help - Will pay

Hi. When trying to import 9.4mb database of blog i get this error:

Error
MySQL said: Documentation
#1062 - Duplicate entry '1-0-_transient_random_seed' for key 'PRIMARY'

If anyone can help me to solve this or better if anyone could do the import for me for a small fee.

Thanks in advance

 

I would remove key PRIMARY from table just for import, thats should solve your problem

 

which version of mysql you are using ?

Are you trying to import data from a new version to older version ?

 

yes i can do this pls contact me , thanks

 

You can't have more then one PRIMARY KEY in your database. Both databases have one, and when you try to import, the database calls on the PRIMARY KEY and creates conflict.

You need to remove the PRIMARY KEY from the existing database first.

 

Hi,
u hv to remove the primay key from the design mode, but be careful the data into the primary marked key may be duplicate...
when u remove the primary key it will automatically imports the data....
go ahead patron123

 

did removing the primary key solve the problem?

 

Can someone tell me how to remove the primary key from the php my admin menu,please help

 

Alter table your_table drop primary key;

 

I am having the same problem as the TS,ie when I tries to import another blogs sql databse from the my PHP menu,I am getting the same message as the TS.
Now there are more than 1table in the PHP my admin menu like wp comments etc.
As directed by one of the users who told the solution,I am confused as to which tables Primary key should I delete.Thanks in advance

 

Thanks for giving the solution of that Que... Because so many people facing this problem.. So from that many people got the solution..!!