2013 年 2月 17 日随笔档案 - zuoxingyu

有效的利用MYSQL命令行工具

摘要：原文链接：http://www.mysqlperformanceblog.com/2012/12/21/be-productive-with-the-mysql-command-line/Even if you are using a GUI tool to connect to your MySQL servers, one day or another, you will have to deal with the command line. So it is nice to know a few tips that can really make your work easier.即使你阅读全文

posted @ 2013-02-17 18:03 zuoxingyu 阅读(629) 评论(0) 推荐(0)

MySQL pager 命令有趣的用法

摘要：原文链接：http://www.mysqlperformanceblog.com/2013/01/21/fun-with-the-mysql-pager-command/Last time I wrote about a few tips that can make you more efficient when using the command line on Unix. Today I want to focus more on pager.The most common usage of pager is to set it to a Unix pager such as less. 阅读全文

posted @ 2013-02-17 17:16 zuoxingyu 阅读(1500) 评论(1) 推荐(1)

mysqldump处理触发器的异常错误

摘要：原文链接：http://www.mysqlperformanceblog.com/2013/02/11/unexpected-problem-with-triggers-and-mysqldump/Some time ago, I had to convert all tables of a database from MyISAM to InnoDB on a new server. The plan was to take a logical dump on the master, exporting separately the schema and the data, then edi 阅读全文

posted @ 2013-02-17 15:55 zuoxingyu 阅读(1094) 评论(0) 推荐(0)

天堂