백업

mysqldump --single-transaction --opt -u $DBUSER -p$DBPASS $DBNAME > backup.sql

복구시에는 DB와 User 생성 필요:

$ mysql -u adminusername -p mysql
...
mysql> create user 'blog_admin'@'localhost' identified by 'password'; 
mysql> CREATE DATABASE databasename;
mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname"
    -> IDENTIFIED BY "password";
mysql> FLUSH PRIVILEGES;
mysql> EXIT