The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
how to merge posts from pruned database?
my vbulletin mysql database was backed up a month ago. Then a week later an admin pruned a lot of posts, we did not find out this until today. So the question is how can I import/merge the posts from the very old database to bring back all the pruned posts?
thanks. |
#2
|
|||
|
|||
The only way to do so would be to use ImpEx:
- Restore the backup into a new database. - Install a second copy of vBulletin as a testsite and connect to the restored database. - Clean (delete) all information you do not want to import - Use ImpEx to merge the cleaned backup database into your production database. PS This might cause problems with ImpEx restoring the threads into new forums, but that is something you can repair afterwards. Try this on a testboard first!!! |
#3
|
|||
|
|||
Quote:
|
#4
|
|||
|
|||
Cleaning should be done using the regular tools vBulletin offers, not in a tool like phpMyAdmin.
Yes ImpEx is sequential, but it will merge useraccounts if the username and email address matches, so you should not get many duplicate users (only if they changed name or email address since the backup was made. You will get new usergroups/forums, but it should be a few minutes work to merge these with the existing ones. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|