help me - moving servers

[geyiqforever]

Hello,

I'm moving servers
I repaired and optimized all my tables via phpmyadmin and vbulletin admin center(with no errors)
my sql file is about 800 mb
I got backup from ssh as you explain on http://www.vbulletin.com/docs/html/main/moving_servers with this command:

mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL

and I put the sql file to my new server
When my host want to import it, they said me that an error occurs on ssh like that

# mysql database < database.sql
ERROR 1062 at line 3153: Duplicate entry 'icin' for key 2

I said them that they must use this command as you explain on your documention:
mysql –uUSERNAME –p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL


I tried to get backup 2 times with trying repairing and optimizing 2 times
but we got same error when importing via ssh

my previous mysql version is 3.23.x
my new mysql version is 4.x

what should I do?

now I downloaded *frm *.MYD *.MYI ... files from my previous host's mysql/var/mydomain directory and I saved it as a zip file and uploading to my new host
I'll say them to put them into my database
is this a solution for me?

[geyiqforever]

I did it
I see that some missing tables
only 48 tables are here
I think it's about my hosting company "importing sql table limit"
I'll import others now

[geyiqforever]

solved