miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
Specific miniBB Support Forums / Specific /   

Backup restore

Author Ojlert
Registered
#1 | Posted: 4 Oct 2009 14:27 
If I want to restore the forum using a backup, do I only need to replace the current database with the backup?

After that the forum will worj as normal?

Should I make the forum inaccessible somehow while doing the backup?

Author Paul
Lead Developer
#2 | Posted: 5 Oct 2009 04:15 | Edited by: Paul 
The only program I recommend for restoring mySQL backups, is Bigdump.

Restoring happens very quickly, so most likely you won't need to take additional actions; anyway stopping forums temporary would be a good idea.

Author Ojlert
Registered
#3 | Posted: 5 Oct 2009 11:39 | Edited by: Ojlert 
So you don't think using cpanel/phpmyadmin is a good idea?

I'll take a look at Bigdump..

Author Paul
Lead Developer
#4 | Posted: 6 Oct 2009 04:33 
phpMyAdmin is not really suitable tool for restoring big-size backups (truly, for making big-size dumps, too). And it works only via web-form, with Bigdump you can upload your dump first somewhere using FTP, then setting options phpMyAdmin doesn't ever have, to restore the back-up smoothly in couple of seconds. It's more "manual and precise" tool IMO.

I'm using this tool in my practice very often and so far I could say the programmer did a great job (it's not an affiliate advertisement ;)

Author Danny2000
Registered
#5 | Posted: 3 Apr 2010 05:45 
I lost very important topic.. so I have backup from yesterday.. but I don't want lose today's topic and posts.. so how can I restore just that topic ?

Author Paul
Lead Developer
#6 | Posted: 6 Apr 2010 04:23 
Danny2000
It may be difficult for a newbie. You will need to build SQL commands list manually.

Follow backup file (I suppose it is standard plain text backup) and locate this topic's ID in `topics` table backup. SQL string would look like

INSERT INTO `topics` VALUES (TOPIC_ID,...

where TOPIC_ID stands for the numerical ID. Copy the entire INSERT statement into some new plain text file.

Then follow `posts` table backup. Where it says

INSERT INTO `posts` VALUES...

follow all strings which contain TOPIC_ID as the third value after comma in INSERT statements. Then copy these strings to the new plain text file where you've had topic's statement already.

Then you have to remove TOPIC_ID value from `topics` statement and apply it on your current live forums table. It should insert new topic with its new ID. You have to know this ID and change it in `posts` statements. Then apply all `posts` statements over your live table.

Specific miniBB Support Forums / Specific / Backup restore Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
You are welcome to post anonymously, by entering a nickname with no password (if the similar Username has not been taken yet), or by leaving both fields empty. If you have a forums account, you can also sign in from this page without posting a message, or sign in and post at once.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Get the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB