Activities

March 2011
M T W T F S S
« Feb   Apr »
 123456
78910111213
14151617181920
21222324252627
28293031  

MySQL : Multiple tables backup using mysqldump

I have a requirement to backup few tables from a huge database as total dump is taking 2 hours and about 30GB in size. Huge tables are containing static data which doesn’t change frequently.

Here is the scripts to do that,

#!/bin/bash # Created by Liju on 09/03/2011 # DB_NAME=’db’ USER=’username’ PASS=’user_pass’ HOST=’localhost’ DUMP_LOC=’/storage1/temp’ NOW=”$(date […]