最近为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.cnblogs.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