phpmysqlimportphpmyadminini

Script timeout passed, if you want to finish import, please resubmit the same file and import will resume

I have a database Un-zipped size 50mb zipped size 7mb So when I try to import the database zipped(7mb) after few minutes it is throwing this error:

Script timeout passed, if you want to finish import, please resubmit the same file and import will resume.

I have resubmitted it but still not importing total data.

I am working in local and these are my php.ini configurations:

max_execution_time = 3000000 
max_input_time = 60000000000000
memory_limit = 1280000000000000000000M
post_max_size = 4096456M
upload_max_filesize = 40964564M
max_file_uploads = 200

how can I let the system to take its own time for import.?

Solution

  • If you are importing your database using Phpmyadmin, then there's a configuration file for it. The default/example config file is found here:

    \phpmyadmin\libraries\config.default.php

    Don't edit this file as it may get overwritten in future updates. Instead look for an existing file here:

    \phpmyadmin\config.inc.php

    ...and if it does not exist, create it.

    Open this configuration file in any editor and change $cfg['ExecTimeLimit'] = 300; to $cfg['ExecTimeLimit'] = 0;

    (or if it does not exist, add it)

    Restart your localhost, now you don't have any time limit.

    Or you can use MySQL command line to import your unzipped SQL file directly, something like below:

    mysql -u username -p database_name < my_unzipped_import_file.sql