miniBB ® 

miniBB

®
Support Forums
  
 | Start | Register | Search | Statistics | File Bank | Manual |
Specific miniBB Support Forums / Specific /  
 

Backup restore

 
Author Ojlert
Partaker
#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 
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
Partaker
#3 | Posted: 5 Oct 2009 11:39 
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
Partaker
#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
 Share Topic's Link

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


  ?
Post as a Guest, leaving the Password field blank. You could also enter a Guest name, if it's not taken by a member yet. Sign-in and post at once, or just sign-in, bypassing the message's text.


Before posting, make sure your message is compliant with forum rules; otherwise it could be locked or removed with no explanation.

 

 
miniBB Support Forums Powered by Forum Software miniBB ® Home  Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contact Us
Proceed with the Captcha add-on: protect your miniBB-forums from the automated spam and flood.


  ⇑