449 reputation
39
bio website twitter.com/racyclist
location
age
visits member for 4 years, 11 months
seen Jan 8 at 23:01

Oct
8
awarded  Enlightened
Oct
8
awarded  Nice Answer
Apr
26
awarded  Popular Question
Dec
9
awarded  Yearling
Jun
8
awarded  Caucus
Jun
10
comment Looking for the best way to backup Mysql
+1 reliability. Stoping the slave and making a snapshot of the database files will provide a more reliable (and easier to restore) backup of mysql.
Jun
9
answered Server Memory Usage VERY high on new linux dedi box - How to find the issue?
Jun
7
comment Apache Virtual Hosts with a Wildcard DNS Record
Just make sure this config is read last so that the other sites aren't effected.
Jun
7
comment Question: MySQL db Migration from Server(A) to Server(B), which tables?
You can change the first query "mysql -pPASSWORD --batch --skip-column-names -e "SELECT user, host FROM user" mysql" to "mysql -pPASSWORD --batch --skip-column-names -e "select user,host from db where Db='DATABASE_NAME'" mysql" That will limit it to a specific database. It will only dump users who have been specifically granted permissions on that database and not users with global privileges who may also have permissions on that database.
Jun
7
comment Question: MySQL db Migration from Server(A) to Server(B), which tables?
Are you asking how to export the users that have permissions on one specific database?
Jun
2
awarded  Editor
Jun
2
revised Question: MySQL db Migration from Server(A) to Server(B), which tables?
clarified what the script was used for.
Jun
2
answered Question: MySQL db Migration from Server(A) to Server(B), which tables?
Jun
1
awarded  Critic
May
31
comment MySQL connection doesn't work anymore
-p is for password -P is for port. Try mysql -h 127.0.0.1 -p -P 3307
May
31
awarded  Commentator
May
31
comment MySQL connection doesn't work anymore
which System Error code do you get?
May
23
answered SLES 11.1 install dvd accidentally added to yast
May
12
answered Easiest way to sync a dev MySQL db to a production MySQL db?
Apr
8
answered Cpanel server wildcard ssl certificate