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
번호 | 제목 | 날짜 | 조회 수 |
---|---|---|---|
81 | MySQL 설치 | 2010.05.11 | 17280 |
80 | Apache 설치 | 2010.05.11 | 16667 |
79 | PHP 설치 | 2010.05.11 | 15057 |
78 | Zend Optimizer + eAccelerator + Suhosin | 2010.05.11 | 18249 |
77 | Lighttpd 설치 | 2010.05.11 | 20679 |
76 | sAPM | 2010.05.12 | 20264 |
75 | VPS (가상 호스팅) 비교 | 2010.05.12 | 62201 |
74 | 검색엔진 등록 | 2010.05.12 | 142341 |
73 | html 파일에서 php 구문 숨기기 | 2010.05.17 | 6861 |
72 | php 현재 시각 출력하기 | 2010.05.17 | 4460 |
71 | php 암호화와 복호와 | 2010.05.17 | 7315 |
70 | 파일 불러오기 | 2010.05.17 | 5475 |
69 | php 에서 텍스트 파일을 생성, 수정하기 | 2010.05.19 | 9928 |
68 | php 쿠키 생성, 읽기 | 2010.05.19 | 7105 |
67 | jQuery 쿠키 | 2010.05.19 | 5021 |
66 | list-style | 2010.05.21 | 5155 |
65 | php 에서 파일 권한 설정 | 2010.05.21 | 4594 |
64 | putty | 2010.05.21 | 13465 |
63 | 리눅스 자동 시작 | 2010.05.21 | 15895 |
62 | 포커스 요소의 테두리와 웹 접근성 | 2010.05.23 | 4182 |