My approach for MyISAM files between identical versions of MySQL is:
First 'flush tables' using MySQL and make sure the system is quiescent -
shutting down the server is a good idea.
I usually copy the entire database directory but copying the .MYI
(index), .MYD (data) and .frm (structure) files for each table has worked.
If you can't do the transfer as 'root' chown -R the owner/group and
restore to mysql:mysql at the other end.
That should be sufficient if you're not replacing a table. If you are
replacing a table, the server may have the original files open and will
carry on using them. Fortunately I can shut-down the server while doing
Somewhat slower and safer would be a mysqldump from the remote computer
piped into mysql for the destination computer. I think this should work
with all 'real' engines and may be necessary when moving between MySQL
versions (I used it moving from v5.0 to v4.0 with appropriate switches).
I don't use it currently because I'm mostly transferring packed MyISAM
tables and I want them to stay packed!
Systems Developer FamilyHistoryOnline www.familyhistoryonline.net
FreeBSD Apache MySQL Perl mod_perl PHP