Reputation
16,066
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 37 67
Newest
 Enlightened
Impact
~882k people reached

May
20
awarded  Nice Answer
May
20
awarded  Yearling
May
19
answered Apache: Scammers point dozens of domain names at my dedicated IP. How to prevent this?
Mar
9
awarded  Autobiographer
Feb
15
awarded  Citizen Patrol
Feb
11
comment backing up my linux server to my windows machine
Well, the easy way is to just rsync them. Bacula always appends, so you can only be out the last backup. The fancy way is to write one job per file ("tape"), and query the database for files that are marked "done".
Feb
10
comment Iptables ignoring a rule in the config file
Gnarly things are going on in your machine. It is suspect, and should be wiped clean and rebuilt.
Feb
8
comment backing up my linux server to my windows machine
Well, if he were talking about just keeping a copy of his home directory, I'd say rsync alone is enough. A straight rsync solution doesn't provide for increments by period, and doesn't provide a mechanism to dump MySQL without layering another scripting layer on top. While rsync will cut down on bandwidth like the Bacula + rsync method would, I feel in his case the complication may be worthwhile. I think he has both arguments in full and can just decide what works for him from here... he knows more about what he needs than I do. :)
Feb
8
comment backing up my linux server to my windows machine
He should run the storage daemon on the same machine he's backing up, and use the Windows machine to move the tape files that are done being written to.
Feb
8
answered backing up my linux server to my windows machine
Feb
8
revised Iptables ignoring a rule in the config file
added 221 characters in body
Feb
7
answered Iptables ignoring a rule in the config file
Feb
5
comment MySQL for SQL Server DBAs
@danlefree You are correct.
Feb
5
comment MySQL for SQL Server DBAs
+1, this answer is my answer too. Percona, especially the MySQL Performance Blog. Then, play with it. Conventional wisdom with InnoDB is to use mysqldump with --single-transaction --all-databases. If you have a big enough system running, Percona has a free hot-dump backup system.
Jan
28
revised why ATM and MPLS are at level 2.5
added 657 characters in body
Jan
26
comment Pass your password to your SSH key via a script
The alternative you're proposing is providing a method of getting the encrypted key and password to decrypt it from the filesystem. I can't readily imagine a circumstance in which this is less secure than the unencrypted key being held within a program's memory.
Jan
26
answered why ATM and MPLS are at level 2.5
Jan
20
comment Backing up a MySQL database - while it is still in use
I would define "sufficiently large" as a hunch. If your database backs up fast enough with this method and causes no issues for you, go with it. "Fast enough" is up to you. So far, it has been doable for you to fully take the site offline for backups, so I imagine this will be a rather quick process. I would change over if it was taking the better part of the day, causing a load which the database can't keep up with (only likely with deletions), or if I were really bored.
Jan
20
answered Backing up a MySQL database - while it is still in use
Jan
20
answered How to display interface in tcpdump output flow?