Reputation
2,559
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
2 12 18
Newest
 Yearling
Impact
~258k people reached

Jul
27
comment How do you use VIM to edit tabular data (tables)? Specifically, BIND (named) DNS db files
Actually it's feature request #22 on the list. vim.org/sponsor/vote_results.php
Jul
27
comment How can I lauch a GNU screen from jailshell (no pty)
I did ask for access to bash and was told that it would give me root access and they, of course, can't do that on a shared server. I know that is a load of crap because my day job is as a MySQL DBA, Linux System Administrator, and Manager of a team of Linux System Administrators. I didn't argue because I know that arguing with someone who is willing to lie to you and insult your intelligence... is a fruitless demonstration of your lack of intelligence. What I didn't know is that WHM controls it. I will try to social engineer my way into it. Thanks for the lead.
Jul
27
accepted How can I lauch a GNU screen from jailshell (no pty)
Jul
23
comment How to export a MySQL DB to MSSQL Database?
Can you assure that there will be no data changes to the MySQL DB for the duration of the export? That opens up a lot of options.
Jul
23
revised Where is my mysql log on OS X?
typo
Jul
20
revised Where is my mysql log on OS X?
typo
Jul
20
answered Where is my mysql log on OS X?
Jul
20
comment MySQL Enterprise backup tool for automation and management
You don't mention: Host OS, MySQL version, storage engines used. You cannot get good advice without sharing those details.
Jul
20
answered MySQL Enterprise backup tool for automation and management
Jul
20
awarded  Autobiographer
Jul
9
answered Best way to make sure a MySQL database is fully in UTF8
Jul
9
comment Best way to make sure a MySQL database is fully in UTF8
Yeah, you'd need to use something like awk instead of grep. Because I cannot get legible formatting in a comment, I'll post it in another answer.
Jul
9
comment Web server and database server in completely different locations
Local replication is probably the solution for you. If you are able to modify you application to segregate reads (keeping them local) and writes (sending them to the master), then you are in business. If you are able to do this, you should also be able to modify the app to use memcached. If you can't modify the app, then you could use MySQL Proxy to do the segregation.
Jul
9
comment Fast Bulk Import of a Large Dataset into MySQL
info about the data source/format, MySQL version, preferred destination engine, and intended use after load would help us give you an excellent answer.
Jul
9
answered How can I copy MySQL users table from one server to another?
Jul
9
awarded  Enthusiast
Jun
30
answered mysqld problems
Jun
29
answered how do I flush EVERYTHING with respect to privileges on mysql
Jun
29
answered Is it possible to have complete backup of mysql database server from command line?
Jun
29
comment Best way to make sure a MySQL database is fully in UTF8
While I have great respect for bash-fu, these are inappropriate uses. You are obviously skilled and would benefit from getting familiar with dev.mysql.com/doc/refman/5.0/en/information-schema.html and the uber-useful dev.mysql.com/doc/refman/5.0/en/… The GROUP_CONCAT is very useful for generating valid SQL with SQL which is then piped to a secondary mysql call. I demonstrate this here: serverfault.com/questions/8860/…