Back up a MySQL database to the other database - Automatic Backup Scheduler for MySQL
Task Wizard
Automatic Backup Scheduler for MySQL > Help Document > Task Wizard > Back up a MySQL database to the other database

Back up a MySQL database to the other database


Automatically back up a remote or local MySQL database to the other MySQL database with a powerful task scheduler. The destination database may be an existent database or a database to be created.


Create a task
Double click the item or select the item and then click Create Task button to create a new task.
Create a task

Welcome Page: Welcome to the Task Wizard! Please click Next to continue, or Cancel to exit.
Welcome Page

Step 1 - Task Name: Enter the name and the comment of the task. Please do not enter an existent task name even if the original task had already been moved to the category Deleted Tasks. Please view the existent task in the category "All Avtive Tasks" or "Deleted Tasks".
Step 1

Step 2 - Source MySQL Server and Database: Enter the information of the source MySQL server and database. The software will back up the database from the source MySQL server to the destination MySQL database. How to set up the options of Source MySQL Server and Database?
Step 2

Step 3 - Select Source Items: Select source items of MySQL ( Tables, Views, Triggers, Stored Procedures, Functions and Events ) which you want to backp, set up the Advanced Settings. How to set up the options of the Source Items?
Step 3

Step 4 - Destination MySQL Server and Database: Enter the information of the destination MySQL server and database. The software will back up the items from the source MySQL database to the destination MySQL database. How to set up the options of Destination MySQL Server and Database?
Step 4

Step 5 - Execute SQL Script: Enter the SQL script for running. The software can execute SQL statements before and after backing up. How to set up the options for Executing the SQL Script?
Step 5

Step 6 - Task Scheduler: Choose the scheduler for running the task. The task will run on schedule with professional Task Scheduler ( Minutely, Daily, Weekly, Monthly, and with the Begin date and End date ). How to set up the options of Task Scheduler?
Step 6

Step 7 - Task Information: View the task information. Click Finish to create a task, or click Back if you want to review or change any settings.
Step 7

After clicking Finish, a new Back up a MySQL database to the other database task will be created. It will automatically appears in the Task List.
Back up a MySQL database to the other database



See also:
  1. Task - Back up MySQL databases to the SQL files
  2. Task - Back up MySQL databases to the other server
  3. Task - Restore MySQL databases from the backup files
  4. Task - Restore MySQL databases from the other server
  5. Task - Restore a MySQL database from the other database
  6. Task - Execute SQL Script
  7. Page - MySQL Server
  8. Page - Source Server and Database
  9. Page - Destination Server and Database
  10. Page - Select Databases
  11. Page - Select Source Items
  12. Page - Add Backup Files
  13. Page - Recovery Databases
  14. Page - Backup Files
  15. Page - Upload Backup Files
  16. Page - Execute SQL script before starting and after ending
  17. Page - Enter SQL Script
  18. Page - Task Scheduler
  19. Options - MySQL Database Advanced Settings
  20. Options - Backup File Settings
  21. Options - Compression Options
  22. Options - Back up Tablespaces
  23. Options - SMTP Options
  24. Protocol - SSL Protocol
  25. Protocol - SSH Tunneling
Copyright © 2017 Database Think Software. All rights reserved.