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":0},"categories":[7],"tags":[485,487,488,260,76,486],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/2508"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=2508"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/2508\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=2508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=2508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=2508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}