<\/p>\n
1 – Access Amazon Services<\/a><\/strong>, S3 <\/p>\n 5 – Create batch files<\/strong> for “mysqldump<\/span>” and\u00a0 “s3.exe<\/span>”<\/p>\n MySqlDump.bat<\/span> sample:<\/p>\n [vb] S3Put.bat<\/span> sample:<\/p>\n [vb] 6 – Schedule tasks<\/strong> for batch files, first \u00a0 MySqlDump.bat<\/span> then\u00a0 S3Put.bat<\/span><\/p>\n [vb] ok, it’s done \ud83d\ude09<\/p>\n s3.exe Documentation:\u00a0 http:\/\/s3.codeplex.com\/documentation<\/a> Author: Carlos Galhano<\/p>\n","protected":false},"excerpt":{"rendered":" 1 – Access Amazon Services, S3 2 – Create a New Bucket if there’s no one. 3 – Create credentials in\u00a0 IAM Amazon Services 4 – Download the tool\u00a0s3.exe for windows, from s3.codeplex.com<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[131,8,99,40,2,14,149,83],"tags":[],"class_list":["post-1567","post","type-post","status-publish","format-standard","hentry","category-backup","category-mysql","category-security","category-sql","category-truques-dicas","category-tutorials","category-web-services","category-windows-server","author-admin"],"_links":{"self":[{"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1567"}],"version-history":[{"count":12,"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1567\/revisions"}],"predecessor-version":[{"id":1569,"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1567\/revisions\/1569"}],"wp:attachment":[{"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2 – Create a New Bucket if there’s no one.
\n3 – Create credentials in\u00a0 IAM Amazon Services
\n4 – Download<\/strong> the tool\u00a0s3.exe<\/a> for windows, from s3.codeplex.com<\/a><\/p>\n
\necho Running dump…
\n"C:\\Program Files (x86)\\MySQL\\bin\\mysqldump" –add-drop-table -uroot -pmyrootpasswd –result-file="C:\\backup\\_SQLDump\\myDB_%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%_%TIME:~0,2%h%TIME:~3,2%.sql" mydbname
\necho ok!
\n[\/vb]<\/p>\n
\ns3 auth myKey mySecret
\ns3 put mybucketname C:\\backup\\_SQLDump\\myDB_*.sql \/sync
\n[\/vb]<\/p>\n
\nat \\\\mySevername 02:00 \/every:M,T,W,Th,F,S,Su "C:\\backup\\MySqlDump.bat"
\nat \\\\mySevername 06:00 \/every:M,T,W,Th,F,S,Su "C:\\backup\\S3Put.bat"
\n[\/vb]<\/p>\n
\nHow To Use the AT Command to Schedule Tasks:\u00a0 http:\/\/support.microsoft.com\/kb\/313565<\/a><\/p>\n