I was in the process of restoring an sql dump to a newly created RDS mysql instance on AWS.
The dump was created with the following command:
mysqldump --all-databases \ --single-transaction \ --compress \ --order-by-primary > dump.sql
During the restore process I lost connection to the RDS instance.
Can I simply restart the restore process of the dump by re-initiating the restore process?
Or, asking more generally:
What excactly happens when restoring an sql dump? Will already created tables simply be overwritten? Will the database delete old entries and copy over the new database state?