Thursday, January 31, 2019

MySQL Database Backup to FTP Server – Shell Script

No comments
Hi Dear Friends,

In this post We would like to share infinity knowladge My Good experience and Best solution For .

Laravel Examples

As a system administrator, you need to take backup on daily basis. Backups are very useful to recover data from any crashes or corruption. I have written a simple script to take database backup from MySQL server and upload to FTP server. Being a system administrator, I recommend keeping a remote copy of your every backup. You can also try our new advance script for MySQL databases backup and upload to remote locations.
Create a shell script file and copy the below script. Then update all the required values and execute.
Setup Details – Edit the above script for the following variable as per your system environment. Place all the values correctly to make script working properly.
  • LOCAL_BACKUP_DIR => Local direction path to store backup
  • DB_NAME => database name
  • DB_USER => database adminitrator user name
  • DB_PASSWORD => database administrator password
  • FTP_SERVER => ftp server ip for hostname
  • FTP_USERNAME => ftp username
  • FTP_PASSWORD => ftp password
  • FTP_UPLOAD_DIR => ftp server backup path
  • LOG_FILE => log file name and location
I hope this script will help you for taking database backup over FTP server.
Try this it will help you and for more information click here: Laravel Examples.

Read :

I hope you like this Post, Please feel free to comment below, your Any Idea, suggestion and problems if you face - I am here to Resolve your Any problems.
We hope it can help you...

No comments :

Post a Comment