1. Sign in to phpMyAdmin (see Logins and URLs).
2. Select the database in the left navigation frame, which should bring up the database details in the main frame
3. Select the Export tab
4. Under Export, select SQL
5. Select Structure if you'll be using the data to create new tables
6. Select Add drop table if the data is intended to completely replace tables
7. Select Data
8. Select Save as File
9. Select your preferred compression format (none, zipped, gzipped, or bzipped)
10. Click Go (bottom-right)

The mysql data should download to your browser's default download destination.

1. Sign in to phpMyAdmin (see Logins and URLs).
2. Select the SQL tab in the main phpMyAdmin frame
3. Click Choose File
4. Locate the SQL file on your computer
5. Once you've selected your import file, click Go

If you get any Table already exists errors while importing data, re-save the sql with the *Add drop table* option checked, or simply delete the conflicting tables and run the import again.

cd to whatever directory you wish to store the data, and enter:

mysqldump --default-character-set=latin1 -C -u USERNAME -p --opt --lock-tables=false --skip-add-locks --skip-extended-insert DATABASE > DATABASE.sql

Make sure you replace the values in CAPS with the correct info for your account (you can also change the character set if you wish).

To tgz compress the file DATABASE.sql for easier transportation:

tar czvf DATABASE.tgz DATABASE.sql

cd to wherever the sql data is stored, and enter:

mysql -uUSER -pPASSWORD DATABASE < DATABASE.sql

Again, make sure to replace the values in CAPS.