Database Import Error: How to Fix 'File Size Too Large' in phpMyAdmin?

Troubleshooting Large Database Import with phpMyAdmin

Encountering an error message indicating that the database file size is too large during phpMyAdmin import? Here's a comprehensive guide to resolve this issue:

Step 1: Check PHP Configuration

• Locate the php.ini file in the Apache bin directory (e.g., C:wampbinapacheApache2.4.4bin)

• Update the following lines:

  • max_execution_time = 259200
  • max_input_time = 259200
  • memory_limit = 1000M
  • upload_max_filesize = 750M
  • post_max_size = 750M
• Restart your WAMP server.

Step 2: Modify phpMyAdmin Configuration (if necessary)

• If increasing PHP settings did not resolve the issue, open the config.default.php file in the phpMyAdmin library directory (e.g., c:wampappsphpmyadmin4.0.4libraries)

• Locate and modify the following line:

  • $cfg['ExecTimeLimit'] = 300;** to **$cfg['ExecTimeLimit'] = 0;

Alternative Option: Using MySQL Console

• Click on the WampServer icon > MySQL > MySQL Consol
• Enter your database password (e.g., root)
• Select the database name using USE DATABASENAME
• Load the SQL source file using SOURCE C:FOLDERdatabase.sql

Note: Ensure that the database file is not compressed (e.g., .zip, .gz). If it is, extract it before loading.

The above is the detailed content of Database Import Error: How to Fix 'File Size Too Large' in phpMyAdmin?. For more information, please follow other related articles on the PHP Chinese website!