Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (mmkk, Gizmo, packlite), 81 guests, and 432 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
whk
whk
Portsmouth, RI
Posts: 86
Joined: January 2009
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 18
M4TT 12
FREAK 11
Ruben 8
isaac 4
mmkk 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
How do I backup my forums? #191156
07/14/07 06:43 PM
07/14/07 06:43 PM
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Online tapedshut OP
UBB.threads Developer
Gizmo  Online Tapedshut OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
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.
Forums: A Gardeners Forum 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!
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: How do I backup my forums? [Re: Gizmo] #191157
07/14/07 06:44 PM
07/14/07 06:44 PM
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Online tapedshut OP
UBB.threads Developer
Gizmo  Online Tapedshut OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
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.
Forums: A Gardeners Forum 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? [Re: Gizmo] #191159
07/14/07 06:54 PM
07/14/07 06:54 PM
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Online tapedshut OP
UBB.threads Developer
Gizmo  Online Tapedshut OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
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.
Forums: A Gardeners Forum 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? [Re: Gizmo] #191164
07/14/07 07:14 PM
07/14/07 07:14 PM
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Online tapedshut OP
UBB.threads Developer
Gizmo  Online Tapedshut OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
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.
Forums: A Gardeners Forum 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!

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)