The simplest approach would be to use the mysqldump command as follows to make a backup of the database - "mysqldump -u username -p databasename > backup.sql", then transfer the backup.sql file to another machine with MySQL installed and use the following command to restore the database -"mysql -u username -p databasename backup.sql" where database name is the name of your database. If you prefer to use a graphical user interface try Quest Software's easy to use and free TOAD for MySQL which can be downloaded from here - "http://www.quest.com/toad-for-mysql/". You'll need to install TOAD for MySQL on both machines, but it will make backing up and restoring the database between machines much easier and is a great tool for working with MySQL databases and beats PHPMYADMIN hands down as the better GUI admin/development tool.

The simplest approach would be to use the mysqldump command as follows to make a backup of the database - "mysqldump -u username -p databasename > backup.sql", then transfer the backup.sql file to another machine with MySQL installed and use the following command to restore the database -"mysql -u username -p databasename backup.sql" where database name is the name of your database. If you prefer to use a graphical user interface try Quest Software's easy to use and free TOAD for MySQL which can be downloaded from here - "http://www.quest.com/toad-for-mysql/". You'll need to install TOAD for MySQL on both machines, but it will make backing up and restoring the database between machines much easier and is a great tool for working with MySQL databases and beats PHPMYADMIN hands down as the better GUI admin/development tool.