network profile
| bio | website | bronosky.com |
|---|---|---|
| location | Atlanta, GA | |
| age | 34 | |
| visits | member for | 4 years |
| seen | Apr 29 at 1:52 | |
| stats | profile views | 307 |
MySQL DBA, Internet Systems Manager (Manager of the Linux Sys Admins) at the Atlanta Journal-Constitution
I'm on LinkedIn, Facebook, Twitter
NOTE TO ALL: Everyone should have some form of contact info in their profiles. If nothing else, it is respectful to the people who answer your questions to allow them to tweet you to say, "I gave you a rock'n answer a few weeks ago, but you haven't given any feedback. Did it work for you?" or "Hey there are comments on your question asking for more details, but you are not giving us what we need to help you properly."
|
Jun 16 |
answered | vim re-edit as root |
|
Jun 16 |
comment |
vim re-edit as root @dbr, I think it is worth mentioning that after you overwrite the file (with tee as sudo), you will get prompted with [O]k or [L]oad. The later option will erase your undo history an reset the "modified flag" allowing you to exit without being warned to save changes. The former option, which I prefer, will preserve your undo history, but will cause you to get warned when you try to quit. You have to use :q! to quit in this case. I do this so I can validate (e.g. :!sudo /etc/init.d/httpd configtest) and rollback/reedit if I need to. |
|
Jun 16 |
comment |
vim re-edit as root @rkthkr, if "vim restarted and run as root" you would be unable to save any edits you have made, and lose your undo history. But if that is what you want... [Ran out of characters.] See the "answer" I'm about to write. |
|
Jun 16 |
awarded | Commentator |
|
Jun 15 |
comment |
How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files This looks like a very cool plugin. From what I can tell it modifies that file, rather than simply presenting it in a special way. Thank you for the lead. I will use this plugin for some things, but I cannot use it for my DNS zone files. The admin would flip out (and rightfully so) if I alter every line of every file I touch. |
|
Jun 15 |
answered | Is there any reason to use 64bit MySQL (and OS) on small databases? |
|
Jun 15 |
comment |
Is there any reason to use 64bit MySQL (and OS) on small databases? How big do you expect your dataset to grow to? Disk space and/or number of rows is what I am asking for. |
|
Jun 15 |
asked | How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files |
|
Jun 13 |
comment |
How can I export the privileges from MySQL and then import to a new server? Great info in that link, thanks. Bookmarked. |
|
Jun 13 |
answered | Permanent SSH Connection via Bash Script? |
|
Jun 13 |
awarded | Critic |
|
Jun 13 |
comment |
How can I export the privileges from MySQL and then import to a new server? Merging into a existing mysql schema, data extracted from a mysql schema via mysqldump is almost certain to be problematic. You are manipulating a complex schema with enforced relationships, etc. This schema is so complex, in fact, that they created dedicated SQL syntax (GRANT, REVOKE, DROP USER, etc.) for dealing with it. Your extract, however, consists of only INSERT statements. I'm running out of characters here. Need I continue? |
|
Jun 12 |
answered | Visualization Tools for Web App and Database Servers Performance Monitoring |
|
Jun 12 |
comment |
Transferring data between SQL Server and MySQL I spent months with our MSSQL and SSIS guys trying to get various "connectors" to allow MS to insert/update data on my MySQL servers. We got a lot of implementations functioning, but none were production-safe. I had one of my Python developers right a command line app that uses the pymssql and MySQLdb libraries. It is fast and reliable (cron-safe in production). We haven't FOSS'ed it yet because every now and then we find a datatype that needs mapping. We make all of our offerings under the MIT license. Are you interested? I can introduce it as a 0.x release. |
|
Jun 12 |
comment |
How can I lauch a GNU screen from jailshell (no pty) No offense, but I hope there is something you guys are overlooking. I'm going to leave this open a little longer. What I have is a working terminal (ssh connection), but I have a limited (possibly chrooted) shell. |
|
Jun 12 |
answered | Using MySQL replication to enable a read-only copy of a database in a DMZ |
|
Jun 12 |
revised |
How can I export the privileges from MySQL and then import to a new server? improved formatting |
|
Jun 11 |
answered | How do you use SCP to copy a deep directory? |
|
Jun 11 |
comment |
How can I export the privileges from MySQL and then import to a new server? 1. Is it a requirement for you to use PHPMyAdmin? If it is I will write some PHPMyAdmin specific instructions for you. 2. From PHPMyAdmin if you try to "select * from mysql.user limit 1;" do you get results or an error. |
|
Jun 11 |
awarded | Student |
