As we all know, databases is one of the most important thing you need to backup before you want to upgrade, move to new server or before you want to do a task but do not really sure about the impact. I have written a article about the command line to MySql database - How to Backup and Restore . In this article, I will show you a little bash script backup MySql database at regular intervals and deleting backups which older than 15 days from current. This Bash script backup MySql will contain your database information so please make sure you set the right permissions, more over please don’t place the backup folder in public_html folder othervise other people will be able to see the content of your database. Implement Bash script backup MySql database #!/bin/bash # Database information user="db_username" password="your_db_password" host="your_host" db_name="your_db_name" The line at the top is the shebang and is used to select the interpr...
Infowebtutorial blog provide meaning full and useful information about all types of programming languages ,web design ,computer information and window operating system information