Ubuntu 上 initialise stock database

1. 安裝 mysql-server & mysql-client
2. 安裝對應的 mysql perl & php libraries
3. 安裝 mysql server 的時侯, 會要求設定 root password. 如果忘了 root password, 也可以重新安裝 mysql server, 就會重新設定 root password
4. 用 mysql -u root -p 進入, 然後增加需要的 account
mysql> CREATE USER 'somebody'@'localhost' IDENTIFIED BY 'somepassword';
5. 建立 database
mysql> create database;
6. Export database
# Export table structure and data
mysqldump -u username -ppassword database_name > dump.sql
# Export table structure only
mysqldump -u username -ppassword –no-data database_name > dump.sql
# Export  data only
mysqldump -u username -ppassword –no-create-info database_name > dump.sql
# Export multiple databases
mysqldump -u username -ppassword –databases db_name1 [db_name2 ...] > dump.sql
# Export all databases
mysqldump -u username -ppassword –all-databases > dump.sql   
# Import table
mysql -u username -ppassword database_name < dump.sql