MySQL: ignore errors when importing?
mysql -u root -p -f -D connection < dump.sql https://stackoverflow.com/questions/11263018/mysql-ignore-errors-when-importing

SET FOREIGN_KEY_CHECKS = ON;
PhpMyAdmin Import Error-MySQL server has gone away

https://stackoverflow.com/questions/33698579/phpmyadmin-import-error-mysql-server-has-gone-away-unrecognized-keyword

Change to:

post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

In my.ini (MySQL File – Under mysqld)

Find:

max_allowed_packet = 1M
Change to:

max_allowed_packet = 500M

########################

Fatal error: Maximum execution time of 300 seconds exceeded

https://stackoverflow.com/questions/7680572/fatal-error-maximum-execution-time-of-300-seconds-exceeded

…\phpmyadmin3.4.10.1\libraries (change path according to your installation)

open config.default.php and change value for $cfg[‘ExecTimeLimit’] to 0:

if not found add:
$cfg[‘ExecTimeLimit’] = 0;