Shulou(Shulou.com)06/01 Report--

Editor to share with you navicat import sql error solution, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Scenario: more than 100m sql files are imported into the local database to report errors, local environment, phpstudy, error one: 1294-Invalid ON UPDATE clause for 'create_time' column, error two: 2006-MySQL server has gone away.

Reason for error 1: mysql version of phpstyudy is too low, default is 5.5

Solution: upgrade the mysql version

1. Back up the current database data, you can export the database file as a backup.

2. Back up the MySQL folder under PhpStudy in case the upgrade fails, and you can use the old version of the database.

3. Download MySQL5.6, extract it, and put it in the MySQL folder under PhpStudy.

4. Make a copy of my-default.ini, rename it to my.ini, open my.ini and add:

Basedir= "E:/phpStudy/MySQL/" datadir= "E:/phpStudy/MySQL/data/"

For these two items, both addresses are changed to the mysql directory and database directory in their corresponding phpstudy.

5. Then run cmd as an administrator and enter the MySQL directory, which indicates success as shown in the figure, and executes as follows:

The second cause of error: exceeding the maximum packet allowed by mysql

Solution:

Add to my.ini (parameters according to your own needs)

Max_allowed_packet=500M

Wait_timeout=288000

Interactive_timeout = 288000

The above is all the contents of this article entitled "the solution to the error report of navicat Import sql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.