4,092 reputation
1028
bio website binarysludge.com
location
age
visits member for 5 years, 3 months
seen 2 days ago

Full-stack dev, DBA and/or sysadmin

Twitter: @sublimino


Jun
15
comment Windows keystrokes/combos you couldn't live without
Alt+F4 closes a parent program + child windows, Ctrl+W closes a window (try in a tabbed browser)
Jun
15
comment BASH shell session logging on remote host
Thanks Geoff, looks like I might be stuck with script then.
Jun
15
comment BASH shell session logging on remote host
The output of screen is equivalent to script - ncurses handling appears unsupported.
Jun
15
awarded  Commentator
Jun
15
comment BASH shell session logging on remote host
Personal auditing and plain text logging; playback of sessions is not required.
Jun
15
answered What is the recommended temperature range for a hard drive?
Jun
15
revised BASH shell session logging on remote host
added explicit shell session
Jun
14
comment BASH shell session logging on remote host
Thanks, but it's not suitable as I spend time on the shell with top open, which screen records as: [andy@165 ~]$ top ESC[HESC[2JESC(BESC[mtop - 23:34:49 up 19 days, 17:42, 1 user, load average: 0.11, 0.07, 0.01ESC(BESC[mESC[39;49mESC[K
Jun
14
asked BASH shell session logging on remote host
Jun
14
comment How can I view a website on my server without assigning a domain name to it?
can you check your logs in /var/log/httpd/error_log (and perhaps the logs specified by you above)? It sounds like you have a default virtual host (your only current domain) which is being used to handle all requests due to a possible httpd.conf error :)
Jun
10
awarded  Scholar
Jun
10
accepted Data loss due to MySQL DRBD Heartbeat failover script
Jun
10
comment Updating a MySQL Database
@Niko you're correct, the downtime is unknown; I have amended my answer to avoid a server restart
Jun
10
revised Updating a MySQL Database
typo
Jun
9
revised Bulk or mass killing misbehaving MySQL queries
adding good info from another comment
Jun
9
comment Updating a MySQL Database
@David - with regards to schema, "We need to merge an older backed up database" implies that the old database is a version of the current. As such, the live primary keys / auto_increment must be considered final - otherwise which version of the data do you consider authoritative? I know of no automated way to distinguish on a per row basis without explicit TIMESTAMP columns and further scripting. INSERT IGNORE will skip conflicting keys, REPLACE INTO overwrites them - the former is functionally equivalent to a SELECT INSERT on a null primary key, without requisite prior knowledge of keys.
Jun
8
answered Automated website folder backup system needed? Any recommendations?
Jun
8
comment Automated website folder backup system needed? Any recommendations?
I don't think it's possible to link to that particular page as the link is truncated slightly - sort it out serverfault! en.wikipedia.org/wiki/Unison_(file_synchronizer)
Jun
6
comment Best system administrator accident
+1 for the last paragraph - the "sit on your hands" technique, one vital minute for reflection
Jun
6
answered Bulk or mass killing misbehaving MySQL queries