원격 mysqldump

1 개요[ | ]

원격 mysqldump

mysqldump -h서버주소 -P포트 --all-databases -uroot -p > 덤프파일명.sql

2 실행예시[ | ]

root@zetawiki:~# mysql -h135.79.246.80 -uroot -p
Enter password: P@ssw0rd
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 99353
Server version: 10.1.26-MariaDB-1~xenial mariadb.org binary distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> exit
Bye

root@zetawiki:~# mysqldump --all-databases -h135.79.246.80 -uroot -p > dump.sql
Enter password: P@ssw0rd

root@zetawiki:~# ll -h dump.sql 
-rw-r--r-- 1 root root 1.3G Dec  3 20:37 dump.sql

3 같이 보기[ | ]

4 참고[ | ]

https://stackoverflow.com/questions/2989724/how-to-mysqldump-remote-db-from-local-machine