Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to import a large sql script into mysql. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

1. First import the sql file: source data.sql

two。 Changed the max_allowed_packet of mysql's my.ini

Mysql > use databasename

Database changed

Mysql > source c:mysql.sql

If the .sql file is too large, mysql disconnects directly

Solution:

Add a line max_allowed_packet = 100m (this size > = mysql.sql file size) to the configuration file my.ini of mysql

3. There is also a problem that is "BLOB/TEXT column source used in key specification without a key length"

By solving the

This is the end of this article on "how to import a big sql script from mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.