Need help cant read post after transfering to new server

[Marco van Herwaarden]

That doesn't explain how it was created.

See the following on how to backup/restore. Also ensure that both new and old database use the same Character Set.

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

[PAKIDIL]

one thing i obeserve is my sql file is 38.8 mb and database after restore is 29.8 mb .is that okay ?

[PAKIDIL]

hello,

i have import database when i do it its original size is 38.2 but when i import it its shows sometime 29.2 mb or sometimes 32.1 mb

error i m getting is that
when i open my forum its open with no problem all things there username working stats showing ,threads showing and also reply also ther written 3 replies or 4 replies in the topic when i click on the topic nothing there and this message comes :

No Thread specified. If you followed a valid link, please notify the administrator

or in somepost no post ther eno messge there nothing . just create thread or close thread and below reply box thatz it


here is the link :

http://208.43.28.29/~pakidil/forum/index.php

one thing i check in phpmyadmin in post .all posts are there .but can not view on forum
please need help
waiting for reply

[Lynne]

Have you gone to Admin CP > Maintenance > Repair / Optimize Tables and tried to repair/optimize any of the tables? Or Admin CP > Maintenance > Update Counters > Rebuild Thread Information ?

[PAKIDIL]

yes i tried but nothing happenes. this is wots comes in CP > Maintenance > Repair / Optimize Tables and tried to repair/optimize any of the tables

Data Length Index Length Overhead
post 813.2 KB 663.0 KB 0

[Marco van Herwaarden]

How did you backup/restore your database?

[Marco van Herwaarden]

Threads on same topic merged.

[Lynne]

Originally Posted by PAKIDIL

yes i tried but nothing happenes. this is wots comes in CP > Maintenance > Repair / Optimize Tables and tried to repair/optimize any of the tables

Data Length Index Length Overhead
post 813.2 KB 663.0 KB 0

So, you saw the page which showed the table above and then you checked all the boxes and hit Repair/Optimize on the bottom of the screen? Did you do that a couple of times until all the tables said they were up-to-date?

[PAKIDIL]

yeah all update the intresting part is when i click on members profile any of my member and click on find all post by him .then posts are showing from there only.

--------------- Added [DATE]1217517586[/DATE] at [TIME]1217517586[/TIME] ---------------

Originally Posted by Marco van Herwaarden

How did you backup/restore your database?

i ask the guy to whom i got the hosting .he said to me that upload database in account by ftp .he said that he didnt download database to his computer from my hosting account .he just move it to the server directly so no internet speed issue ?

[Lynne]

Have you run anything under Maintenance > Update Counters ?