the best way to export contents of a database is to use the program mysqldump.
you may use it like
mysqldump somedatabase table_1 table_2 > somedatabase.txt
or
mysqldump --databases DB1 DB2 > mydbbackups.sql
or
mysqldump --all-databases > databases.sql
then you have a text file with all the create table statements, and insert statements to put data back in.
then from another machine, you can login to mysql from command prompt and type
mysql> \u somedatabase
mysql> . somedatabase.txt
and it will show you the result of each insert statement, and recreate all the tables with the old values.
