![个人头像照片](https://ucc.alicdn.com/avatar/img_baaef13e0a0106c84a966a495ff8d6a8.jpg)
白及
<div class="entry_title"><a target="_blank" href="http://www.osyunwei.com/archives/4199.html">CentOS 6.2编译安装Nginx1.2.0+MySQL5.5.25+PHP5.3.13+博客系统WordPress3.3.2</a></div> <div class="entry_title">
<p><br></p> <p><span style="font-size:14px; color:#3366ff">SQL:基础查阅手册</span></p> <p><a target="_blank" href="http://www.w3school.com.cn/sql/sql_syntax.asp">http://www.w3school.com.cn/sql/sql_syn
<p><br></p> <p><span style="color:rgb(51,51,51); font-family:Arial; font-size:14px; line-height:26px"><span style="font-size:24px"><a target="_blank" href="http://blog.csdn.net/jesseyoung/article
<br><br> 一什么是增量备份<br> 增量备份,就是将新增加的数据进行备份。假如你一个数据库,有10G的数据,每天会增加10M的数据,数据库每天都要备份一次,这么多数据是不是都要备份呢?还是只要备份增加的数据呢,很显然,我只要备份增加的数据。这样减少服务器的负担。<br><br><br> 二,启用binlog<br> vi my.cnf<br> log-bin=/var/l
<p><br></p> <p> </p> <table cellspacing="0" cellpadding="0" style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; font-size:12px; font-family:微软雅黑,宋体; table-layout:fixed; widt
<p><span style="color:#ff0000"><strong>mysql 5.1.65 、 5.1.73 mysqlbinlog日志:</strong></span><br></p> <p><br></p> <p><span style="color:#3333ff"># at 368</span><br> #160318 23:58:44 server id 1
<p><br></p> <p>执行:</p> <p>[root@t1 ~]# mysql -uroot -pjsb ailanni < /root/ailanni.sql<br> Warning: Using a password on the command line interface can be insecure.<br><span style="color:#333
<p><br></p> <p>查看命令</p> <p><span style="color:#3333ff">date</span></p> <p><br></p> <p>centos设置当前系统时间命令</p> <p>[root@t1 data]# <span style="color:#3333ff">date --set "03/19/16 11:30"</span><br
<p>测试环境:</p> <p>mysql 5.6.25 (适用5.1.73 5.1.65)</p> <p><br></p> <p>1</p> <p>vim /etc/my.cnf</p> <p>pid-file=/mypid/t1.pid</p> <p><br></p> <p><br></p> <p>今天在备份的时候,我测试把mysql-log.index删除之后报错如下
<p><br></p> <p><br></p> <p></p> <div id="article_content" class="article_content" style="margin:35px 0px; font-size:15px; color:rgb(85,85,85); line-height:35px; font-family:'microsoft yahei'">
<p></p> <p style="margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; color:rgb(85,85,85); font-family:'microsoft yahei'; font-size:15px; line-height:35px"> <span style="font
<p></p> <p style="margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; color:rgb(85,85,85); font-family:'microsoft yahei'; font-size:15px; line-height:35px"> <span style="font
<p><br></p> <p></p> <p style="margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; font-family:Arial; font-size:14px; line-height:26px"> <strong>2 安装cmake软件包</strong><br> yu
<p><br></p> <p>mysql启动成功</p> <p>service mysqld start </p> <p>mysql is OK</p> <p><br></p> <p>mysql登录错误 :</p> <p>[root@localhost ~]# mysql -uroot -p123456<br><span style="color:#ff0000">ERROR
<div style="padding:0px; margin:0px; color:rgb(85,85,85); font-family:宋体,'Arial Narrow',arial,serif; font-size:14px; line-height:28px"> centos下加入mysql环境变量<br> </div> <div style="padding:0px; mar
<p></p> <pre id="recommend-content-1440309168" class="recommend-text mb-10" style="margin-top:0px; margin-bottom:10px; padding:0px; font-family:arial,'courier new',courier,宋体,monospace,'Microsoft
<div id="post_detail" style="margin:0px; padding:0px; font-family:'Helvetica Neue',Helvetica,Arial,sans-serif; font-size:13px; line-height:18px"> <div id="topics" style="margin:0px; padding:0px 0
<h1 class="postTitle" style="margin:0px; padding:0px; font-size:14px; float:right; line-height:1.5; width:1490px; clear:both; color:rgb(68,68,68); font-family:'Helvetica Neue',Helvetica,Arial,sans
<p><br></p> <p></p> <div class="line number29 index28 alt2" style="line-height:13.1875px; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace; white-space:nowrap; col
<p><br></p> <p></p> <p style="margin:10px auto; font-family:Verdana,Arial,Helvetica,sans-serif; font-size:14px; line-height:25px"> 先看问题:</p> <p style="margin:10px auto; font-family:Verdana,Ari
<p></p> <p style="padding-top:0px; padding-bottom:0px; margin-top:0px; margin-bottom:0px; clear:both; height:auto; overflow:hidden; color:rgb(85,85,85); font-family:宋体,'Arial Narrow',arial,serif;
<p><br></p> <p></p> <p style="margin-top:1em; margin-bottom:1em; padding-top:0px; padding-bottom:0px; font-family:raleway,tahoma,arial,sans-serif; font-size:13px; background-color:rgb(230,230,23
<p><br></p> <p>前台开启:</p> <p><span style="color:#3366ff">[root@t1 x]# <strong>service mysqld start</strong></span></p> <p>Starting MySQL. ERROR! The server quit without updating PID file (/mydat
<div class="Blog_tit4 Blog_tit5" style="word-wrap:break-word; border-bottom-width:0px; padding:0px 0px 11px"> <a target="_blank" href="http://blog.chinaunix.net/uid-25266990-id-3293445.html" styl
<p></p> <h2 class="post-title" style="margin:0px; padding:0px; font-size:24px; border-bottom-width:2px; border-bottom-style:solid; border-bottom-color:rgb(204,204,204); line-height:2rem; font-fam
<p style="font-family:'Microsoft Yahei',Tahoma,Verdana,Arial; margin-top:0px; margin-bottom:0px; padding-top:0.5em; padding-bottom:0.5em; color:rgb(51,51,51); line-height:18px"> <span style="marg
<div class="Blog_tit4 Blog_tit5" style="word-wrap:break-word; border-bottom-width:0px; padding:0px 0px 11px; color:rgb(86,86,86); font-family:宋体,Arial; line-height:12px"> <span class="Blog_b1" st
<p><span style="white-space:pre"><span style="font-size:18px"></span></span><span style="font-size:18px">环境:</span></p> <p><span style="font-size:18px"><span style="white-space:pre"></span>centos
<div id="laiyuan" style="margin-left:20px; color:rgb(90,135,135); border-left-width:4px; border-left-style:solid; border-left-color:rgb(88,133,133); padding-left:12px; font-family:Verdana,Arial,He
<p>环境:</p> <p>centos 6.5 </p> <p>mysql 5.5.20 升级 5.6.25 报错:</p> <p><br></p> <p>mysql升级报错:</p> <p><br></p> <p>mysql.time_zone_transition_type OK<br> mysql.user
<p>mysql 5.6.25下载衔接:</p> <p><br></p> <p>oracle官方:</p> <p>https://dev.mysql.com/downloads/mysql/5.6.html<br></p> <p><br></p> <p>CSDN:</p> <p>http://download.csdn.net/detail/jiaoxiaogu/8903091
<p></p> <div class="summary" style="background-color:rgb(246,250,253); border:1px solid rgb(220,221,221); font-size:14px; line-height:23px; margin:15px 0px 0px; padding:12px 5px 6px; text-align:j
<p></p> <p><br></p> <div style="margin:0px; padding:0px"> <span style="font-family:punctuation,微软雅黑,Tohoma; font-size:14px; line-height:19px; white-space:pre"></span><span style="font-size:18px;
<p></p> <div style="font-family:'lucida Grande',Verdana,'Microsoft YaHei'; font-size:14px; line-height:23px"> ERROR OGG-<span style="border-bottom-width:1px; border-bottom-style:dashed; border
<div style="font-family:'lucida Grande',Verdana,'Microsoft YaHei'; font-size:14px; line-height:23px"> gg开启之后</div> <div style="font-family:'lucida Grande',Verdana,'Microsoft YaHei'; font-size:14
<p align="center" style="line-height:20px; font-family:'lucida Grande',Verdana,'Microsoft YaHei'; font-size:9pt; background-color:rgb(223,223,223); word-wrap:break-word; margin-top:0px; margin-bot
<div style="top:0px"> <div id="content" class="bigfont mycontent" style="zoom:1; line-height:23px; font-size:14px; margin:18px 28px; font-family:'lucida Grande',Verdana,'Microsoft YaHei'; clear:b
<div style="color:rgb(0,61,91); font-family:Simsun; font-size:12px"> <span id="pt1:sd_r1:0:dv_rDoc:ot71" style="color:black"></span> <p style="line-height:22px"><strong>In this Document</strong><
<p><span style="font-size:14px"><br></span></p> <p></p> <p style="line-height:18px; margin-top:0px; margin-bottom:10px; padding-top:4px; padding-bottom:6px; word-spacing:1px; font-family:Optima,
<div style="color:rgb(85,85,85)"><span style="color:#4169e1"><strong><span style="color:blue"><br></span></strong></span></div> <div style="color:rgb(85,85,85)"> <span style="color:#4169e1"><stro
<p></p> <div id="content" class="bigfont mycontent" style="zoom:1; line-height:23px; font-size:14px; margin:18px 28px; font-family:'lucida Grande',Verdana,'Microsoft YaHei'; clear:both; min-heigh
<p><span style="font-size:14px; color:#cc33cc"><br></span></p> <p></p> <pre><span style="font-size:14px; color:#cc33cc"> 1)<a target="_blank" href="http://tomszrp.itpub.net/post/11835/493005"
<div id="paperTitleArea" align="center" class="lp_title_type_3" style="margin:0px 0px 35px 72px; padding:0px; height:70px; width:690px"> <span id="paperTitle" style="margin:0px; padding:25px 0px
<div id="paperTitleArea" align="center" class="lp_title_type_3" style="margin:0px 0px 35px 72px; padding:0px; height:70px; width:690px"> <span id="paperTitle" style="margin:0px; padding:25px 0px
<table cellspacing="0" cellpadding="0" id="blogContentTable" style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; color:rgb(68,68,68); font-family:punctuation,微软雅黑,Tohoma;
<table cellspacing="0" cellpadding="0" id="blogContentTable" style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; color:rgb(68,68,68); font-family:punctuation,微软雅黑,Tohoma;
<p><br></p> <p> </p> <table cellspacing="0" cellpadding="0" id="blogContentTable" style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; color:rgb(68,68,68); font-family:p
<table cellspacing="0" cellpadding="0" id="blogContentTable" style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; color:rgb(68,68,68); font-family:punctuation,微软雅黑,Tohoma;
<table cellspacing="0" cellpadding="0" id="blogContentTable" style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; color:rgb(68,68,68); font-family:punctuation,微软雅黑,Tohoma;
<p><br></p> <p><br></p> <p> </p> <table cellspacing="0" cellpadding="0" id="blogContentTable" style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; color:rgb(68,68,68);