Solve a series of problems that occur when phpmyadmin is imported into a large database, and phpmyadmin is a series

Solve a series of problems that occur when phpmyadmin is imported into a large database, and phpmyadmin is a series

When you use phpmyadmin to import mysql database files, if the file size exceeds 2 MB, a prompt is displayed, indicating that the import is unsuccessful. In this case, open phpmyadmin -- "libraries --" config. default. php, which contains

$ Cfg ['uploaddir'] = ''; write the folder name, such as importSQL, and create a new folder importSQL under the phpmyadmin directory to put the mysql database in, in this way, we will prompt

Upload folders from the website ServerImportSQL/Select: select the file to be imported.

This problem may occur during the import process. Got a packet bigger than 'max _ allowed_packet 'bytes. When the MySQL client or mysqld server receives an information package larger than max_allowed_packet, the "Information Package is too large" error is sent and the connection is closed. For some clients, if the communication information package is too large, a "lost connection to MySQL Server" error may occur during query. We found my. cfg under/etc/, which is the mysql configuration file. Of course, my. ini is under win, which is a little different. We changed all max_allowed_packet in to 50 M.

At last, restart the mysql server to run the Command service mysqld restart. restart and re-import. The problem is solved.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.