Backing Up MovableType MYSQL database
root# /usr/local/bin/mysqldump -u [user] -p[password] mov_type > /volumes/YODAMEDIA/mov_type_bak.sql
Where [user] is the MySQL user i.d. There is no space between "p" 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.
See docs on mysqldump.
Where HardDisk1/usr/local/mysql-3.23.55/data/mov_type/
Name Size Modified
mov_type 3/22/03, 12:24:37 AM
mt_author.frm 9 K 3/22/03, 12:24:37 AM
mt_author.MYD 2 K 8/16/03, 8:50:03 PM
mt_author.MYI 4 K 8/16/03, 8:50:19 PM
mt_blog.frm 11 K 3/22/03, 12:24:37 AM
mt_blog.MYD 4 K 8/25/03, 4:24:53 PM
mt_blog.MYI 4 K 8/25/03, 4:24:53 PM
mt_category.frm 9 K 3/22/03, 12:24:37 AM
mt_category.MYD 1 K 8/30/03, 9:37:35 AM
mt_category.MYI 3 K 8/30/03, 9:37:35 AM
mt_comment.frm 9 K 3/22/03, 12:24:37 AM
mt_comment.MYD 98 K 8/27/03, 10:52:54 PM
mt_comment.MYI 19 K 8/27/03, 10:52:54 PM
mt_entry.frm 10 K 3/22/03, 12:24:37 AM
mt_entry.MYD 291 K 8/30/03, 11:43:49 PM
mt_entry.MYI 22 K 8/30/03, 11:43:49 PM
mt_ipbanlist.frm 9 K 3/22/03, 12:24:37 AM
mt_ipbanlist.MYD 0 K 3/22/03, 12:24:37 AM
mt_ipbanlist.MYI 1 K 3/22/03, 12:24:37 AM
mt_log.frm 9 K 3/22/03, 12:24:37 AM
mt_log.MYD 40 K 8/30/03, 10:46:19 PM
mt_log.MYI 16 K 8/30/03, 10:46:19 PM
mt_notification.frm9 K 3/22/03, 12:24:37 AM
mt_notification.MYD1 K 6/29/03, 11:11:40 AM
mt_notification.MYI3 K 6/29/03, 11:11:40 AM
mt_permission.frm 9 K 3/22/03, 12:24:37 AM
mt_permission.MYD 1 K 8/16/03, 8:50:03 PM
mt_permission.MYI 3 K 8/16/03, 8:50:19 PM
mt_placement.frm 9 K 3/22/03, 12:24:37 AM
mt_placement.MYD 3 K 8/30/03, 11:43:34 PM
mt_placement.MYI 11 K 8/30/03, 11:43:49 PM
mt_plugindata.frm 9 K 3/22/03, 12:24:37 AM
mt_plugindata.MYD 0 K 3/22/03, 12:24:37 AM
mt_plugindata.MYI 1 K 3/22/03, 12:24:37 AM
mt_tbping.frm 9 K 3/22/03, 12:24:37 AM
mt_tbping.MYD 2 K 6/29/03, 2:18:40 PM
mt_tbping.MYI 6 K 6/29/03, 2:18:40 PM
mt_template.frm 9 K 3/22/03, 12:24:37 AM
mt_template.MYD 316 K 8/27/03, 10:21:25 AM
mt_template.MYI 10 K 8/27/03, 10:21:25 AM
mt_templatemap.frm 9 K 3/22/03, 12:24:37 AM
mt_templatemap.MYD 2 K 8/16/03, 8:45:49 PM
mt_templatemap.MYI 6 K 8/16/03, 8:45:49 PM
mt_trackback.frm 10 K 3/22/03, 12:24:37 AM
mt_trackback.MYD 14 K 8/21/03, 10:00:22 PM
mt_trackback.MYI 6 K 8/21/03, 10:00:22 PM
Leave a comment