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.?
Advertisement
Answer
If you are importing your database using Phpmyadmin, then there’s a configuration file for it:
phpmyadminlibrariesconfig.default.php
Open this configuration file in any editor and change $cfg['ExecTimeLimit'] = 300;
to $cfg['ExecTimeLimit'] = 0;
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