Portal Home > Knowledgebase > Articles Database > Merging 2 Databases
Merging 2 Databases
Posted by zippyhosts, 05-26-2011, 02:51 PM |
Hello,
i have an Vbulletin Database file. recently i have deleted some ids in the site and by deleting the ids, there posts, polls and other stuff also got deleted. i have the backup of the database before deleting the id. right now i want to retrieve there ids and there corresponding posts.
i have a database that is running live in the site . so is there any way to merge the 2 database, so that the ids which got deleted can only be retrieved ?
|
Posted by relichost, 05-26-2011, 02:55 PM |
Hi
bit of an up hill task, but you need to study the mysql tables and work out which tables are involved in the users and posts.. then select all the posts and user id's into a third DB, and then import those into the live DB.
Have you tried posting your question to the vbulletin forums ?
Thanks
|
Posted by zippyhosts, 05-26-2011, 02:57 PM |
i guess we have a option to merge the database, so that only deleted tables and posts will be merged to the live database.
if there is an option like this, can anyone help me
|
Posted by speckl, 05-27-2011, 09:59 AM |
Id use php for this. Check if the row exists or not and add your insert query.
Not difficult at all.
|
Posted by Hoopla-Brad, 05-27-2011, 08:47 PM |
Head over to the Vbulletin forums, they have would have more experience than the users here
|
Add to Favourites Print this Article
Also Read