|
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.sqlIs there any command or anything I should be adding to create a "better dump" (did that sound bad? ) or maybe remove something? 2. Then I compress the file: cd /home/boards/ tar -zcvf dump.tgz dump.sqlAnything 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?
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
I generally tar my web based files: tar -cvpzf my_ubb_backup.tgz /path/to/threads Then backup the database (according to the MySQL Manual --opt is on by default): mysqldump -uusername -ppassword my_database_name > my_database_name.sql Then archive the database so that it's smaller and easier to deal with: 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.
|
|
|
|
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
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
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). 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. 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...
|
|
|
|
Joined: Mar 2011
Posts: 39
newbie
|
newbie
Joined: Mar 2011
Posts: 39 |
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
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
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
|
|
|
|
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
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
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.
|
|
|
|
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.
|
|
|
1 members (Havenofsobriety),
522
guests, and
99
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|