problem after move to a new server

[SLGR]

I moved my site to a new server. The new host requested a backup of the db via phpMyAdmin. I selected my database, selected all tables at the export tab and I saved them as a file ending with .sql. I upload it to the new ftp, and the company restore it for me. I upload every file in the new directories, changed the config.php to show the new full path, and the result, well, I don't know what went wrong.

The menu/navigation/login box at the top has disappeared. The copyright note also. Options "Archive" and "Top" also are gone. As the forum was closed when the backup took place, the forum on the new server was supposed to give a "vBulletin message". The title and the text appear.. strangely.

(Take a look at the picture, to see the old version at left, the new at right:
http://img262.imageshack.us/img262/8...dandnewaq9.gif).

Can I do something to fix things? Is there anything my host can do, to fix it? What's possibly gone wrong?



Edit: I tried re-downloading all my files, and uploaded them again in the server. No change at all, the same problem remains - I though of the possibility of a file being corrupted.

[Steve Machol]

I can't read that message. However the most likely cause is that the database was not completely backed up or restored.

The only consistently 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 timeout 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

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

[SLGR]

The part you cannot read in the vBulletin message, is supposed to be in greek language, but, it doesn't appear to me correctly, too. I don't know the exact cause for this. The message you do read, is written in english.

As for the broken database, the backup was taken via phpMyAdmin -> export -> save as a file (no zip or gz). I'll read the method you proposed (telnet / ssh), but I don't know whether it is enabled or not. Yet, if this is an operation which requires the co-operation of the ex-host with the new host, well, I'm not satisfied with them, and they are not professionals on what they do. And that's the reason I'm moving. So, I am not quite sure if they will co-operate in such tasks.

P.s I guess it doesn't matter that the new host has plesk installed, instead of cPanel on the previous host.

Thanks for everything.

[SLGR]

Together with phpMyAdmin, I took small backups of 3-5 tables per time, or even one table per time (gzip) when a table was large. I uploaded them, and everything seems to be ok. Main forum page is correctly rendered, greek language appears correctly (it was wrong collation when the host created the new db, fixed that), I can login and logout correctly, I can post correctly, attachments appear good, polls are ok, .....but, I noticed a small detail which could (or not) indicate a problem.

The line that surrounds attachments, is not completed (the red line indicates what's missing) :