server mysqldump from remote db to my local server.
2023.05.04 06:52
참고 문서 |
---|
#!/bin/bash # Replace these variables with your own database credentials REMOTE_USER="remote_user" REMOTE_PASSWORD="remote_password" REMOTE_HOST="remote_host" REMOTE_DATABASE="remote_database" LOCAL_USER="local_user" LOCAL_PASSWORD="local_password" LOCAL_DATABASE="local_database" FILENAME="dump_$(date +%Y%m%d%H%M%S).tar.gz" # Use mysqldump to dump the remote database to a file ssh $REMOTE_USER@$REMOTE_HOST "mysqldump -u$REMOTE_USER -p'$REMOTE_PASSWORD' $REMOTE_DATABASE" | gzip > $FILENAME # Copy the compressed dump file to the local machine scp $FILENAME $LOCAL_USER@$LOCAL_HOST:/path/to/save # Import the dump file to the local database gunzip < $FILENAME | mysql -u$LOCAL_USER -p$LOCAL_PASSWORD $LOCAL_DATABASE # Remove the dump file from the local machine rm $FILENAME
In this script, you need to replace the variables REMOTE_USER
, REMOTE_PASSWORD
, REMOTE_HOST
, REMOTE_DATABASE
, LOCAL_USER
, LOCAL_PASSWORD
, and LOCAL_DATABASE
with your own database credentials. The FILENAME
variable specifies the name of the compressed dump file, which includes the current date and time to avoid overwriting existing files.
To run the script, save it to a file, make it executable using chmod +x script_name.sh
, and then run it using ./script_name.sh
.
This script connects to the remote host using ssh
, runs the mysqldump
command to dump the remote database to a file, compresses the dump file using gzip
, copies the compressed file to the local machine using scp
, imports the dump file to the local database using the mysql
command after uncompressing it using gunzip
, and finally removes the dump file from the local machine.
댓글 0
번호 | 제목 | 날짜 | 조회 수 |
---|---|---|---|
21 | munin 설치 | 2018.10.13 | 787 |
20 | mysql 백업 (shell script) | 2018.10.14 | 697 |
19 | 웹 백업 (쉘 스크립트) | 2018.10.14 | 1194 |
18 | yum install php-apcu | 2019.03.12 | 1542 |
17 | yum install latest redis | 2019.03.27 | 1682 |
16 | certbot apache multiple domain | 2019.04.10 | 1416 |
15 | my.cnf | 2019.04.11 | 1 |
14 | xe 에디터 컴포넌트 트리거 제거 | 2019.05.16 | 9846 |
13 | vmware with centos 7 | 2019.08.23 | 0 |
12 | netdata 이용한 centos 모니터링 | 2020.01.25 | 2349 |
11 | php-fpm tcp to socket | 2020.01.25 | 0 |
10 | net::ERR_CONNECTION_REFUSED | 2021.10.11 | 0 |
9 | The best configuration of php7.4-fpm / 1.5GB | 2023.05.04 | 23 |
8 | The best configuration of php7.4-fpm / 8GB | 2023.05.04 | 23 |
7 | To download large files with rsync command. | 2023.05.04 | 21 |
» | mysqldump from remote db to my local server. | 2023.05.04 | 421 |
5 | apache2 AllowOverride config | 2023.05.23 | 279 |
4 | gearman 은 무엇인가? | 2023.06.21 | 271 |
3 | mysql DELETE 쿼리 사용할 때 실제로 rows 삭제가 발생했는지 알 수 있는가? | 2023.06.21 | 2080 |
2 | php 에서 비동기 처리하는 방법 | 2023.06.22 | 289 |