PhpMyAdmin import large database files

After LNMP is set up, use PhpMyAdmin to import the database file, prompting that the file content is too large. Create the upload and save directories under phpmyadmin.

After LNMP is set up, use PhpMyAdmin to import the database file, prompting that the file content is too large. Create the upload and save directories under phpmyadmin.

After LNMP is set up, use PhpMyAdmin to import the database file, prompting that the file content is too large.

Modified

Upload_max_filesize = 30 M

Post_max_size = 40 M

Still useless. You can solve the problem as follows:

Modify the config. inc. php file under phpmyadmin

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

Modify:

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

Create the upload and save directories under phpmyadmin, upload the database files to the upload directory on the server through ftp on the client, and then log in through phpmyadmin. When importing the database ,, you will see an option to upload a local database file.

At this time, the import will be successful!