Conntrack Backup Script


#/bin/bash

Database credentials
user=”conntrack”
password=”conn123″
host=”localhost”
db_name=”conntrack”

Other Options
backup_path=”/home/conntrack”
date=$(date +”%Y-%m-%d”)

Dump database into SQL file
mysqldump -u conntrack -pconn123 database tablename > $backup_path/$date.sql

Path Details
Backup Path –> /home/conntrack

Output Details
Output –> File will dump in Date Format with Sql Extension 2015-08-28.sql

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s