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

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:
I receive this error in the middle:
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

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/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_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/showt...t=mysqlhotcopy

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

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.

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.

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.

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

PM'ed you.

I will look at it tomorrow.

Okey, thank you very much,

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

--------------- Added [DATE]1248932272[/DATE] at [TIME]1248932272[/TIME] ---------------

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.