Internal server error while importing sql file?

Question

I am importing an SQL file and it shows me an error like this

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator at [email protected] to inform them of the time this error occurred, and the actions you performed just before this error. More information about this error may be available in the server error log.

I have already make changes in php.ini file, which are listed below

MAX_UPLAOD_SIZE = 20M
MAX_EXECUTION_TIME = 600
POST_MAX_SIZE = 20M

How to resolve this?

Solution

1. Check your /var/log/apache2/error.log (or what server do you use?) It contains a full error description.

2. Import big SQL files via ssh/mysql client:

   mysql -u username -p dbname < /path/to/sql/file.sql