MySQL遠端連線 遠端mysqldump

要在my.cnf 中將他開啟
#vi /etc/mysql/my.cnf
找到下面兩行將他註解掉
skip-networking
bind-address=127.0.0.1

重開MySQL
#/etc/init.d/mysql restart

再來使用者也必須設定為可以遠端的權限
用 root 登入 mysql
mysql>GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.1' IDENTIFIED BY 'password';
mysql>flush privileges;

遠端mysqldump
#mysqldump -uuser -h 192.168.1.200 -p test > test.sql

ubuntu ssh keygen

username@ubuntu:~$ ssh-keygen -t dsa
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/username/.ssh/id_dsa
Your public key has been saved in /home/username/.ssh/id_dsa.pub

username@ubuntu:~$ cd .ssh/
This moves you into .ssh directory where the keys were saved. Now to copy the public key to the server.
username@ubuntu:~$ scp id_dsa.pub id@serverIP:./id_dsa.pub

Logging server
username@server:~$ cd .ssh
serverusername@server:~$ touch authorized_keys2
serverusername@server:~$ chmod 600 authorized_keys2
serverusername@server:~$ cat ../id_dsa.pub >> authorized_keys2
serverusername@server:~$ rm ../id_dsa.pub

apache 開啟rewrite url功能

使用 Apache web server 的ReWrite 設定，
可將原本是『http://ecmall.lefthander.tw/index.php?app=goods&id=198』的url
變成『http://ecmall.lefthander.tw/goods/198』
這樣的好處是url變短了，看起來很像靜態的html
對SEO來講有很大的幫助

但是在開始寫ReWrite rule之前必須先開啟apache rewrite的module
以ubuntu為例：
只要下一個指令就好了
a2enmode rewrite

之後在apache中再寫入正規表示語法
可以參考這邊我就不多寫了
http://rental.zhupiter.com/postshow_178_1_1.html