Use Transaction
Rollbacks all data when error occurs.
Continue on errors
Ignores errors that are encountered during the restore process.
Lock tables for write
Lock the tables to prevent user to modify tables during the restore process.
Use entended insert statements
Inserts records using extended insert syntax.
Example:
INSERT INTO `users` VALUES ('1', 'Peter McKindsy', '23'), ('2', 'Johnson
Ryne', '56'), ('0', 'Katherine', '23');
Create tables
Creates tables during the restore process with this option is on.
Create records
Restore records during the restore process with this option is on, otherwise,
only table structures will be restored.
Create triggers
Creates triggers for the restored table with this option is on.
Overwrite existing tables
Overwrites if tables already exist in the database.
Overwrite existing views
Overwrites if views already exist in the database.
Overwrite existing procedures
Overwrites if stored procedures already exist in the database.
Overwrite events
Overwrites if events already exist in the database.