Taking MYSQL dump is usual requirement in my project . And Since some of the tables in project are huge so often I have to take dumps of selected tables and often have to ignore some tables.<\/p>\n
since we had to do it frequently in our project so I created a script\u00a0 which does following for me.<\/p>\n
Inside the script I have added variables like username and password which are required by Mysql. (So if you are using this ,you will need to change them.)<\/p>\n
[shell]
\nUSER="username"
\nPASSWORD="password"
\nDATABASE="$1"
\nDUMPS="Dumps"
\nDUMPDIR="$DATABASE$DUMPS"
\nFILENAME="latest.sql"
\ncd;mkdir "$DUMPDIR"<\/p>\n
if [ $# -eq 0 ]; then
\n\techo "Usage : <databasename> <tablename*> # if table name(s) is specified only that\/those table will be dumped"
\n\techo "Altername Usage : <databasename> -k <table(s)dToBeIgnored>"
\n\texit
\nfi<\/p>\n
if [ $# -eq 1 ];then
\necho "Dumping $DATABASE to $DUMPDIR\/$FILENAME"
\nmysqldump –user="$USER" –password="$PASSWORD" "$DATABASE" > ~\/"$DUMPDIR"\/"$FILENAME"
\nfi<\/p>\n
COMMAND="mysqldump –user=$USER –password=$PASSWORD $DATABASE"
\nif [ $# -gt 1 -a $2 != "-i" ];
\n\tthen
\n for i in $*
\n\t do
\n\t\t if [ $i != "$DATABASE" -a $i != "-i" ];then
\n\t\t\t $COMMAND $i > ~\/"$DUMPDIR"\/"$i.sql";
\n\t\t fi
\n\t done
\nfi<\/p>\n
if [ $# -gt 2 -a $2 == "-i" ];
\n\tthen
\n\tCOMMAND2=" "
\n\tfor i in $*
\n\tdo
\n\t\tif [ $i != "$DATABASE" -a $i != "-i" ];then
\n\t\tCOMMAND2="$COMMAND2 –ignore-table=$DATABASE.$i"
\n\t\tfi
\n\tdone
\n\t$COMMAND $COMMAND2 > ~\/"$DUMPDIR"\/"$DATABASE"-"Ignored.sql"
\nfi
\n[\/shell]<\/p>\n
Now what this can be used in three ways –
\n(Note – I have named this script sqlDump and all of following examples use this name )<\/p>\n
<\/blockquote>\nIf file is executed without any arguments it will just describe its Usage
\nNote – All of these tables will be stored in directory named <databasename>Dumps in home directory.<\/p>\n<\/p>\n
This has helped me many times and has saved my time too . Hope this helps you too<\/p>\n
_________________________________<\/p>\n
Hitesh Bhatia<\/em><\/a><\/p>\n
Mail,LinkedIn,Facebook<\/a>,Twitter<\/a><\/p>\n
_________________________________<\/p>\n","protected":false},"excerpt":{"rendered":"
Taking MYSQL dump is usual requirement in my project . And Since some of the tables in project are huge so often I have to take dumps of selected tables and often have to ignore some tables. since we had to do it frequently in our project so I created a script\u00a0 which does following […]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":1,"footnotes":""},"categories":[7],"tags":[485,487,488,260,76,486],"class_list":["post-2508","post","type-post","status-publish","format-standard","hentry","category-grails","tag-database-dump","tag-dump-of-specified-tables","tag-ignore-tables-in-dump","tag-linux","tag-mysql","tag-mysql-dump"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t