mysqldump Export·Import

Export → Import

mysqldump \
  --host=${SOURCE_DB_HOST} \
  --user=${SOURCE_DB_USER} --password \
  --default-character-set=utf8mb4 --set-charset \
  --compact --extended-insert --quick --hex-blob \
  --single-transaction \
  --events --routines --triggers \
  --databases ${SOURCE_DB_NAME} > dump.sql

mysql \
  --host=${TARGET_DB_HOST} \
  --user=${TARGET_DB_USER} --password \
  ${TARGET_DB_NAME} < dump.sql

SSH 경유

ssh -i key user@host "mysqldump --user=... --password --databases dbname" > dump.sql
ssh -i key user@host "mysql --host=... --user=... --password dbname" < dump.sql

클라이언트: brew install mysql-client / apt install mysql-client