MySQL Forums
Forum List  »  Newbie

Problems importing database which took from linux server
Posted by: Ilan Goldman
Date: April 11, 2005 05:31AM

Hello,


I have two servers.

1 is linux and 1 is windows 2003 server.

I am running on both mysql server.

when I installed the MySQL server on the win 2003 server I choosed Hebrew.

now , I am doing export to the database on the linux server.

by this command :(exporting database)

mysqldump -u username -ppassword database_name > FILE.sql

and I am doing this on the win 2003 server (importing database)

mysql -u username -ppassword database_name < FILE.sql

I get an error msg :
ERROR 1062 (23000) at line 571: Duplicate entry '????' for key 1


my question is , which special action I need to take in order to be able support hebrew web sites in MYSQL server. (remember that in the installation process I choosed hebrew)

you may see the different by your self :

linux server : http://www.multishare.net/

windows server : http://test.winner-serv.net/public_html/

what I have to so ?

Options: ReplyQuote


Subject
Written By
Posted
Problems importing database which took from linux server
April 11, 2005 05:31AM
April 12, 2005 06:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.