您好,欢迎访问三七文档
当前位置:首页 > 机械/制造/汽车 > 综合/其它 > CentOS系统维护手册
1CentOS维护手册※启动系统Web服务:#ulimit-SHn65535#php-fpmstart#nginx#/etc/init.d/mysqldstart其它相关指令:php-fpm{start|stop|quit|restart|reload|logrotate}nginx-s{reload|start|stop}※系统Web服务配置:[Nginx]Nginx的配置目录/usr/local/nginx/conf[Nginx]Nginx的Host表/usr/local/nginx/vhosts[PHP]PHP的配置文件/usr/local/php/etc/php.ini※系统使用说明:[CentOS]删除当前目录下所有文件ls|xargs-irm-rf{}[MySQL]清除mysql-bin.0000X日志文件#mysql-uroot–pmysqlresetmaster;[CentOS]查看文件夹下子目录的大小#du-h/[CentOS]解决MySQL启动时报[2002]错#ln–s/tmp/mysql.sock/var/lib/mysql/mysql.sock2[MySQL]更改MySQL数据库用户密码mysqlUPDATEmysql.userSETpassword=PASSWORD('HynewS_mYSqL_@)!1')WHEREuser='root';mysqlFLUSHPRIVILEGES;[MySQL]启动MySQL服务/etc/init.d/mysqldstart[MySQL]远程访问MySQL很慢的解决办法my.ini里面添加代码[mysqld]skip-name-resolveskip-grant-tables[CentOS]自定义开机启动程序编辑/etc/rc.d/目录下rc.local文件在最后加上ulimit-SHn51200/etc/init.d/mysqldstart[MySQL]导入导出MySQL数据库一、导出:用mysqldump命令行命令格式mysqldump-u用户名-p数据库名数据库名.sql范例:mysqldump-uroot-pabcabc.sql(导出数据库abc到abc.sql文件)提示输入密码时,输入数据库用户名的密码。二、导入:用mysql命令行命令格式mysql-u用户名-p数据库名数据库名.sql范例:mysql-uroot-pabcabc.sql(导入数据库abc,从abc.sql文件)提示输入密码时,输入该数据库用户名的密码。三、直接COPY如果数据库比较大,可以考虑用直接拷贝的方法,但不同版本和操作系统之间可能不兼容,要慎用。3①将原始数据库用tar打包为一个文件tar-zcvfmydb.tar.gzmydb②创建空数据库③解压在临时目录中解压,如:cd/tmptar-zxvfmydb.tar.gz④拷贝将解压后的数据库文件拷贝到相关目录cdmydb/cp*/var/lib/mysql/mydb/⑤权限设置将拷贝过去的文件的属主改为mysql:mysql,权限改为660chownmysql:mysql/var/lib/mysql/mydb/*chmod660/var/lib/mysql/mydb/*※编译Nginx环境过程中容易遇到的错误及解决:错误:Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'解决:#ln–s/tmp/mysql.sock/var/lib/mysql/mysql.sock错误:configure:error:XMLconfigurationcouldnotbefound解决:#yum-yinstalllibxml2libxml2-devel错误:configure:error:Pleasereinstallthelibcurldistribution-easy.hshouldbeincurl-dir/include/curl/解决:#yum-yinstallcurl-devel错误:configure:error:libjpeg.(a|so)notfound.解决:#yum-yinstalllibjpeg-devel错误:configure:error:libpng.(a|so)notfound.解决:#yum-yinstalllibpng-devel错误:configure:error:freetype.hnotfound.解决:#yuminstallfreetype-devel错误:configure:error:Cannotfindldap.h解决:#yuminstallopenldap-devel4错误:errorwhileloadingsharedlibraries:libiconv.so.2:cannotopensharedobjectfile:Nosuchfileordirectory解决:在/etc/ld.so.conf中加一行/usr/local/lib,然后运行/sbin/ldconfig※在Nginx中配置虚拟目录:Nginx配置文件的支持:[nginx.conf]user{useepoll;worker_connections65535;}http{includemime.types;default_typeapplication/octet-stream;charsetutf8;server_names_hash_bucket_size128;client_header_buffer_size32k;large_client_header_buffers432k;client_max_body_size50m;sendfileon;tcp_nopushon;keepalive_timeout60;tcp_nodelayon;fastcgi_connect_timeout300;fastcgi_send_timeout300;fastcgi_read_timeout300;5fastcgi_buffer_size64k;fastcgi_buffers464k;fastcgi_busy_buffers_size128k;fastcgi_temp_file_write_size256k;gzipon;gzip_min_length1k;gzip_buffers416k;gzip_http_version1.0;gzip_comp_level2;gzip_typestext/plainapplication/x-javascripttext/cssapplication/xml;gzip_varyon;ssion;ssi_silent_errorsoff;ssi_typestext/shtml;#limit_zonecrawler$binary_remote_addr10m;server{listen80;server_name192.168.16.32;indexindex.shtmlindex.phpindex.htmlindex.htm;root/~.*\.(php|php5)?${fastcgi_pass127.0.0.1:9000;fastcgi_indexindex.php;includefastcgi.conf;}location/status{stub_statuson;access_logoff;}location~.*\.(gif|jpg|jpeg|png|bmp|swf)${expires30d;}6location~.*\.(js|css)?${expires7d;}access_logoff;}includevhosts/*.conf;}例:配置news.hynews.net虚拟主机在目录/usr/local/nginx/conf下创建vhosts文件夹在vhosts下创建文件news.conf,内容为:server{listen80;server_namenews.hynews.net;indexindex.shtmlindex.phpindex.html;root/~.*\.(php|php5)?${fastcgi_pass127.0.0.1:9000;fastcgi_indexindex.php;includefastcgi.conf;}location~.*\.(gif|jpg|jpeg|png|bmp|swf)${expires30d;}location~.*\.(js|css)?${expires7d;}access_logoff;}7例:配置news.hynews.net/section虚拟目录在/usr/local/nginx/conf/vhosts目录下的二级域名配置文件中加入location/section{alias/}
本文标题:CentOS系统维护手册
链接地址:https://www.777doc.com/doc-1888837 .html