ERROR 1062 (23000) at line 247925: Duplicate entry 'mobile?' for key 2

[LoverZPoint]

Hi guys,

I've a very serious problem importing my Vbulletin 3.8 database to my new server. I searched alot and try to follow different methods, but no luck.

I had my site on my dedicated server but now for some reason that is not accessible for me and I want to restore my site on my new dedicated server. I have my sql backup. I made backup from phpMyAdmin.

But now when I try to restore via ssh:
mysql -r databaseusername -p databasename < mydatabase.sql

I receive this error in the middle:
ERROR 1062 (23000) at line 247925: Duplicate entry 'mobile?' for key 2

I also tried to import the database via phpMyAdmin but there I'm facing the execution time limit, I also edited php.ini file but same message.

Can anybuddy help me solve this problem?

Thank you

[Marco van Herwaarden]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

[LoverZPoint]

Thanks Marco,

But at the moment my working server (Old one) has not been accessible to me for backup via SSH, I just have backup created with PhpMyAdmin.

So what should I do in this situation?

There are about 20K posts or above. I need this to be solved.

Thank you.

[Marco van Herwaarden]

Please upload the backup you are trying to restore to your server and provide me with the URL to this backup in a PM. I will see if i can determine of the backup is usable or not.

[Marco van Herwaarden]

The file you had uploaded is not usable. You have probably FTP'ed it in binary mode at some point of time as it shows as a binary file instead of a ext file.

[LoverZPoint]

I have the original file in .gz format. I've uploaded in 2 different modes.

PM'ed you.

[Marco van Herwaarden]

I will look at it tomorrow.

[LoverZPoint]

Okey, thank you very much,

I'll be waiting, coz my site is down...:(

--------------- Added 1248932272 at 1248932272 ---------------

Problem solved by uploading my sql file to my server.

And restoring via ssh locally on my server by this command "mysql -u dbusername -p dbname < dbfile.sql"

Thank you very much.