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.
We use cookies to give you the best possible experience on our site. By continuing to use the site you agree to our use of cookies. Find out more Accept