Solution to the problem that XAMPP client environment cannot import large databases

Lao Zuo usually uses the PHPSTUDY software client in the local WEB environment, but the XAMPP client is used in the general MAC environment. I have used the XAMPP client on the MAC before. I always feel that it is not as easy to use as the domestic software, so I do not use it. Today, some netizens encountered a problem with XAMPP importing the database. It is estimated that the default database size is too small to import.

Here, we generally modify php.ini directly to set the size of the import database. If the database is too large to import, you can import the original database file, or use the MySQL command on the server.

File found:

/xampp/php/php.ini

We found the client installation file php. ini.

upload_ max_ filesize = 2M
memory_ limit = 128M
post_ max_ size = 8M

Find the three default file parameters, and then set them to a larger size. Finally, we can restart XAMPP. If not, we need to find another solution.