homehome previousprevious nextnext
 
Setting Advanced Restore Properties

Server Options

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');

Object Options

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.



 

 

 

 

 

 

 

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.