How to solve the problem when phpmyadmin imports large database files

How to solve the problem when phpmyadmin imports large database files

When you use phpmyadmin to import an 8 m database, the import fails. the following error occurs: When you use phpmyadmin to import an 8 m database, the import fails. the following error occurs: Solution: To import a large database file, set upload_max_filesize, memory_limit, and post_max_size in php. ini to a value greater than the size of the imported file. After restarting apache, the data can be imported normally. If not, we recommend that you use a third-party management tool for import. for example, the following two software types are good: mysql management tool-Mysql GUI Tools V5.0 green Chinese version mysql management tool-Navicat for MySQL V9.0.15 green Chinese version.