klenwell information services : MysqlAdmin

Revision [1757]

This is an old revision of MysqlAdmin made by KlenwellAdmin on 2010-12-02 18:46:35.
 

Mysql Administration

return to DevMysql

Basic Mysqldump

From linux command line.
Note: time command will output the time it takes, useful as a benchmark
# backup selected databases
time mysqldump DB_NAME | bzip2 > /tmp/DB_NAME-$(date +%Y%m%d).bz2

# restore
bunzip2 < /tmp/DB_NAME-$(date +%Y%m%d).bz2 | mysql -uUSER -p 

Reference: mysqldump Man

Show Running Queries

$ mysql -uroot -p -e "SHOW PROCESSLIST"

Reference: http://forge.mysql.com/tools/tool.php?id=42


References

Kill Mysql Queries (forge.mysql.com)