3.5.2.5. MySQL ダンプファイルを作成する

MYSQL_POD_NAME=$(oc get pods -l deployment=system-mysql -o jsonpath='{.items[0].metadata.name}')

oc exec $MYSQL_POD_NAME -n $THREESCALE_NAMESPACE -- mysqldump -u root --single-transaction --routines --triggers --skip-extended-insert system > system-mysql-dump-temp.sql

head -n 10 system-mysql-dump-temp.sql
-- MySQL dump 10.13  Distrib 8.0, for Linux (x86_64)
--
-- Host: localhost    Database:
-- ------------------------------------------------------
-- Server version   8.0

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

sed 's/DEFINER=`root`@`%`//g' system-mysql-dump-temp.sql > system-mysql-dump.sql