Are you using phpMyAdmin for you interface?
If so you just have to select the database in the left hand column and click the export tab along the top. Hightlight all the tables, chose sturcture and data. choose save and wither you want the file to be compressed or not.