如何在独立的sql文件中导出所有表

I have to upload my database on godaddy host but it restricted to upload more than 8 mb file. So I have to decided to upload my table one by one. I am looking for a query or a way to export each table one by one, is there any way available to do this job easily? That i get each table sql with data?I have to upload my database on godaddy host bu