按格式将表导出到文件<br />mysql -e "SELECT * FROM qwifi.q_report_project_daily WHERE daytime='2015-09-17' INTO OUTFILE '/tmp/targetfile.csv' fields terminated by \",\" optionally enclosed by '\'';"【阅读全文】
1.alter table it can take a lot of time.MySQL will perform a row-by-row copy of your old table into a new table. During that time, you’ll probably be using all of the server’s di...【阅读全文】
<p>问题说明:通过mysql命令连接mysql数据库的时候报了ERROR 1129的错误;</p><p>错误说明:ERROR 1129 (HY000): Host 'mysql02' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'</p><p>错误原因:同一个ip在短时间内产生太多中断的数据库连接而导致的阻塞(超过mysql数据...【阅读全文】
一台不是自己安装的mysql数据库,后来接手 想登陆下查看些信息,遇到如下问题<br />ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/data/mysql/mysqld.sock' (2)<br />遇到此问题后我的一些分析过程,记录了下和大家分析下。<br />1.首先查看下路径/data/mysql/里面有没有mysqld.sock这个文...【阅读全文】