{"id":137002,"date":"2011-12-11T13:18:51","date_gmt":"2011-12-11T05:18:51","guid":{"rendered":"\/2011\/12\/11\/Alfresco.html"},"modified":"2011-12-11T13:18:51","modified_gmt":"2011-12-11T05:18:51","slug":"alfresco-2","status":"publish","type":"post","link":"https:\/\/blog.zhenglei.net\/?p=137002","title":{"rendered":"Backup&#038;Restore Alfresco with Mysql on Ubuntu"},"content":{"rendered":"<p>Cold Backup:<\/p>\n<p>sudo \/opt\/alfresco-3.4e\/alfresco.sh stop<\/p>\n<p>cd \/opt\/alfresco-3.4.e\/alf_data\/ &amp;&amp; tar cvfz \/tmp\/alfresco_data.tgz .\/<\/p>\n<p>mysqldump -u alfresco -p[password] alfresco &gt; \/tmp\/alfresco.sql<\/p>\n<p>&nbsp;<\/p>\n<p>Restore:<\/p>\n<p>cd alf_data<\/p>\n<p>sudo tar xvfz \/tmp\/alfresco_data.tgz<\/p>\n<p>mysql -ualfresco -p[password] [db_to_restore] &lt; \/tmp\/alfresco.sql<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>cold backup &#038; restore alfresco with mysql on ubuntu <a href=\"https:\/\/blog.zhenglei.net\/?p=137002\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/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":[17],"tags":[55],"class_list":["post-137002","post","type-post","status-publish","format-standard","hentry","category-dms","tag-alfresco-backup-restore"],"_links":{"self":[{"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=\/wp\/v2\/posts\/137002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=137002"}],"version-history":[{"count":0,"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=\/wp\/v2\/posts\/137002\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=137002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=137002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.zhenglei.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=137002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}