Copy drupal from kpchiaoi5 to kpci7

In kpchiai5:

1. mysqldump -u drupaladmin -h localhost --skip-lock-tables -p drupal > drupal_20160826_kpchiaoi5.sql
2. gzip -9 drupal_20160826_kpchiaoi5.sql
3. sudo tar zcvf public_html_drupal_20160826_kpchiaoi5.tgz public_html/drupal

In kpci5:

1. download from kpchiaoi5: drupal_20160826_kpchiaoi5.sql.gz, public_html_drupal_20160826_kpchiaoi5.tgz
2. gzip -dc drupal_20160826_kpchiaoi5.sql.gz | sed -e '/^UNLOCK/d' -e '/^LOCK/d' > ~/a.sql
3. Using phpmyadmin to drop all drupal tables.
4. mysql -u drupaladmin -p drupal < ~/a.sql
5. sudo tar zxvfp public_html_drupal_20160826_kpchiaoi5.tgz -C /home/chiao
6. sudo chown -R www-data.www-data /home/chiao/public_html/drupal (IMPORTANT!!!!)
7. 6. 設定 -> 開發 -> 效能 -> 清除所有快取