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.

Now playing: Samba de Orpheus by Vince Guaraldi


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 Reply

Your email address will not be published. Required fields are marked *