How to import and export phpadmin big data file and php.ini parameter modification

  • 2020-05-30 19:30:29
  • OfStack

Recently, I encountered the problem of importing with phpadmin when the database is too large. The import limit of the new version of phpadmin is 8M, while the import limit of the old version may be 2M. How many megabytes does my database have?

First of all, if you have a standalone server or vps, you can find php.ini under Apache to modify the 8M or 2M restrictions. How do you modify this?

Search found, modify these 3
upload_max_filesize = 2M 
post_max_size = 8M 
memory_limit = 128M 

After the modification, restart the service, enter phpadmin to have a look, it should be ok!

Related articles: