Moving mySQL DBs from one server to another:
mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql
puts the entire thing in one nicely portable text file.
on a new server it takes
mysql -uUSER -pPASSWORD txp_database < txp_database.sql
to import it.