When trying to upload database in phpMyAdmin more then 500Mb getting the error..
Script timeout passed, if you want to finish import, please resubmit same file and import will resume.
The error occurs because of a huge file and the restoration process fails with timeout.
To increase timeout restoration increase the ExecTimeLimit value in
$cfg['ExecTimeLimit'] = 3600;
Also increase the settings in
/etc/sw-cp-server/config to avoid '504 Gateway Time-out nginx' error:
fastcgi_read_timeout 3600; fastcgi_send_timeout 3600;
You can use Command Prompt in Windows or Linux SSH:
mysql -u USERNAME -p******** DATABASENAME < mysql_backup.sql
You may split the sql file:
Download a program that will split up your SQL file, such as SQL Dump Splitter. This is a free SQL dump file splitter that will let you automatically cut and save your split SQL file.