{"id":926,"date":"2015-06-04T09:57:16","date_gmt":"2015-06-04T07:57:16","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=926"},"modified":"2015-06-04T09:57:16","modified_gmt":"2015-06-04T07:57:16","slug":"my_imp_database-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/my_imp_database-sh\/","title":{"rendered":"my_imp_database.sh"},"content":{"rendered":"<pre># ==================================================\n# Nom :\n# Objet :\n# Auteur :\n# Cree le :\n# Syntaxe : user pwd database_FROM_name database_TO_name\n# ==================================================<\/pre>\n<pre>user=$1\npwd=$2\ndatabasefrom=$3\ndatabaseto=$4<\/pre>\n<pre>w_date=$(date '+%Y%m%d_%H%M%S')\nlogpath=\/exploit\/logs\nlogfile=my_import_${databaseto}_${w_date}.log\ndumpfile=\/exploit\/dumps\/my_exp_${databasefrom}.sql\nsqlfile=\/exploit\/logs\/my_imp_${databaseto}_${w_date}.sql\n# ----------------------------------\n# Fonction d'affichage de la syntaxe\n# ----------------------------------\nsyntaxe()\n{\n echo \"Usage : $0 $1 user $2 pwd $3 database_FROM_name $4 database_TO_name\"\n}\n# ----------------------------------<\/pre>\n<pre>\n# --------------------------\n# Verification de la syntaxe\n# --------------------------\n#if [ $# -ne 3 -a $# -ne 4 ]\nif [ $# -lt 3 ]\nthen\n echo \"==================================================\"\n echo \"ERREUR : Nombre d'arguments incorrects !\"\n syntaxe\n echo \"==================================================\"\n exit 1\nfi\necho \"-------------------------------------------------\"\necho \" DROP and CREATE DATABASE $databaseto;\"\necho \"-------------------------------------------------\"\n# tee $logpath\/$logfile;<\/pre>\n<pre>#echo \"DROP DATABASE if exists $databaseto;\"&gt;$sqlfile;\n#echo \"CREATE DATABASE IF NOT EXISTS $databaseto;\"&gt;&gt;$sqlfile;\n#echo \"show databases;\"&gt;&gt;$sqlfile;\n#echo \"use $databaseto;\"&gt;&gt;$sqlfile;\n#echo \"source $dumpfile;\"&gt;&gt;$sqlfile;\n#echo \"\"<\/pre>\n<pre>#cat $sqlfile;<\/pre>\n<pre>#mysql --show-warnings -u $user -p${pwd} &lt;$sqlfile &gt;$logpath\/$logfile;<\/pre>\n<pre>mysql --show-warnings -u $user -p${pwd} &lt;&lt; EOF\n warnings;\n DROP DATABASE if exists $databaseto;\n CREATE DATABASE IF NOT EXISTS $databaseto;\n show databases;\n use $databaseto;\n source $dumpfile;\nEOF\necho \"-------------------------------------------------\"\n# cat $logpath\/$logfile<\/pre>\n","protected":false},"excerpt":{"rendered":"<p># ================================================== # Nom : # Objet : # Auteur : # Cree le : # Syntaxe : user pwd database_FROM_name database_TO_name # ================================================== user=$1 pwd=$2 databasefrom=$3 databaseto=$4 w_date=$(date &lsquo;+%Y%m%d_%H%M%S&rsquo;) logpath=\/exploit\/logs logfile=my_import_${databaseto}_${w_date}.log dumpfile=\/exploit\/dumps\/my_exp_${databasefrom}.sql sqlfile=\/exploit\/logs\/my_imp_${databaseto}_${w_date}.sql # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- # Fonction d&rsquo;affichage de la syntaxe # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- syntaxe() { echo &laquo;&nbsp;Usage : $0 $1 user $2 pwd $3 &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/my_imp_database-sh\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;my_imp_database.sh&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[53,35],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/926"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=926"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/926\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=926"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}