After a transfer to a new server--> the posts are disappear

[BieDdoS]

Why i have this problem????

I did the maintenance but nothing.... only 3d sticky have posts.... why???
http://81.174.49.196/forum/forumdisplay.php?f=80

[Zachery]

It seems that your forums are closed.

[BieDdoS]

It seems that your forums are closed.

ops now i open but not for more time because i afraid that some users will do some post...

[BieDdoS]

i try to do a post.... i obtain this warning...

Sorry! This forum is not accepting new posts

[Zachery]

Possibly an incompete server move, how did you move the database?

[BieDdoS]

I use phpmyadmin for backup because i cannot use ssh in old server....
in new server i restore db with ssh

For purposes of this instruction,I am using phpMyAdmin version 2.5.6-rc1.

Go to phpMyAdmin in your web broswer and select the database you wish to back up by clicking on the name. If you have multiple databases, you will need to select the name from the drop menu.

In the right-hand frame, you will see a row of links. Click [Export]

Now in the right-hand frame you will see three (3) areas. In the first area, called Export you select the table(s) you wish to back up by selecting them from the list. To select multiple tables, hold the Ctrl key and lick the table names. To select all table, click the [Select All] link.

In the second area, called SQL Options, make sure you have the follwing boxes checked:

Structure
Add 'drop table'
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Data

In the third area, check Save as file and type a name for the backup in the File name template :.
If your system supports it, you may also choose a compression type. None is selected by default.

Click [Go] and you will be prompted to save the backup on your local computer.

[Steve Machol]

The phpMyAdmin backup is probably the problem,. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. 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

If you don't have telnet or SSH access, some people have 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

And if you want to try phpMyAdmin, here's the instructions.

Backup with phpMyAdmin:
http://www.vbulletin.com/docs/html/m...myadmin_backup

Restore with phpMyAdmin:
http://www.vbulletin.com/docs/html/m...yadmin_restore