Previous Thread
Next Thread
Print Thread
Hop To
Joined: Aug 2004
Posts: 460
Addict
Addict
Joined: Aug 2004
Posts: 460
Just wanted to verify that I am handling my backups correctly and not making any mistakes:

1. First I log in as root and do a mysql dump this way:
mysqldump --opt my_ubb -u message_boards -p > ../home/boards/dump.sql

Is there any command or anything I should be adding to create a "better dump" (did that sound bad? smile ) or maybe remove something?

2. Then I compress the file:
cd /home/boards/
tar -zcvf dump.tgz dump.sql


Anything I should be changing here, maybe using a different compression command altogether or a different extension?

3. Downloading the file:
Using ftp and downloading as a BINARY file. It should be Binary, right? smile

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I generally tar my web based files:
Code
tar -cvpzf my_ubb_backup.tgz /path/to/threads

Then backup the database (according to the MySQL Manual --opt is on by default):
Code
mysqldump -uusername -ppassword my_database_name > my_database_name.sql

Then archive the database so that it's smaller and easier to deal with:
Code
tar -cvpzf my_ubb_database.tgz my_database_name.sql

Ultimately the same steps as in the "Gizmo's UBB.Threads 7.x Transfer Guide for Dummies (or not) " guide.


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, 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!
Joined: Aug 2004
Posts: 460
Addict
Addict
Joined: Aug 2004
Posts: 460
Thanks, Gizmo. Seems like I've been forgetting about the "p" option when compressing the mysql dump. Is that something that should be done for security reasons?

For FTP binary is the correct option to download the .tgz file, right?

Joined: Mar 2011
Posts: 39
newbie
newbie
Joined: Mar 2011
Posts: 39
Hey Giz - not butting in but you know how it is when a person is sitting at the computer all night waiting...

Hey Conrad,

File name extensions and their significance:

.txt
A standard ascii text file.
.z
Ambiguous in compression scheme, but -
a "binary" file. Possible compression schemes:
zip, pkzip, "old" unix pack.
.Z
A file that has been compressed by the unix 'compress' utility -
a "binary" file.
.zip
A file(s) or directory that has been compressed by either
'zip' or 'pkzip' - a "binary" file. NOTE: zipping can be
nested: after an 'unzip' there may be files that still need
to be unzipped again.
.gz
A file that has been compressed by the GNU gzip/gunzip utilities -
a "binary" file.
.tar
Usually a directory archive file created by the venerable 'tar'
(originally "Tape ARchive") utility of unix - a binary file.
.tar.gz
A tar archive which has then been gzip'd. This may be the
cleanest way of archiving entire directories, and the easiest
to undo - also a binary file.

Yes it is Binary...





Ancient and Honourable, John West.
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by Conrad
Thanks, Gizmo. Seems like I've been forgetting about the "p" option when compressing the mysql dump. Is that something that should be done for security reasons?
The -p preserves the permissions of the files; so say the chmods on the directory are 777 and files are 666, it'll make sure that they're all as they should be in the archive (Man Page for Tar).

Originally Posted by Conrad
For FTP binary is the correct option to download the .tgz file, right?
Most modern FTP clients should have an "auto" setting; but yes. If you want a complicated, full, description, read here.

Originally Posted by John West
Hey Giz - not butting in but you know how it is when a person is sitting at the computer all night waiting...
Well, I'm a human, not to mention volunteer here (read, not staff), so I'm not here 24/7...



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, 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!
Joined: Mar 2011
Posts: 39
newbie
newbie
Joined: Mar 2011
Posts: 39
Originally Posted by Gizmo
Well, I'm a human, not to mention volunteer here (read, not staff), so I'm not here 24/7...

Exactly why I was apologizing for answering the question since I was here instead of just ignoring the poster. I was talking too you not about you - LAUGHING - Love, Hugs, Spirit!

UBBest!


Ancient and Honourable, John West.
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by John West
Exactly why I was apologizing for answering the question since I was here instead of just ignoring the poster. I was talking too you not about you - LAUGHING - Love, Hugs, Spirit!

UBBest!
:snicker: I fear without some of us, there wouldn't be a whole lot of answers around here... Though that's also why projects like UBBDev and Wiki where started tongue


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, 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!
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Gizmo
Though that's also why projects like UBBDev and Wiki where started tongue

Just in time for a simple html update smile
https://www.ubbdev.com/forums/ubbthreads.php/topics/320572/A_Better_Admin_Footer.html


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Mar 2011
Posts: 39
newbie
newbie
Joined: Mar 2011
Posts: 39
Just find time to have SOME fun gang!

Hey who remembers the default password - 4tugboat? - LAUGHING!!! And phoney url - spider friendly whatever that phase was?

yourdomain.com/cgi-bin/ultimatebb.cgi/ubb/forum/1.html - LAUGHING HARDER!!! I remember the first time I tried it out. I was floored...

We have had some fun I tell ya.


Ancient and Honourable, John West.
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by John West
And phoney url - spider friendly whatever that phase was?
Lol, hey, it was useful at the time, search engines could choke on the old urls, I wonder how valid that is in today's world... I design my sites with mod_rewrite now adays after using the path_info route for eons... Lol.


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, 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!
Joined: Mar 2011
Posts: 39
newbie
newbie
Joined: Mar 2011
Posts: 39
Yes we both know you have to try anything and leave no stone unturned when you are sharpening the cutting edge.

I'll be wrapping up a set of websites that host different portions of a project soon - spread across several servers to handle the load if it goes platinum. We don't want no healthcare.gov crash and burn type of thing! LOL! Anyway it seemed like the best way to handle the load if the websites get busy. And I mean busy...

We will see.

Been great poking at you guys after all these years now get back to work!

John.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)