MySQL Administration Memo

Database Backup

  1. Command Used to back up a database in Linux

mysqldump -u root -p edusoho > edusoho.sql

  1. MySQL Directory Layout

If install from rpm package, the .lib .h and all other type of files are placed by rpm into the corresponding directories

If install by uncompressing a tar, the mysql directory layout will be preserved.

  1. MySQL Command

mysql > show processlist;

mysql > show status;