Previous Thread
Next Thread
Print Thread
Hop To
How do I backup my forums?
#191156 07/14/2007 7:43 PM
Joined: Jun 2006
Posts: 15,938
Likes: 27
Gizmo Online Tapedshut OP
UBB.threads Developer
OP Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,938
Likes: 27
The recommended method is listed below; this is not the only method but it's what tends to go the fastest (especially with larger forums). We only recommend using the built in "backup database" tool as a last resort as it'll take forever to run on even a moderately small forum.

Please Note: MySQL File Creation times, Compression Times, Extraction Times, and Download Times will vary based on Server Resources, Database and Archive size, and Internet Connection Speed.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, I Find Rocks, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: How do I backup my forums?
Gizmo #191157 07/14/2007 7:44 PM
Joined: Jun 2006
Posts: 15,938
Likes: 27
Gizmo Online Tapedshut OP
UBB.threads Developer
OP Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,938
Likes: 27
MySQL Backup in Unix or Linux
If you're on a Linux/Unix machine, you can use the Command Line tools via SSH to create a database dump (backup of the mysql database) by inserting the command:
Quote
mysqldump -uusername -ppassword databasename > databasename.sql

If you wish to compress the above output so that it's easier to transfer around, then you can do:
Quote
tar -cvpzf databasename.tgz databasename.sql

If you've compressed the output and would like to decompress it, then you can run:
Quote
tar -xzvf databasename.tgz
(the output will extract as databasename/databasename.sql)

And to restore said backup, after you purge data out of the MySQL database:
Quote
mysql -h localhost -uusername -ppassword databasename < databasename.sql


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, I Find Rocks, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: How do I backup my forums?
Gizmo #191159 07/14/2007 7:54 PM
Joined: Jun 2006
Posts: 15,938
Likes: 27
Gizmo Online Tapedshut OP
UBB.threads Developer
OP Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,938
Likes: 27
File Backup in Linux or Unix
You can easily backup your entire UBB.Threads directory (with or without the cache) with a quick one liner:

Without the Cache:
Quote
tar -cvpzf forum_backup.tgz /path/to/your/forum --exclude-from=/path/to/your/forum/cache

With the Cache:
Quote
tar -cvpzf forum_backup.tgz /path/to/your/forum

Extracting the Backup:
Quote
tar -xzvf forum_backup.tgz


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, I Find Rocks, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: How do I backup my forums?
Gizmo #191164 07/14/2007 8:14 PM
Joined: Jun 2006
Posts: 15,938
Likes: 27
Gizmo Online Tapedshut OP
UBB.threads Developer
OP Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,938
Likes: 27
PHPMyAdmin Notice
I myself don't recommend that you create your database backup from within PHPMyAdmin (or any other web script) as it can take much longer than the aforementioned methods as you're hopping through the webserver to do something that it doesn't really need to be doing.

Another issue with using PHP scripts to create a database dump is that you could end up hitting the "PHP Maximum Execution Time" limit which is usually about 60 seconds... If this is the case, the archive you're presented with will generally not be complete and you'll end up with missing records. This is generally not a problem with databases under 100mb or so; but is still something one would have to worry about.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, I Find Rocks, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
[NOTABUG] Report Post bug..
by Morgan - 07/05/2020 1:48 PM
Trial Subscription question.
by Ruben - 07/03/2020 2:34 PM
Unread posts no longer tracked per user...
by KirkW - 06/16/2020 12:21 AM
Max Image file size upload
by jjjjj - 06/10/2020 10:25 PM
Error on Inert into POSTS
by jjjjj - 06/07/2020 8:09 PM
Who's Online Now
2 members (Morgan, JAISP), 82 guests, and 61 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4