<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[dodomail的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/dodomail</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; dodomail]]></copyright><item><title><![CDATA[MySQL提示:The server quit without updating PID file问题的解决办法]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84920150</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84920150</guid><author>dodomail</author><pubDate>Mon, 07 May 2018 12:33:04 +0800</pubDate><description><![CDATA[转自[url] https://blog.youkuaiyun.com/u010098331/article/details/50752640[/url]]]></description><category></category></item><item><title><![CDATA[逗号分隔字符串行转列]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84909148</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84909148</guid><author>dodomail</author><pubDate>Tue, 19 Sep 2017 16:37:59 +0800</pubDate><description><![CDATA[sublime text2
2017-09-16 12:28:45,20,2947459977654079,pvestat,37,2,0,200,1661,overcustom,63,0,0,2
\n替换换行
[img]http://dl2.iteye.com/upload/attachment/0127/0472/dd05cc9c-f68d-3f1e-b01d-afdcac0ed48d.p...]]></description><category></category></item><item><title><![CDATA[卸载磁盘和挂载磁盘mount]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84904994</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84904994</guid><author>dodomail</author><pubDate>Tue, 25 Jul 2017 14:41:16 +0800</pubDate><description><![CDATA[umount /dev/sda2 /home
mount /dev/sda2 /data
vi /etc/fstab
reboot]]></description><category></category></item><item><title><![CDATA[shell 截取最后一列]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84903839</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84903839</guid><author>dodomail</author><pubDate>Tue, 11 Jul 2017 14:30:18 +0800</pubDate><description><![CDATA[cat yyb.txt | awk -F_ '{print pring substr($0,1,length-length($NF))}' 

echo '1,TENCENT_oaoHX0_f9cansGa2b0RXASLj9HwE_1'|awk -F ',' '{print substr($2,1,match($2,/_[0-9]+$/)-1)}']]></description><category></category></item><item><title><![CDATA[Jemalloc优化MySQL和Nginx ]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84884792</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84884792</guid><author>dodomail</author><pubDate>Tue, 09 May 2017 14:15:25 +0800</pubDate><description><![CDATA[原文地址：[url]https://my.oschina.net/lj2007331/blog/159573[/url]]]></description><category></category></item><item><title><![CDATA[正则匹配多数字在editplus]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84882689</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84882689</guid><author>dodomail</author><pubDate>Wed, 19 Apr 2017 11:26:37 +0800</pubDate><description><![CDATA[ENGINE=MyISAM AUTO_INCREMENT=[0-9]* DEFAULT CHARSET=utf8]]></description><category></category></item><item><title><![CDATA[mysql 备份database数据库结构]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84878652</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84878652</guid><author>dodomail</author><pubDate>Fri, 24 Mar 2017 10:47:03 +0800</pubDate><description><![CDATA[mysqldump -h127.0.0.1 -P3306 -uroot -proot --add-locks -q -d dbname &gt; /tmp/dbname.sql
mysqldump -h127.0.0.1 -P3306 -uroot -pr00t --add-locks -q -d dbname | sed 's/AUTO_INCREMENT=[0-9]*\s*//g' &gt; /tmp/...]]></description><category></category></item><item><title><![CDATA[maven 手动导入]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84856331</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84856331</guid><author>dodomail</author><pubDate>Wed, 15 Feb 2017 17:58:23 +0800</pubDate><description><![CDATA[[code=&quot;java&quot;]mvn install:install-file -Dfile=E:\tools\tokyotyrant-0.11.1.jar -DgroupId=tokyotyrant -DartifactId=tokyotyrant -Dversion=0.11.1 -Dpackaging=jar[/code]]]></description><category></category></item><item><title><![CDATA[mysqldump 实时导入老库到新库]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84855568</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84855568</guid><author>dodomail</author><pubDate>Fri, 10 Feb 2017 15:49:44 +0800</pubDate><description><![CDATA[mysqldump导全库
mysqldump --sock=/data/mysql/mysql.sock -uroot -pr00t --add-drop-table stat_base|mysql stat_base1 -uroot -pr00t
找到正确的套接字的路径： netstat -ln | grep mysql]]></description><category></category></item><item><title><![CDATA[mysql解决插入表情失败问题]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84830976</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84830976</guid><author>dodomail</author><pubDate>Wed, 14 Dec 2016 16:40:18 +0800</pubDate><description><![CDATA[mysql解决插入表情失败问题]]></description><category></category></item><item><title><![CDATA[CentOS（亚马逊EC2,亚马逊班）安装Nginx]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84815289</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84815289</guid><author>dodomail</author><pubDate>Wed, 31 Aug 2016 17:43:45 +0800</pubDate><description><![CDATA[此文是引用
[url]http://my.oschina.net/dingdayu/blog/667035[/url]]]></description><category></category></item><item><title><![CDATA[动态备份mysql慢查询日志]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84811472</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84811472</guid><author>dodomail</author><pubDate>Thu, 28 Jul 2016 11:22:38 +0800</pubDate><description><![CDATA[[code=&quot;sql&quot;]set global slow_query_log=0;[/code]
[quote]备份 改名[/quote]
[code=&quot;sql&quot;]set global slow_query_log=1;[/code]

[code=&quot;sql&quot;]show variables like '%slow%';[/code]]]></description><category></category></item><item><title><![CDATA[如何解决主从数据库同步延迟问题？]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84806486</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84806486</guid><author>dodomail</author><pubDate>Wed, 15 Jun 2016 16:57:50 +0800</pubDate><description><![CDATA[如何解决主库插入记录后，无法从从库中及时读取的问题,如何从架构上避免这种问题
在网上见过新建一个版本库的表，然后利用mysql proxy判断数据是否是最新的，然后路由到主库或者是从库，请问这个方案是可行的吗？具体如何操作？

作者：姜健
链接：https://www.zhihu.com/question/20025096/answer/82440882
来源：知乎
著作权归作者所有。...]]></description><category></category></item><item><title><![CDATA[忘记root密码找回方法]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84772459</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84772459</guid><author>dodomail</author><pubDate>Wed, 23 Mar 2016 13:43:02 +0800</pubDate><description><![CDATA[mysql教程 忘记root密码找回方法
php教程myadmin 那就可以进mysql啊,用进入phpmyadmin 的用户名和密码进入就可以了,
如果 phpmyadmin 能进入，那么就在 config.php 或 config.default.php 中查看就是了

记了 mysql 的 root 密码，可以用以下方法重新设置： 
1. kill掉系统里的mysql进程； 
2...]]></description><category></category></item><item><title><![CDATA[expect yum install 安装]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84768408</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84768408</guid><author>dodomail</author><pubDate>Fri, 04 Mar 2016 16:25:07 +0800</pubDate><description><![CDATA[expect yum install 安装]]></description><category></category></item><item><title><![CDATA[java转义字符串]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84732878</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84732878</guid><author>dodomail</author><pubDate>Wed, 15 Jul 2015 15:30:33 +0800</pubDate><description><![CDATA[点的转义：. ==&gt; u002E 
美元符号的转义：$ ==&gt; u0024 
乘方符号的转义：^ ==&gt; u005E 
左大括号的转义：{ ==&gt; u007B 
左方括号的转义：[ ==&gt; u005B 
左圆括号的转义：( ==&gt; u0028 
竖线的转义：| ==&gt; u007C 
右圆括号的转义：) ==&gt; u0029 
星号的转义：* ==&gt; u002A 
加号的转义：+ =...]]></description><category></category></item><item><title><![CDATA[更新系统时间]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84724528</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84724528</guid><author>dodomail</author><pubDate>Mon, 15 Jun 2015 19:10:23 +0800</pubDate><description><![CDATA[ntpdate ntpupdate.tencentyun.com 更新系统时间]]></description><category></category></item><item><title><![CDATA[mysql专门提供了操作用户的方法，而不是直接去对用户表增删改查]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84724143</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84724143</guid><author>dodomail</author><pubDate>Fri, 12 Jun 2015 15:32:39 +0800</pubDate><description><![CDATA[问题解决：mysql专门提供了操作用户的方法，而不是直接去对用户表增删改查，解决方法是 
drop user aa@localhost;(不要加引号) 
flush privileges; 
create user aa@localhost identified by 'password'; 
flush privileges; 
重建成功
不要用delete，而使用drop 靠谱...]]></description><category></category></item><item><title><![CDATA[何登成微博]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84713911</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84713911</guid><author>dodomail</author><pubDate>Wed, 22 Apr 2015 11:41:57 +0800</pubDate><description><![CDATA[http://hedengcheng.com/]]></description><category></category></item><item><title><![CDATA[ Hibernate 一对多关联的CRUD__@ManyToOne(cascade=(CascadeType.ALL))]]></title><link>https://blog.youkuaiyun.com/dodomail/article/details/84709526</link><guid>https://blog.youkuaiyun.com/dodomail/article/details/84709526</guid><author>dodomail</author><pubDate>Tue, 31 Mar 2015 16:56:40 +0800</pubDate><description><![CDATA[[url]http://blog.youkuaiyun.com/sivyer123/article/details/21787587[/url] Hibernate 一对多关联的CRUD__@ManyToOne(cascade=(CascadeType.ALL))]]></description><category></category></item></channel></rss>