Navicat's Data Transfer feature allows you to transfer tables, records, stored procedures, views and from one MySQL database to another MySQL database or a plain text file. The target database can be on the same server as the source database or on another MySQL server. Navicat allows you to save a profile for easy retrieval and running of Data Transfer between databases.

1. On the Tool Menu, click Data Transfer
   
2. Go to the General tab, enter the source server and target server settings
   
3. Go to the Advanced Setting tab and enter the settings
   
4. Click the Save button to save your settings
   
   

Deleting a Data Transfer profile

1. On the Tool Menu, click Data Transfer
   
2. Select the profile you want to delete from the Load Profile
   
3. Click Delete Button

Setting up the General Setting

1. Select Source Connection.
   
2. Select Source Database and then the tables.
   
3. To Transfer to another MySQL database, check Transfer directly to server. Select the Target Connection and Database.
   
4. To Transfer to plain text file, check Transfer to file. Select the file in the edit box.

Setting up the Advanced Setting

1. In the Table Options, select whether to create tables in the target database.
   
2. Select whether a table must be dropped before it is created
   
3. In the Record Options, select whether to create the records in the target database
   
4. Indicate whether Navicat must use delayed insert statements when posting the records to the target database
   
5. Select Extended Insert Statements if you want Navicat to use the extended insert statement syntax
   
6. Indicate whether to lock the target tables before inserting new records