Export and import mysql database for webhosting

phpmyadmin provides good interface to upload and download database .








All webhosting sites provides phpmyadmin to upload databases.

Here is interface to export database.It is very simple you can select database or tables to export

You can export database in following formats

1. CSV
2. CSV for MS Excel
3. Microsoft Excel 2000
4. Microsoft Word 2000
5. LaTeX
6. Open Document Spreadsheet
7. Open Document Text 
8.  PDF
9.  SQL
10 .XML
Most commonly database is exported as sql

You can also download database in zipped or gzip format


For importing database browse the databse and save to server through import interface