Debuging import of a large dump file to MySQL
There are two possibilities for this issue.


Wait timeout
Low resource on the server where you are trying to restore the DB.


Increase the lock_wait_timeout and wait_timeout to 300 seconds.
Try to restore the Database where you have enough resource to export the file(generally if you are using a t2.nano or t2.micro instances(where you are executing the restore command and keep the Backup file), then it'll kill the restore query due to low resource)