Bash-MySQL-Database-SFTP-FTP-Backup icon indicating copy to clipboard operation
Bash-MySQL-Database-SFTP-FTP-Backup copied to clipboard

A small script to upload backup of MySQL database to an external FTP server

[Bash]MySQL Database FTP Backup

A small script to upload backup tar to an external FTP server

How it works:

  • You need to change "user,password,host,db_name" with information of mysql database
  • You need to change "USERNAME,PASSWORD,SERVER" with information of your server

If you have some problem open an issues on GitHub

##FAQ;

  • Q: How can I make backups automatic?

    A: You can use crontab (on linux) link

  • Q: Why can't I start the script?

    A: Make the file executable (chmod +x script.sh)

  • Q: Will this work on all linux distros?

    A: This script was tested on Ubuntu 12/14,Debian and Centos 6 and has worked whitout any problems

  • Q: Why SFTP don't work?

    A: You need to install "sshpass" ( apt-get install sshpass )