{"id":1039,"date":"2015-07-21T16:31:23","date_gmt":"2015-07-21T14:31:23","guid":{"rendered":"http:\/\/www.h-hennes.fr\/blog\/?p=1039"},"modified":"2015-07-21T16:31:23","modified_gmt":"2015-07-21T14:31:23","slug":"ovh-mutualise-copier-une-base-de-donnees-dans-une-autre-avec-ssh","status":"publish","type":"post","link":"https:\/\/www.h-hennes.fr\/blog\/2015\/07\/21\/ovh-mutualise-copier-une-base-de-donnees-dans-une-autre-avec-ssh\/","title":{"rendered":"Ovh mutualis\u00e9 copier une base de donn\u00e9es dans une autre avec ssh"},"content":{"rendered":"<p>Voici un petit script bash qui vous permettra de copier facilement le contenu d&rsquo;une base de donn\u00e9es \u00e0 une autre depuis un h\u00e9bergement mutualis\u00e9 ovh.<br \/>\n( Ce script fonctionne uniquement \u00e0 partir des h\u00e9bergements pro, car il n\u00e9cessite un acc\u00e8s ssh )<br \/>\nLe d\u00e9roul\u00e9 du script est le suivant :<\/p>\n<ul>\n<li>Export de la bdd \u00e0 copier<\/li>\n<li>Sauvegarde de la bdd de destination<\/li>\n<li>Suppression des donn\u00e9es de la bdd de destination<\/li>\n<li>Insertion des donn\u00e9es de la bdd \u00e0 copier dans la bdd de destination<\/li>\n<\/ul>\n<pre lang=\"bash\" escaped=\"true\">#!\/bin\/bash\r\n\r\n#Saisir les param\u00e8tres des bases de donn\u00e9es\r\nserveurProd=\"mysql.ovh\"\r\nuserProd=\"user\"\r\npassProd=\"password\"\r\n\r\nserveurPreprod=\"mysql.preprod\"\r\nuserPreprod=\"preprod\"\r\npassPreprod=\"preprod\"\r\n\r\n#Export de la base de donnees de prod\r\necho \"Sauvegarde base de prod\"\r\nmysqldump --host=$serveurProd --user=$userProd --password=$passProd $userProd | gzip &gt; backup-prod_$(date +\"%Y-%m-%d\").sql.gzip\r\n\r\n#Sauvegarde de la base de donnees de preprod\r\necho \"Sauvegarde base de preprod\"\r\nmysqldump --host=$serveurPreprod --user=$userPreprod --password=$passPreprod $userPreprod | gzip &gt; backup-preprod_$(date +\"%Y-%m-%d\").sql.gzip\r\n\r\n#Suppression des donnees de la base de donnes preprod\r\necho \"Suppression des donnees de la table de preprod\"\r\nTABLES=$(mysql -h $serveurPreprod -u $userPreprod -p$passPreprod $userPreprod -e 'show tables' | awk '{ print $1}' | grep -v '^Tables' )\r\n\r\nfor t in $TABLES\r\ndo\r\necho \"Suppression de la table\u00a0 $t de la base de donn\u00e9es $userPreprod ...\"\r\nmysql -h $serveurPreprod -u $userPreprod -p$passPreprod $userPreprod -e \"drop table $t\"\r\ndone\r\n\r\n#Insertion des donn\u00e9es de prod dans la table de preprod\r\necho \"Insertion des nouvelles donnees dans la table de preprod\"\r\nzcat backup-prod_$(date +\"%Y-%m-%d\").sql.gzip | mysql -h $serveurPreprod -u $userPreprod -p$passPreprod $userPreprod\r\n<\/pre>\n<p>Pour utiliser ce script, il faut cr\u00e9er un fichier (ex: update-bdd.sh) avec le contenu ci-dessus sur votre h\u00e9bergement<br \/>\nPuis de se connecter en ssh et de l\u2019ex\u00e9cuter avec la commande suivante :<\/p>\n<pre lang=\"bash\">bash update-bdd.sh<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Voici un petit script bash qui vous permettra de copier facilement le contenu d&rsquo;une base de donn\u00e9es \u00e0 une autre depuis un h\u00e9bergement mutualis\u00e9 ovh. ( Ce script fonctionne uniquement \u00e0 partir des h\u00e9bergements pro, car il n\u00e9cessite un acc\u00e8s ssh ) Le d\u00e9roul\u00e9 du script est le suivant : Export de la bdd \u00e0 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[6],"tags":[369,75,370,171,170],"class_list":["post-1039","post","type-post","status-publish","format-standard","hentry","category-trucs-et-astuces","tag-mutualise","tag-mysql","tag-mysqldump","tag-ovh","tag-ssh"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/1039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/comments?post=1039"}],"version-history":[{"count":3,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/1039\/revisions"}],"predecessor-version":[{"id":1042,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/1039\/revisions\/1042"}],"wp:attachment":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/media?parent=1039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/categories?post=1039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/tags?post=1039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}