Backup database not working

[vbuser12345]

Hello,

I moved to a new server but I'm unable to get the backup database to work properly. The database is not read at all.

Here is the info:

On the New Server:
vBulletin version 3.6.2.
Server Type Linux
Web Server Apache v1.3.37
PHP 5.2.1
MySQL Version 5.0.27-standard

Old Server:
Vbulletin version 3.6.2.
Server Type Linux
Web Server Apache v2.0.54
PHP 5.0.4
MySQL Version 4.1.20

Any solutions?

Thank you

[peterska2]

How are you trying to backup? Do you get any error messages? What size is your database?

[vbuser12345]

Hello Kerry-Anne.

I did my back up on my old server with Putty and restored it to the new server. But when I try to use the forum, it's the plain vbulletin forum, not my forum. No error message, it looks like the updated database is not read or processed by vbulletin.

I think the different versions of MySQL and PHP are causing a problem.

[peterska2]

Have you restored all your files and edited config.php to point to the new database?

Also, after restoring your database and files have you done anything else?

[vbuser12345]

I installed vbulletin on the new server, created a new database, restored the backup file in the new database, changed the name of the new database in the config.php file.

I have done anything else (except trying to find info about downgrading my php and mysql version on the new server).

[peterska2]

You will also need to change the database username and password.

[vbuser12345]

Yes, It was changed. Is it possible that the difference of the mysql and php versions is the cause of the problem?

[Floris]

Kerry-Anne missed something there :)

You installed a new vBulletin? Then imported on top of it?

That's not the way to do it.

Backup on the old server, move the files over to the new server, create a new empty database and restore the backup into this.

Do not run install.php or upgrade.php - and then import.

[vbuser12345]

Hello Floris, I will try that, will let you know. Thanks to both of you.

[vbuser12345]

It's working, thanks a lot!

[Vietclub]

vbuser12345 ,

What you do to fix the problem ? I think I had the same problem you had , and I still can't figure out why ?

I backup the database ( only 40MB) , imported to the new host .FTP all the new Vb 3.6.5 file to he forum folder and then run upgrade.php , I got the error message saying that the new database does not exit !!!

I verified the new database it's there ,all the table and the size .But some reason it's said the database doesn't exit .

But ,I success upgrade from version 3.6.4 to 3.6.5 from another forum .This forum database is about 80MB .Because this database is too big to import so I selected table I want then I export it ,and make sure it's under 30MB each .With the 80MB database ,I export total 18 piece .When I import to new host and upgrade to 3.6.5 ...it's worked .I nerver use telnet/ssh to restore database (because I try to learn how to use it ...I still can't and don't know how to use it)

I used the same method to upgrade , but the 3.6.0 is failed .I don't know why ?

So my question is ...How did you get it to work ?

[peterska2]

Check the details in config.php If you have moved host then the database information will have changed.

[Vietclub]

I Just found the problem ...very simple is that I just run www.mysite.com/forum/install/upgrade.php (http://www.mysite.com/forum/install/upgrade.php) ...that fixed

What I did wrong was run www.mysite.com/forum/install/upgrade_365.php (http://www.mysite.com/forum/install/upgrade_365.php) ...<=== this only work when my version is 3.6.4 ..then it run OK .If my version is 3.6.2 then I should run upgrade.php ....

[vbuser12345]

Hello Vietclub,

I was not upgrading, just moving server, so I did what Floris wrote:

Backup on the old server, move the files over to the new server, create a new empty database and restore the backup into this.

Do not run install.php or upgrade.php

Then I double checked my config.php as Kerry-Anne suggested:

Check the details in config.php If you have moved host then the database information will have changed.

That what's worked for me.

[Floris]

Please start your own support ticket, each situation is different for each customer.

That said, do NOT run upgrade<number>.php to upgrade, ONLY run upgrade.php - it will load the right files in the right order.