Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home MySQL Shell script backup all Mysql Databases in Linux

Shell script backup all Mysql Databases in Linux

This shell script will backup all current Mysql databases, compress(gzip) them and put them in a new folder named by current date (one directory per database).

 

 

 

 

[text] #!/bin/bash

PATH=/usr/sbin:/sbin:/bin:/usr/bin

MyUSER="your_db_user"
MyPASS="your_db_password"
MyHOST="your_db_host"

SUBFOLDER="$(date +"%Y-%m-%d")"
DEST="/somewhere/on/your/server"
MDB="$DEST/backup/$SUBFOLDER"

if [ ! -d $MDB ] then
mkdir -p $MDB >/dev/null 2>&1 && echo "Directory $MDB created." || echo "Error: Failed to create $MDB directory."
else
echo "Error: $MDB directory exits!"
fi

NOW="$(date +"%Y-%m-%d_%H-%M-%S")"

FILE=""

DBS="$(mysql -u $MyUSER -h $MyHOST -p$MyPASS -Bse ‘show databases’)"

for db in $DBS
do
FILE="$MDB/$db.$NOW.sql.gz"
mysqldump -u $MyUSER -h $MyHOST -p$MyPASS –complete-insert $db | gzip -9 > $FILE
echo "Backup $FILE…..DONE"
done
[/text]

Feb 22, 2011Hoan Huynh
Xcode UITableView custom section header background font sizexcode change iphone app display name
You Might Also Like:
  • Schedule Backup And Zip MySQL Database In Windows
  • Facebook Like Button And Recommend Button With fb:like, iframe and html5
  • MySql backup database with gzip compression
  • How To Track Website With Multiple Google Analytisc Accounts
  • Linux remove entire directory
  • Mysql restore database from dump file with GZIP compression
  • PHP Copy Entire Directory To Another Directory
  • Backup iPhone 4s In iTunes
  • Linux copy entire directory
  • PHP Delete File Function
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

11 years ago Linux, MySQLmkdir, mysqldump, show databases242
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,442 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,823 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,631 views
JQuery Allow only numeric characters or only alphabet characters in textbox
14,978 views
C# Read Json From URL And Parse/Deserialize Json
11,691 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development