Hoy lunes, comenzamos con Backups. Y como estoy bastante olvidadizo lo posteo para quede grabado a modo consulta.\u00a0Mismo se puede reutilizar para cualquier cosa:<\/p>\n
PATH_APP=\"\/var\/backups\/${HOSTNAME}\"; if [ ! -d ${PATH_APP} ]; then mkdir ${PATH_APP} ; fi\r\nDATE=`date +%Y%m%d`;\r\n# User root:\r\nu=\"root\";\r\n# Password root:\r\np=\"\"\r\nfor i in `echo \"show databases\" | mysql -u ${u} -p${p} | grep -v ^mysql$ | grep -v ^Database$ | grep -v schema`;\r\n\u00a0do\r\n\u00a0 if [ -z ${i} ];\r\n\u00a0 \u00a0then\r\n\u00a0 \u00a0 mysqldump -Q --add-drop-table -u ${u} -p${p} ${i} >> ${PATH_BACKUP}\/mysql-server\/${DATE}-${i}.sql;\r\n\u00a0 fi\r\ndone<\/pre>\n","protected":false},"excerpt":{"rendered":"Hoy lunes, comenzamos con Backups. Y como estoy bastante olvidadizo lo posteo para quede grabado a modo consulta.\u00a0Mismo se puede reutilizar para cualquier cosa: PATH_APP=\u00bb\/var\/backups\/${HOSTNAME}\u00bb; if [ ! -d ${PATH_APP} ]; then mkdir ${PATH_APP} ; fi DATE=`date +%Y%m%d`; # User<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[15,2],"tags":[28,24,27,25,26,18],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-bash","category-scripts","tag-backups","tag-bash","tag-db","tag-mysql","tag-mysql-server","tag-script"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8Ixc0-L","_links":{"self":[{"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=\/wp\/v2\/posts\/47"}],"collection":[{"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=47"}],"version-history":[{"count":1,"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":48,"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions\/48"}],"wp:attachment":[{"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/luliserver.com.ar\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}