shdj111的专栏

步骤： 1.找到起作用的配置文件（my.cnf, my.ini） [mysqld] datadir=/home/data/mysql socket=/home/data/mysql/mysql.sock [mysql] socket=/home/data/mysql/mysql.sock 2.拷贝数据库文件到/home/data cp /var/lib/mysq

LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]     INTO TABLE tbl_name     [FIELDS         [TERMINATED BY '\t']         [OPTIONALLY] ENCLOSED BY '']         [ESCAPED B

This section also covers the related Lost connection to server during query error. The most common reason for the MySQL server has gone away error is that the server timed out and closed the connec

There are three likely causes for this error message. Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs frequently. If the err