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 ?