LAMP学习笔记

xlid

　　最近为LM开发开放API，LM的环境是基于LAMP搭建。
　　正好在开发过程中熟悉一下。笔记比较碎，姑且作为一个归档查询。
　　

• mysql 启动|停止|重启|的正确方法：
  
  
  /etc/init.d/mysql   start|stop|restart|reload|force-reload
  　　
  
  
• mysql 备份命令：
  
  
  mysqldump -uroot -ppsw database | gzip > bk.gz
  　　
  
  
• mysql 从备份恢复：
  
  
  gunzip < bk.gz | mysql -uroot -ppsw dbname
  　　http://www.iyunv.com/ylqmf/archive/2012/02/23/2365410.html
  
  
• mysql 目录空间不足的解决方法：
  
  
  先停止mysql:
  /etc/init.d/mysqld stop
  移动数据:
  mv /var/lib/mysql/* /home/mysql/
  创建软连接:
  ln -s /home/mysql/ /var/lib/mysql/
  或者mount操作：
  mount -B /home/mysql/ /var/lib/mysql/
  启动mysql:
  /etc/init.d/mysqld start
  　　
  
  
• BIT的一个校内源，速度很快，10MB基本能跑满：
  
  
  #
  # deb cdrom:[Ubuntu-Server 12.04 LTS _Precise Pangolin_ - Release amd64 (20120424.1)]/ dists/precise/main/binary-i386/
  # deb cdrom:[Ubuntu-Server 12.04 LTS _Precise Pangolin_ - Release amd64 (20120424.1)]/ dists/precise/restricted/binary-i386/
  # deb cdrom:[Ubuntu-Server 12.04 LTS _Precise Pangolin_ - Release amd64 (20120424.1)]/ precise main restricted
  #deb cdrom:[Ubuntu-Server 12.04 LTS _Precise Pangolin_ - Release amd64 (20120424.1)]/ dists/precise/main/binary-i386/
  #deb cdrom:[Ubuntu-Server 12.04 LTS _Precise Pangolin_ - Release amd64 (20120424.1)]/ dists/precise/restricted/binary-i386/
  #deb cdrom:[Ubuntu-Server 12.04 LTS _Precise Pangolin_ - Release amd64 (20120424.1)]/ precise main restricted
  # See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
  # newer versions of the distribution.
  deb http://mirror.bit.edu.cn/ubuntu/ precise main restricted
  deb-src http://mirror.bit.edu.cn/ubuntu/ precise main restricted
  
  ## Major bug fix updates produced after the final release of the
  ## distribution.
  deb http://mirror.bit.edu.cn/ubuntu/ precise-updates main restricted
  deb-src http://mirror.bit.edu.cn/ubuntu/ precise-updates main restricted
  
  ## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
  ## team. Also, please note that software in universe WILL NOT receive any
  ## review or updates from the Ubuntu security team.
  deb http://mirror.bit.edu.cn/ubuntu/ precise universe
  deb-src http://mirror.bit.edu.cn/ubuntu/ precise universe
  deb http://mirror.bit.edu.cn/ubuntu/ precise-updates universe
  deb-src http://mirror.bit.edu.cn/ubuntu/ precise-updates universe
  
  ## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
  ## team, and may not be under a free licence. Please satisfy yourself as to
  ## your rights to use the software. Also, please note that software in
  ## multiverse WILL NOT receive any review or updates from the Ubuntu
  ## security team.
  deb http://mirror.bit.edu.cn/ubuntu/ precise multiverse
  deb-src http://mirror.bit.edu.cn/ubuntu/ precise multiverse
  deb http://mirror.bit.edu.cn/ubuntu/ precise-updates multiverse
  deb-src http://mirror.bit.edu.cn/ubuntu/ precise-updates multiverse
  
  ## N.B. software from this repository may not have been tested as
  ## extensively as that contained in the main release, although it includes
  ## newer versions of some applications which may provide useful features.
  ## Also, please note that software in backports WILL NOT receive any review
  ## or updates from the Ubuntu security team.
  deb http://mirror.bit.edu.cn/ubuntu/ precise-backports main restricted universe multiverse
  deb-src http://mirror.bit.edu.cn/ubuntu/ precise-backports main restricted universe multiverse
  
  deb http://mirror.bit.edu.cn/ubuntu precise-security main restricted
  deb-src http://mirror.bit.edu.cn/ubuntu precise-security main restricted
  deb http://mirror.bit.edu.cn/ubuntu precise-security universe
  deb-src http://mirror.bit.edu.cn/ubuntu precise-security universe
  deb http://mirror.bit.edu.cn/ubuntu precise-security multiverse
  deb-src http://mirror.bit.edu.cn/ubuntu precise-security multiverse
  
  ## Uncomment the following two lines to add software from Canonical's
  ## 'partner' repository.
  ## This software is not part of Ubuntu, but is offered by Canonical and the
  ## respective vendors as a service to Ubuntu users.
  # deb http://archive.canonical.com/ubuntu precise partner
  # deb-src http://archive.canonical.com/ubuntu precise partner
  
  ## Uncomment the following two lines to add software from Ubuntu's
  ## 'extras' repository.
  ## This software is not part of Ubuntu, but is offered by third-party
  ## developers who want to ship their latest software.
  # deb http://extras.ubuntu.com/ubuntu precise main
  # deb-src http://extras.ubuntu.com/ubuntu precise main
  　　
  
  
• Zend Debugger 下载地址 http://www.zendstudio.net/archives/new-zend-debugger-packages-released/（PHP 5.3必须用这个）。根据其中的readme文件配置。使用php -m可以查看加载信息。
  
• 禁止显示网站文件夹目录列表：在该目录下新建一个.htaccess文件，然后填写
  
  
  Options All -Indexes
  　　
  
  
• 8
  
• 9
  
• 10
  
• 11