Backing up a MySQL database - 7.1

Talend Big Data Migration Guide

EnrichVersion
7.1
EnrichProdName
Talend Big Data
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend Identity and Access Management
Talend JobServer
Talend Log Server
Talend Runtime
Talend Studio

Procedure

  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.