I have a database named A. I want to export it, and import it to a new database B.

I exported the A, no issues. While trying to import to the new database B, I faced the following error:

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

I am using shared hosting environment in GoDaddy. I contacted them. They told me that they were able to export and import successfully, and the problem can be related to my internet connection.

On other sites, they are suggesting to modify the below section in config.

$cfg['ExecTimeLimit'] = 300

I don't think I can fix by changing since it is a shared hosting environment plus also I believe the file I am trying to import is not that much big to receive a timeout. So I am not really sure if this is the root cause really.

I also tried to use "copy database" under operations tab in phpmyadmin. This is also not working. Resubmitting the file also didn't work. What do you suggest ?

  • 1
    Can you SSH into GoDaddy's server and run the import and export on the command line? – Stephen Ostermiller Apr 2 '18 at 13:21
  • 1
    Importing data using phpmyadmin is limited regardless of what you do. You can only import so much. The suggestion to shell in is one suggestion that should certainly work. Another is to install MySQL Workbench found here and try that. mysql.com/products/workbench Either way, you will need to get into the nuts and bolts of MySQL for self preservation instead of relying upon phpmyadmin. It is a good app for a quick thing here and there, but not recommended over Workbench. – closetnoc Apr 2 '18 at 15:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.