phpmyadmin has an 'export' option. you can then select to gzip the result.

if all goes well, you'll have something like 'yoursite.sql.gz' ready to d/l to your computer smile