Solution to the problem when phpmyadmin imports large database files

When using phpmyadmin to import an 8M database, the import cannot be successful and the following error occurs:

When using phpmyadmin to import an 8M database, the import cannot be successful and the following error occurs:

Solution: When you need to import a database file that is too large, you need to configure the three default values ​​of upload_max_filesize, memory_limit and post_max_size in php.ini to be larger than the size of the file you import. Then after restarting apache, you can import normally.

If that still doesn’t work, it is recommended to use a third-party management tool to import. For example, the following two software are both good: Solution to the problem when phpmyadmin imports large database files management tool-Mysql GUI Tools V5.0 Green Chinese version Solution to the problem when phpmyadmin imports large database files management tool-Navicat for MySQL V9.0.15 Green Chinese version.