新增PPA

sudo add-apt-repository ppa:ondrej/php

更新PPA資料源

sudo apt-get update

安裝apache2

sudo apt-get install apache2

安裝mysql 5.7

sudo apt-get install mysql-client-5.7 mysql-server-5.7

安裝php 7.3 和其他套件

sudo apt-get install php7.3 php7.3-bz2 php7.3-cgi php7.3-cli php7.3-common php7.3-curl php-dev php7.3-fpm php7.3-gd php7.3-imap php7.3-intl php7.3-json php7.3-ldap php7.3-mbstring php7.3-mysql php7.3-odbc php7.3-sybase php7.3-xml php7.3-zip

安裝 libapache2-mod-php7.3

sudo apt-get install libapache2-mod-php7.3

安裝phpmyadmin

sudo apt-get install phpmyadmin

enable rewrite

sudo a2enmod rewrite

enable speling

sudo a2enmod speling

關閉mysql strict mode，新增一個disable_strict_mode.cnf，記得重啟mysql生效

sudo vim /etc/mysql/conf.d/disable_strict_mode.cnf

[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

變更root directory

sudo vim /etc/passwd

sync file

匯出所有的資料庫

mysqldump -u root -p --all-databases --skip-lock-tables -f > vsi_all.sql

匯入所有的資料庫

mysql -u root -p < vsi_all.sql

tar壓縮檔案成bz2,exclude log, -p保留原權限

sudo tar -jpcv -f /web/web_all.tar.bz2 --exclude=log --exclude=Backup /web/

rsync檔案 -P是續傳和進度顯示

sudo rsync -e "ssh -p 87" -avhP web_all.tar.bz2 web1admin@206.198.231.21:/web/

解壓縮tar檔

sudo tar -jxv -f /web/web_all.tar.bz2 -C /web/

rsync資料

sudo rsync -e "ssh -p 87" -avhP --exclude 'Backup' --exclude 'log' /web/ web1admin@206.198.231.21:/web/

sendmail

安裝sendmail

sudo apt-get install sendmail

加入domain 到local-host-names，一行一個domain，允許收發信

sudo vim /etc/mail/local-host-names

phantomjs

安裝phantomjs

sudo mv phantomjs-2.1.1-linux-x86_64 /usr/local/share/
sudo chmod -R 777 /usr/local/share/phantomjs-2.1.1-linux-x86_64

sudo ln -sf /usr/local/share/phantomjs-2.1.1-linux-x86_64/bin/phantomjs /usr/local/share/phantomjs
sudo ln -sf /usr/local/share/phantomjs-2.1.1-linux-x86_64/bin/phantomjs /usr/local/bin/phantomjs
sudo ln -sf /usr/local/share/phantomjs-2.1.1-linux-x86_64/bin/phantomjs /usr/bin/phantomjs