PhpMyAdmin supports importing zip Databases

To enable phpMyAdmin to support ZIP files, first install the zip extension in your php.
Open the phpMyAdmin configuration file config. Inc. php and add the followingCode:

$ Cfg ['zipdump'] = true

Restart the Apache server.

As the data volume of our PHP project increases, we need to regularly back up the database periodically, which usually involves MySQL import and export. However, you may note that, by default, when you use phpMyAdmin to manage MySQL, MySQL can only import 2 MB of data by default, which cannot meet the needs of importing a large amount of data. It doesn't matter. In this section, we will introduce how to solve the limit of 2 MB of data imported from MySQL.

PhpMyAdmin import large database file size limit configuration...

1. Modify the values of the following three items in the PHP. ini file:
Upload_max_filesize: the size of the uploaded file.
Memory_limit
Maximum value of data submitted by post_max_size
Modify the size value you want to change.

2. modify or add this setting to the phpMyAdmin configuration file:
This file is generally the config. Inc. php file under the phpMyAdmin directory.
$ Cfg ['exectimelimmit '] = 0; // maximum execution time in seconds (0 for no limit)
The default value is 300 seconds. If it is changed to 0, it indicates no restriction.