Tag Archives: MySQL

MySql status shell script

ref.: http://www.linuxquestions.org/questions/linux-newbie-8/shell-script-to-check-whether-mysql-server-is-running-or-not-721940/ #!/bin/sh if [[ -z `service mysqld status | grep running ` ]] then echo 0 else echo 1 fi

MySQL utf8 setup reference

Auto generate Alter table SQL: http://serverfault.com/questions/65043/alter-charset-and-collation-in-all-columns-in-all-tables-in-mysql MySQL doc in Alter table SQL http://dev.mysql.com/doc/refman/5.1/en/alter-table.html Step By Step from latin to utf8 conversion (中文) http://www.dk101.com/Discuz/viewthread.php?tid=161541 mysqldump conversion (linux) http://blogs.law.harvard.edu/djcp/2010/01/convert-mysql-database-from-latin1-to-utf8-the-right-way/

MySQL Tools

source: http://www.developer.com/open/article.php/10930_3867621_2/Five-Indispensable-MySQL-Tools.htm phpMyAdmin 這個不用介紹吧 MySQL Workbench http://wb.mysql.com/ 支援windows/osx/unix多os的MySQL設計軟件,支援ERD設計(像microsoft access那樣) 前身是MySQL Query Browser & Administrator,連db很快! 用來寫foreign key滿好用(誰叫phpMyAdmin的foreign key太爛….) (手動找foreign key index id很煩.. 殺key時一不小心就一堆垃圾) mytop http://jeremy.zawodny.com/mysql/mytop/ Unix上查看MySQL的狀態、效能(跑多少CPU time,吃多少RAM etc)