PDA

View Full Version : How to add back posts to database? ADVICE PLEASE


dreamygirl
08-27-2010, 11:21 PM
To make a long story short: I have a running vbulletin 3.7x. Then I have a Post table (from a non-live database) which has more posts that I am viewing in PhpMyAdmin. I need to "salvage" these posts. I'm pretty sure I can't just export these additional posts and import them into the "live" post database. What else do I need to do?

It seems like the main problem is lacking the Threads table data, plus there is a counter somewhere that is out of sync?

(I think I actually have the thread data but that's another issue, I am confused why I can't view it in phpMyAdmin when I can see it's there if I just view as text.)

I had this situation happen years ago back on an older version. It was a small number of posts so I was able to manually repost them. This time it's a large number and I would greatly appreciate any advice to get me on the right path.

Xtrigit
08-28-2010, 03:52 AM
See if repairing the tables solves the problem.

Lynne
08-28-2010, 04:12 AM
^^ What he said. If repair/optimize doesn't work from the admincp, see this 3 ways to repair a database (http://www.vbulletin.com/forum/showthread.php?44909-3-ways-to-repair-a-database)

dreamygirl
08-28-2010, 08:59 PM
Repairing isn't helping. Repaired a number of times, without the reapir I can't load things so it's not corrupted.