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

This article introduces you how to import sql file in phpMyAdmin, the content is very detailed, interested friends can refer to, hope to be helpful to you.

First:

Modify PHP.ini

The switch on whether file_uploads on allows files to be uploaded through HTTP. Default is ON, that is, on.

Upload_tmp_dir files are uploaded to the server where temporary files are stored. If not specified, the system default temporary folder will be used.

Upload_max_filesize 20m lookout business, that is, the maximum file size allowed to be uploaded. The default is 2m

Post_max_size 30m refers to the maximum value that can be received to PHP through the form POST, including all the values in the form. The default is 8m

Be sure to restart the computer or restart php after modification

Second, find the directory of phpMyAdmin, find the config.inc.php file in the root directory, and then find $cfg ['UploadDir']. You can see through the Directories for saving/loading files from server that this is the method used to import the SQL file on the server. The opposite is $cfg ['SaveDir'], which, as the name implies, saves the exported SQL file in a directory on the server.

Modify this parameter

$cfg ['UploadDir'] =' ImportSQLFile'

$cfg ['SaveDir'] =' ExportSQLFile'

Then set up two folders in phpMyAdmin, ImportSQLFile and ExportSQLFile, one for big data's import and one for data export backup.

On how to import sql files in phpMyAdmin to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it 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.