How can I increase the mysql capacity in phpmyadmin? This error is displayed when you import a table to mysql.
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 41 bytes) in C: \ Program Files (x86) \ EasyPHP-12.1 \ modules \ phpmyadmin3522x121010173154 \ libraries \ sqlparser. lib. php on line 62
How can we expand it? Thank you.
Reply to discussion (solution)
Execute
Execute
How to implement it? I just installed easyphp...
Import the SQL statements in the file into the database from D: \ MySQL \ mydb2. SQL:
1. enter MySQL from the command line, and then run the create database mydb2 command to CREATE the DATABASE mydb2.
2. to exit MySQL, enter the command exit or quit;
3. enter the following command in CMD:
C: \> MySQL-h localhost-u root-p mydb2 <D: \ MySQL \ mydb2. SQL
It is relatively simple to modify the file upload limit size.
Memory_limit = 128 M, upload_max_filesize = 2 M, post_max_size = 8 M
Modify upload _
2 MB by default to what you need
Run the following command line:
Use db;
Source/data/tt. SQL; // note that the tt. SQL path must be correct.
This is how it was changed.