Importing the database

[R1Mad]

Hi,

We have just moved to our own dedicated server and I want to import the database from our old host that we used our forum on.

I have tried using the imported tool that comes with vBulletin but our old host will not accept outside connects to it’s MySQL server.

We are running Windows 2003 web server with MySQL and php5.
I have a test model of vBulletin working fine on the new server but just can't get the old database to import on to our new server.

Is there anyway to import a backup to a new forum?

[Steve Machol]

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

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

Note: Some people have 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 (restore only):
http://www.ozerov.de/bigdump.php

[R1Mad]

Hi,

I have managed to do that now and upgraded the forum to the latest version.
However I now have a new problem of not being able to log-in or register a new user.

http://89.234.1.79/eposandcreek/www/newfourm/index.php
There is the testing forum, it's also lost for of it's formating and looks a bit odd. I guess I need to go back in the code a edit it agian but I can't even log into the admin area.

Any ideas on how to fix this?

[Floris]

Make sure you've upgraded completely, and went through all the upgrade steps. And that all the files are from the latest version and uses the latest default style.

You can upload the tools.php file (from the do_not_upload/ folder in the .zip file) to the admincp/ directory and reset the cookie domain and path.

[R1Mad]

Hi,

Just used tools and it's worked. Thanks for your help :o)