I used mysqlhotcopy to dump a database full of tables. I know have various .frm, .MYD, and .MYI files that I need to import into a different instance of MySQL. Do I just copy these files into a specific folder on the 2nd system, or do I have to run mysqlhotcopy with another command line option to perform the import?
+1
A:
Those are the binary data files for your tables - if you have a .frm, .MYD and .MYI for each, you can copy those into your database folder (typically /var/lib/mysql/<schema-name>/). Stop your database first though!
If you make mysqlhotcopy run a bit faster with the --noindices option, then after copying the files you'll need to recreate the indices from the data files - inside the database directory, run myisamchk -rq
Paul Dixon
2009-09-28 20:59:06
I figured that's all it was, but I couldn't find documentation that spelled it out, and I also wasn't sure what path I needed. Thanks for the info! :)
Matt Huggins
2009-09-28 21:02:49