PhpMyAdmin cannot import databases more than 2 MB

　　PhpMyAdmin is a tool for online MySQL database management. When you use phpMyAdmin to import database files larger than 2 MB, it is often unable to import because of the size limit of the File Uploaded by PHP. ini.

If you have rented a VM and do not have the highest management permission on the server, you cannot modify the PHP. ini file. What should you do if you cannot use the command line? In fact, read the phpMyAdmin online help document, which has long explained the solution to this problem.

Create a new directory under the phpMyAdmin directory, such as jonson, and then edit librariesconfig under the phpMyAdmin directory. default. in the PHP file, find $ cfg ['uploaddir'] and write the value to the name of the new directory, as shown below:

Program code

$ Cfg ['uploaddir'] = 'jonson'; // Directory for uploaded files that can be executed

// PhpMyAdmin. For example './upload'. Leave empty

// No upload directory support. Use % u for username

// Regression Sion.

$ Cfg ['savedir'] = ''; // Directory where phpMyAdmin can save exported data on

// Server. For example './save'. Leave empty for no save

// Directory support. Use % u for username authentication Sion.

$ Cfg ['docsqldir'] = ''; // Directory for docSQL imports, phpMyAdmin can import

// DocSQL files from that directory. For example

// './Docsql'. Leave empty for no docSQL import support.

$ Cfg ['tempdir'] = ''; // Directory where phpMyAdmin can save temporary files.

// This is needed for MS Excel export, see documentation

// How to enable that.

Upload the file to be imported to the database to the newly created jonson folder, log on to phpMyAdmin, select your database, and click "import" in the window on the right )", in this case, you will find a "website Server Upload directory" option added to the import interface. Click the drop-down arrow to display the file name list you just uploaded.

Select a file and click the "execute" button in the lower-right corner. Wait for a period of time (the waiting time is proportional to the volume of the imported file) to complete the import of the "Overweight" file.