How to import big data using phpMyAdmin

Data Import and Export (ExportImport) is often used when PhpMyAdmin is used. However, when importing big data, due to the restrictions of php file upload and script response time

Data Import and Export (Export/Import) are often used when PhpMyAdmin is used. However, when importing big data, due to the restrictions of php file upload and script response time

Data Import and Export (Export/Import) are often used when phpMyAdmin is used. However, when importing big data, the php file upload and script response time are limited, as a result, phpMyAdmin cannot import big data. For importing big data to mysql, I used SHELL to import hundreds of megabytes of files to the mySQL database ), however, the vast majority of domestic virtual hosts do not have the same SHELL permission as DreamHost, and most of them are Windows Server servers. We do not have the permission to modify the php. ini file. In this case, we can use the $ cfg ['uploaddir'] method provided by phpMyAdmin to import the. SQL file on the server.

First, find the phpMyAdmin directory and find the config under the root directory. inc. PHP file, and then find $ cfg ['uploaddir']. Through annotations (Directories for saving/loading files from server), we can see that this is the method used to import SQL files on the server. The opposite is $ cfg ['savedir']. As the name suggests, the exported SQL file is saved in the directory on the server.

Modify this parameter

$ Cfg ['uploaddir'] = 'importsqlfile ';
$ Cfg ['savedir'] = 'exportsqlfile ';

Create two folders in phpMyAdmin, ImportSQLFile and ExportSQLFile, one for big data import and the other for data export backup.

Copy the SQL file to be imported to ImportSQLFile, upload it to the server, select the database name to be imported, and select Import ), you will find that an SQL File (web server upload directory) imported to the server is added to the File import (File to import)

This method breaks through the restrictions on php. ini file uploading. I have not tried the limit. The 10 M. SQL file I uploaded was successfully imported to mysql.

Similarly, mysql data can be exported/backed up directly on the server and saved to the folder specified in $ cfg ['savedir'] = 'exportsqlfile ';

Reprinted Description: phpMyAdmin is undoubtedly a good MYSQL management end program. Many users who need to import large databases may wish to try this method, which is simple and practical.