{"id":9470,"date":"2021-03-21T14:18:42","date_gmt":"2021-03-21T12:18:42","guid":{"rendered":"https:\/\/www.beseit.net\/?p=9470"},"modified":"2021-03-21T14:18:42","modified_gmt":"2021-03-21T12:18:42","slug":"revisar-task-sheduler-bd-backup","status":"publish","type":"post","link":"https:\/\/www.beseit.net\/?p=9470","title":{"rendered":"revisar task sheduler: bd backup"},"content":{"rendered":"

general: MySqlBackup window10
triggers: daily at 19:30 status;enable
actions: star a program “c:\\dropbox\\dbForge studio\\executa BAK.bat”
\n<\/span><\/p>\n

Per comprobar que l’acci\u00f3 funciona es pot llan\u00e7at l’acci\u00f3 des del indicador d’ordres de Windows. si dona l’error “no est\u00e0 perm\u00e8s l’acc\u00e9s a root@192.168.1.1, verificar a comptes d’usuari del phpMyAdmin que aquest usuari existeix. .
\n<\/span><\/p>\n

\"\"\/\n\t<\/p>\n

\"\"\/\n\t<\/p>\n

Observem que hi ha creada la tasca BACKUP que corre ‘every day’ a les 20:45. L’acci\u00f3 es executar “C:\\Executa BAK.bat”<\/strong><\/span>
\n\t\t<\/span><\/p>\n

\"\"\/\n\t<\/p>\n

Executa BAK.BAT
\n<\/span><\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\fons_mut.backup”\n<\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\polidic_eng.backup”\n<\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\polidic_cat.backup”\n<\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\polidic_fra.backup”\n<\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\polidic_ger.backup”\n<\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\polidic_ita.backup”\n<\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\polidic_por.backup”\n<\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\polidic_eus.backup”\n<\/p>\n

“c:\\Program Files\\Devart\\dbForge Studio for MySQL\\dbforgemysql.com” \/backup \/projectfile:”T:\\dbForge Studio\\agenda.backup”\n<\/p>\n

\n\u00a0<\/p>\n

fons_mut.backup <\/span>… etc, s\u00f3n programes que s’han generat pr\u00e8viament en dbForge Studio for MySQL quan s’han fet els backup i s’han guardat en aquest directori.\n<\/p>\n

\n\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

general: MySqlBackup window10triggers: daily at 19:30 status;enableactions: star a program “c:\\dropbox\\dbForge studio\\executa BAK.bat” Per comprobar que l’acci\u00f3 funciona es pot llan\u00e7at l’acci\u00f3 des del indicador d’ordres de Windows. si dona l’error “no est\u00e0 perm\u00e8s l’acc\u00e9s a root@192.168.1.1, verificar a comptes … Continua llegint →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9470","post","type-post","status-publish","format-standard","hentry","category-bloc-de-notes"],"_links":{"self":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/9470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9470"}],"version-history":[{"count":2,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/9470\/revisions"}],"predecessor-version":[{"id":9472,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/9470\/revisions\/9472"}],"wp:attachment":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}