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