Solve phpMyAdmin upload large mysql file

Method One, set php.ini:

Vi./php.inifile_uploads onupload_max_filesize = 150mpost_max_size = 200m# If you have a larger SQL file, you need to set it up: Max_execution_time 30 0 #每个PHP页面运行的最大时间值 (seconds), default 30 seconds Max_input_time #每个PHP页面接收数据所需的最大时间, default 60 seconds Memory_limit 128m #每个PHP页 Maximum memory required by the polygon, default 8M

Method Two, set phpmyadmin/config.inc.php:

If there is no config.inc.php, copy config.sample.inc.php to config.inc.php

$cfg [' uploaddir '] = ' upload '; $cfg [' savedir '] = ' save ';

1. Create upload and save subdirectories in the phpMyAdmin directory

2. Transfer the SQL file you want to import into the upload directory and refresh the phpMyAdmin, for example, select Execute:

。。。。。。。。。。。。。。。。。。。。。。。。。。

Solve phpMyAdmin upload large mysql file