I purged alot of threads trying to sort out a slow database issue. Turns out it wasn't the database size that was the issue.
I'm trying to restore the threads back from May 12 2011.
Below is what my server folks have suggested....will this work??
Hi Dan I'm using a test database to see what is there and see if I can remove what I don't need. I'm not sure how I do that yet.I think I first need to see what exactly gets removed when I use the purgethread option in Vbulletin. I do know I need all threads/posts from May 12, 2011 and before. I also know that I need this information inserted into the database all while keeping thecurrent threads/posts from May 13, 2011 to date. Any help would be appreciated. ThanksPaul |
From: Daniel Hello,It should be possible to modify the backup file to prevent anything fromoverwriting, but I will have to check the contents of the file to make sure ofthat. Is this the backup file you wish to import?/backup/cpbackup/monthly/dbstuff/********/mysql/vbforum.sqlRegards,Dan |
From: Paul Thanks DanThat is the correct file. |
From: Daniel Wells <[email protected]> Hello,I can modify the backup to disable the commands that would reset the tablesand run the import such that it will continue to import if it sees a duplicateprimary key.That should import any "missing" posts, as long as the forum hasntbeen trying to reuse that primary key range. If that is not the case you will have to manually renumber the old posts inorder to import them. Would you like me to try that?Regards,Dan |
Comment