mysql data migration

? shell로 접근하려면 10060port사용해야 하는지?

Can't connect to MySQL server on 'rds-an2-richcdp-qa2-mysql.cjbyfjmv7vdu.ap-northeast-2.rds.amazonaws.com' (10060) when trying to connect

---

EXPORT

$mysqldump -uroot -p wordpess > dump160724.sql

(workbench통해 실행할 때 명령어) mysqldump.exe --defaults-file="c:\users\user\appdata\local\temp\tmpr46kpq.cnf" --user=cdp_mgr --host=rds-an2-richcdp-qa2-mysql.cjbyfjmv7vdu.ap-northeast-2.rds.amazonaws.com --protocol=tcp --port=3310 --default-character-set=utf8 --skip-triggers --skip-column-statistics "richcdp_kic_qa2" "tb_rc_user"

 

IMPORT

$mysqladmin -uroot -p create wordpress

$mysql -uroot -p wordpress < dump160724.sql