The mysqldump utility "dumps" everything; i.e., schema, table contents, to a text file -- you can copy that to a CD-ROM (or flash drive) and use that for a transfer to another machine (or as a backup media, for that matter).
On the other machine, you should first create the data base then use the mysqlimport utility to add the contents of the CD-ROM (or flash) to that data base.
Look at the MySQL documentation for options you may want to use with either of these utilities; also, there are examples in the documentation describing how to do this.
Instead of "internet," this is known as "sneaker-net" (because you wear your sneakers when you're walking the media from one place to another).
Hope this helps some.
|