The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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: Code:
mysql -r databaseusername -p databasename < mydatabase.sql Code:
ERROR 1062 (23000) at line 247925: Duplicate entry 'mobile?' for key 2 Can anybuddy help me solve this problem? Thank you |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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.
|
#5
|
|||
|
|||
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.
|
#6
|
|||
|
|||
I have the original file in .gz format. I've uploaded in 2 different modes.
PM'ed you. |
#7
|
|||
|
|||
I will look at it tomorrow.
|
#8
|
|||
|
|||
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. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|