Backing up a MySQL database - 7.3

Talend Migration and Upgrade Guide

Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend ESB
Talend Identity and Access Management
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Last publication date
2023-05-19

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.