Solution: Need to backup remote database using mysqldump

Development | Databases
Author
Description
Please help me.. Need to backup remote database using mysqldump? 
Attachments
No attachments.
Solutions
Unfortunately, you cant continue your failed backup. When mysqldump returns a failed status you have to start over again. My first recommendation is to compress your script before transmitting it: mysqldump -h 192.168.10.209 -u user -ppassword testdb | gzip > dump.sql.gz
on July 02nd, 2018 (5:44 pm)
What masters said
You must sign in to comment!!
All comments
This solution has not been commented yet.