Reputation
2,479
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 12 18
Newest
 Yearling
Impact
~240k people reached

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
Jun
11
asked How can I lauch a GNU screen from jailshell (no pty)
Jun
11
answered GNU Screen and .bashrc
Jun
10
answered How do you setup ssh to authenticate using keys instead of a username / password?
Jun
10
answered What are useful .screenrc settings?
Jun
10
answered Suggestions for entries in a sysadmins .vimrc
Jun
10
answered What useful things can one add to one's .bashrc?
May
28
answered What configuration options for MySQL provide the biggest speed improvements?
May
28
awarded  Supporter
May
28
answered Altering a column length on a large Innodb table with minimal downtime