{"id":89,"date":"2003-08-30T23:43:28","date_gmt":"2003-08-30T23:43:28","guid":{"rendered":"http:\/\/fiveforks.com\/jeb\/2003\/08\/backing_up_mova\/"},"modified":"2003-08-30T23:43:28","modified_gmt":"2003-08-30T23:43:28","slug":"backing_up_mova","status":"publish","type":"post","link":"https:\/\/www.fiveforks.com\/jeb\/2003\/08\/backing_up_mova\/","title":{"rendered":"Backing Up MovableType MYSQL database"},"content":{"rendered":"<p>root# \/usr\/local\/bin\/mysqldump -u [user] -p[password] mov_type &gt; \/volumes\/YODAMEDIA\/mov_type_bak.sql<\/p>\n<p>Where [user] is the MySQL user i.d. There is no space between &#8220;p&#8221; and password. The key to finding mov_type database was to drop FileBuddy onto Pseudo. The MySQL data directory was hidden from me, but is not hidden from root.<\/p>\n<p>See docs on <a href=\"http:\/\/www.mysql.com\/doc\/en\/mysqldump.html\">mysqldump<\/a>.<\/p>\n<div class=\"posted\">Now playing: <B>Samba de Orpheus<\/B> by <a href=\"http:\/\/www.google.com\/search?q=%22Vince Guaraldi%22\" target=\"_blank\">Vince Guaraldi<\/a> <\/div>\n<p><!--more--><br \/>\n<font>Where              HardDisk1\/usr\/local\/mysql-3.23.55\/data\/mov_type\/<\/p>\n<p>Name               Size      Modified<\/p>\n<p>mov_type                     3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_author.frm      9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_author.MYD      2 K       8\/16\/03, 8:50:03 PM<\/p>\n<p>mt_author.MYI      4 K       8\/16\/03, 8:50:19 PM<\/p>\n<p>mt_blog.frm        11 K      3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_blog.MYD        4 K       8\/25\/03, 4:24:53 PM<\/p>\n<p>mt_blog.MYI        4 K       8\/25\/03, 4:24:53 PM<\/p>\n<p>mt_category.frm    9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_category.MYD    1 K       8\/30\/03, 9:37:35 AM<\/p>\n<p>mt_category.MYI    3 K       8\/30\/03, 9:37:35 AM<\/p>\n<p>mt_comment.frm     9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_comment.MYD     98 K      8\/27\/03, 10:52:54 PM<\/p>\n<p>mt_comment.MYI     19 K      8\/27\/03, 10:52:54 PM<\/p>\n<p>mt_entry.frm       10 K      3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_entry.MYD       291 K     8\/30\/03, 11:43:49 PM<\/p>\n<p>mt_entry.MYI       22 K      8\/30\/03, 11:43:49 PM<\/p>\n<p>mt_ipbanlist.frm   9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_ipbanlist.MYD   0 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_ipbanlist.MYI   1 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_log.frm         9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_log.MYD         40 K      8\/30\/03, 10:46:19 PM<\/p>\n<p>mt_log.MYI         16 K      8\/30\/03, 10:46:19 PM<\/p>\n<p>mt_notification.frm9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_notification.MYD1 K       6\/29\/03, 11:11:40 AM<\/p>\n<p>mt_notification.MYI3 K       6\/29\/03, 11:11:40 AM<\/p>\n<p>mt_permission.frm  9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_permission.MYD  1 K       8\/16\/03, 8:50:03 PM<\/p>\n<p>mt_permission.MYI  3 K       8\/16\/03, 8:50:19 PM<\/p>\n<p>mt_placement.frm   9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_placement.MYD   3 K       8\/30\/03, 11:43:34 PM<\/p>\n<p>mt_placement.MYI   11 K      8\/30\/03, 11:43:49 PM<\/p>\n<p>mt_plugindata.frm  9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_plugindata.MYD  0 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_plugindata.MYI  1 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_tbping.frm      9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_tbping.MYD      2 K       6\/29\/03, 2:18:40 PM<\/p>\n<p>mt_tbping.MYI      6 K       6\/29\/03, 2:18:40 PM<\/p>\n<p>mt_template.frm    9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_template.MYD    316 K     8\/27\/03, 10:21:25 AM<\/p>\n<p>mt_template.MYI    10 K      8\/27\/03, 10:21:25 AM<\/p>\n<p>mt_templatemap.frm 9 K       3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_templatemap.MYD 2 K       8\/16\/03, 8:45:49 PM<\/p>\n<p>mt_templatemap.MYI 6 K       8\/16\/03, 8:45:49 PM<\/p>\n<p>mt_trackback.frm   10 K      3\/22\/03, 12:24:37 AM<\/p>\n<p>mt_trackback.MYD   14 K      8\/21\/03, 10:00:22 PM<\/p>\n<p>mt_trackback.MYI   6 K       8\/21\/03, 10:00:22 PM<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p><font>Where              HardDisk1\/usr\/local\/mysql-3.23.55\/data\/mov_type\/Name               Size      Modifiedmov_type                     3\/22\/03, 12:24:37 AMmt_author.frm      9 K       3\/22\/03, 12:24:37 AMmt_author.MYD      2 K       8\/16\/03, 8:50:03 PMmt_author.MYI      4 K       8\/16\/03, 8:50:19 PMmt_blog.frm        11 K      3\/22\/03, 12:24:37 AMmt_blog.MYD        4 K       8\/25\/03, 4:24:53 PMmt_blog.MYI        4 K       8\/25\/03, 4:24:53 PMmt_category.frm    9 K       3\/22\/03, 12:24:37 AMmt_category.MYD    1 K       8\/30\/03, 9:37:35 AMmt_category.MYI    3 K       8\/30\/03, 9:37:35 AMmt_comment.frm     9 K       3\/22\/03, 12:24:37 AMmt_comment.MYD     98 K      8\/27\/03, 10:52:54 PMmt_comment.MYI     19 K      8\/27\/03, 10:52:54 PMmt_entry.frm       10 K      3\/22\/03, 12:24:37 AMmt_entry.MYD       291 K     8\/30\/03, 11:43:49 PMmt_entry.MYI       22 K      8\/30\/03, 11:43:49 PMmt_ipbanlist.frm   9 K       3\/22\/03, 12:24:37 AMmt_ipbanlist.MYD   0 K       3\/22\/03, 12:24:37 AMmt_ipbanlist.MYI   1 K       3\/22\/03, 12:24:37 AMmt_log.frm         9 K       3\/22\/03, 12:24:37 AMmt_log.MYD         40 K      8\/30\/03, 10:46:19 PMmt_log.MYI         16 K      8\/30\/03, 10:46:19 PMmt_notification.frm9 K       3\/22\/03, 12:24:37 AMmt_notification.MYD1 K       6\/29\/03, 11:11:40 AMmt_notification.MYI3 K       6\/29\/03, 11:11:40 AMmt_permission.frm  9 K       3\/22\/03, 12:24:37 AMmt_permission.MYD  1 K       8\/16\/03, 8:50:03 PMmt_permission.MYI  3 K       8\/16\/03, 8:50:19 PMmt_placement.frm   9 K       3\/22\/03, 12:24:37 AMmt_placement.MYD   3 K       8\/30\/03, 11:43:34 PMmt_placement.MYI   11 K      8\/30\/03, 11:43:49 PMmt_plugindata.frm  9 K       3\/22\/03, 12:24:37 AMmt_plugindata.MYD  0 K       3\/22\/03, 12:24:37 AMmt_plugindata.MYI  1 K       3\/22\/03, 12:24:37 AMmt_tbping.frm      9 K       3\/22\/03, 12:24:37 AMmt_tbping.MYD      2 K       6\/29\/03, 2:18:40 PMmt_tbping.MYI      6 K       6\/29\/03, 2:18:40 PMmt_template.frm    9 K       3\/22\/03, 12:24:37 AMmt_template.MYD    316 K     8\/27\/03, 10:21:25 AMmt_template.MYI    10 K      8\/27\/03, 10:21:25 AMmt_templatemap.frm 9 K       3\/22\/03, 12:24:37 AMmt_templatemap.MYD 2 K       8\/16\/03, 8:45:49 PMmt_templatemap.MYI 6 K       8\/16\/03, 8:45:49 PMmt_trackback.frm   10 K      3\/22\/03, 12:24:37 AMmt_trackback.MYD   14 K      8\/21\/03, 10:00:22 PMmt_trackback.MYI   6 K       8\/21\/03, 10:00:22 PM <\/font><\/p>\n<p> <a href=\"https:\/\/www.fiveforks.com\/jeb\/2003\/08\/backing_up_mova\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-89","post","type-post","status-publish","format-standard","hentry","category-tech"],"_links":{"self":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts\/89","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/comments?post=89"}],"version-history":[{"count":0,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts\/89\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/media?parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/categories?post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/tags?post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}