Mysql Backup and Restore (Dump and Import)
Dump
Dump from remote machine
Dump using different port (3306 is default)
Dump From AWS RDS
MySQL
mysqldump --hex-blob --skip-extended-insert --triggers --routines --events -h prod-clone.xxxxxxxxxxx.eu-west-1.rds.amazonaws.com schema_name > /opt/dump/schema-$(date +%F).sql
Dump Tables Only
Import
First create database and then import *.sql dump
Import to remote machine
-u user | (db user)
-p password | (ask for password)
-h host | (FQDN or IP)
--port=12345 or -P 12345 | change port
Import Tables
Dump Tables Only
Import from AWS RDS
- Remove definer first
- Then simple import