Backing up a MySQL database - 7.0

Talend Data Fabric Migration and Upgrade Guide

Talend Data Fabric
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio
Installation and Upgrade


  1. Execute the following dump command:
    • On Windows: mysqldump -u tisadmin -ptisadmin talend_administrator > c:/<DB_Backuppath>/DumpTalendAdministrator.sql
    • On Linux: mysqldump -u tisadmin -ptisadmin talend_administrator > /home/<DB_Backuppath>/DumpTalendAdministrator.sql
  2. On Linux, if you want to load this back-up file to the talend_administrator database in case of error, use the following command:
    mysql -u tisadmin -ptisadmin talend_administrator</home/<DB_Backuppath>/DumpTalendAdministrator.sql

What to do next

Once the backup is complete, unpause all the tasks in Talend Administration Center.