|
Contents
Index
<< Previous
Next >>
PDF
Transfer
|
|
Menu: Extras / Transfer
MySQL-Front transfers (copy) whole databases / tables to different server / database.
If you want to transfer a table you have to select the table in the left side. After this you have to select the destination database on the right.
To transfer a database please select it on the left - and select the destination session on the right.
It's also possible to transfer several tables at once by selecting the tables with Ctrl-Left-Click with the mouse.
Structure:
| The data structure (objects) will be transferred.
|
Data:
| The data will be transferred.
|
Existing Data:
| Allows to update existing records. (Requires identical primary key definition for Source and Destination).
|
Disable Keys:
| Foreign key will be disabled while transfer. This could be needed to allow circular foreign keys.
|
Lock Tables:
| Tables will be locked while transfer is running. No other application can change a value in this time.
|
Error Handling:
| If the Error Handling will be ignored the data will be transfered by the LOAD DATA INFILE statement. This is the smallest SQL overhead - all data will be transfered with one single (bug big) database request.
|
| This does not allow a individual error handling.
|
See also:
|
|
