MyBB Community Forums

Full Version: Restore only threads and posts table from old complete backup
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello sirs,
I want to restores only mybb_threads and my_posts tables from full backup file that i create 2 days bak.

How cn dis be done ?
(2011-08-12, 01:11 AM)th3forum3r Wrote: [ -> ]Hello sirs,
I want to restores only mybb_threads and my_posts tables from full backup file that i create 2 days bak.

How cn dis be done ?

Extract them from the database then import them into the new database.
hw to do dis?
(2011-08-12, 01:16 AM)markwesley Wrote: [ -> ]
(2011-08-12, 01:11 AM)th3forum3r Wrote: [ -> ]Hello sirs,
I want to restores only mybb_threads and my_posts tables from full backup file that i create 2 days bak.

How cn dis be done ?

Extract them from the database then import them into the new database.

(2011-08-12, 01:40 AM)th3forum3r Wrote: [ -> ]hw to do dis?
(2011-08-12, 01:16 AM)markwesley Wrote: [ -> ]
(2011-08-12, 01:11 AM)th3forum3r Wrote: [ -> ]Hello sirs,
I want to restores only mybb_threads and my_posts tables from full backup file that i create 2 days bak.

How cn dis be done ?

Extract them from the database then import them into the new database.

You do it in phpmyadmin.
bt how to do it ?
Login to Phpmyadmin then select the database for your forum, then click on mybb_threads then click export (do the same for mybb_posts) then go to the new database press import then select the 2 files you just exported and press ok and it should work.
Mmm.. From a full backup?
You have to open the backup file and delete all lines that aren't about the threads and posts tables.. A mess, in other words.