I have a large (~5GB) .sql file I am attempting to restore via SSH, it seems to quit in the middle of the restore process.
When I come back hours later after issuing the command (the file has 7 tables), there are only 5 tables and nothing is being processed.
Is there a log file I can view to see why it quit half-way through? Is there a configuration option I am probably missing? Any ideas would be greatly appreciated. Thanks!
The command I am using:
mysql -u username -p database_name < file.sql