How Do I Fix the File Size Limit Issue When Importing Databases in PhpMyAdmin?

File Size Limit Issue in PhpMyAdmin Database Import

Importing databases via PhpMyAdmin can sometimes encounter an error message indicating that the file size exceeds the allowable limit. To address this issue, here are the steps to take:

1. Increase PHP Configuration

Edit the php.ini file located at C:wampbinapacheApache2.4.4bin and modify the following values:

max_execution_time = 259200
max_input_time = 259200
memory_limit = 1000M
upload_max_filesize = 750M
post_max_size = 750M

2. Modify PhpMyAdmin Configuration

Open the config.default.php file at c:wampappsphpmyadmin4.0.4libraries. Locate the line $cfg['ExecTimeLimit'] = 300; and replace it with $cfg['ExecTimeLimit'] = 0;.

3. Use MySQL Console

If the previous methods fail, you can import the database using the MySQL Console:

• Launch WampServer -> MySQL -> MySQL Console.
• Enter your database password at the prompt.
• Select the database to import the data into using the command: USE DATABASENAME;
• Load the SQL file using the command: SOURCE C:FOLDERdatabase.sql;

Note: Ensure that the database file is not compressed (e.g., .sql.zip or .sql.gz) as the console may not recognize it.

The above is the detailed content of How Do I Fix the File Size Limit Issue When Importing Databases in PhpMyAdmin?. For more information, please follow other related articles on the PHP Chinese website!