Navicat for MySQL allows you to transfer tables/views/stored procedures/events from one MySQL database to another MySQL database, or to a plain text file. The target database can be on the same server as the source database or on another MySQL server. It also allows you to save a profile for easy retrieval and running of data transfer between databases. You can also invoke data transfer from the command line, which makes it possible to schedule data transfer between databases.

Just sample open the data transfer and use the toolbar below, allowing you to create, save and delete the data transfer.

Create Data Transfer

To create a new data transfer

• Select Tools -> Data Transfer from the main menu or just select New from the toolbar above.
• Edit data transfer properties on the appropriate tabs.

To create a new data transfer with modification as one of the existing data transfers

• Select Tools -> Data Transfer from the main menu
• Select the data transfer for modifying from the drop-down list.
• Modify data transfer properties on the appropriate tabs.
• Click Save As.

Hint: To create new data transfer you can also right-click the Database node of the navigation pane and select the Data Transfer from the popup menu.

Edit Data Transfer

To edit the existing data transfer

• Select Tools -> Data Transfer from the main menu.
• Select the data transfer for modifying from the drop-down list.
• Modify data transfer properties on the appropriate tabs.

Run Data Transfer

To run a data transfer

• Create a new data transfer/open the existing one.
• Click Start.

To run a saved data transfer profile from the command line (set schedule)

• Create and save the data transfer profile.
• Start Navicat from command line - Navicat /dump DataTransferProfileName
  
  

  Note:

  DataTransferProfileName -> name of the saved data transfer profile

Delete Data Transfer

To delete a data transfer

• Select Tools -> Data Transfer from the main menu.
• Select the data transfer for droping from the drop-down list.
• Click the Delete from the toolbar.
• Confirm deleting in the dialog window.