If you have the server management permission, it is better. We directly set upload_max_filesize, memory_limit, and post_max_size under php. ini.
For example, my configuration
Upload_max_filesize = 1200 M
Memory_limit = 2048 M
Post_max_size = 1200 M
Restart apache or iis.
If you do not have the server management permission, we have another solution.
PhpMyAdmin-3.1.0-all-languages for example, my installation directory E:/wwwroot/phpMyAdmin/
1. Create a directory named upload In The phpmyadmin directory.
2. open phpmyadmin and find E:/wwwroot/phpMyAdmin/config. sample. inc. php file, find and modify it to $ cfg ['uploaddir'] = "upload", and then click save.
Open the E:/wwwroot/phpMyAdmin/libraries/config. default. Php file, find and modify it to $ cfg ['uploaddir'] = "upload", and click save.
3. Use FTP to upload the SQL file to phpmyadmin/upload/.
4. Access phpmyadmin and click Import. The Select Server File drop-down box is displayed. Select the SQL file uploaded over FTP. This is a perfect solution.