Backing up a MySQL database - 7.2

Talend Data Management Platform Migration and Upgrade Guide

EnrichVersion
7.2
EnrichProdName
Talend Data Management Platform
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend Identity and Access Management
Talend JobServer
Talend Log Server
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio
task
Installation and Upgrade

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.