백업

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

mysql> select option_name,option_value from wp_options where option_name='siteurl';
+-------------+----------------------------------+
| option_name | option_value                     |
+-------------+----------------------------------+
| siteurl     | http://www.suapapa.net/wordpress |
+-------------+----------------------------------+
1 row in set (0.00 sec)
 
mysql> update wp_options set option_value='http://web.suapapa.net:8080/wordpress' where option_name='siteurl';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
mysql> select option_name,option_value from wp_options where option_name='siteurl';                       +-------------+---------------------------------------+
| option_name | option_value                          |
+-------------+---------------------------------------+
| siteurl     | http://web.suapapa.net:8080/wordpress |
+-------------+---------------------------------------+
1 row in set (0.00 sec)