Exporting your joomla database with phpMyAmin:
Once you have logged into your phpMyAdmin on your server, do the following-
- On the left column, you have the listing of the available databases.
- Click on the link of the database you wish to export for example -dtb1.
- Once you have clicked on dtb1, list of tables in dtb1 will be displayed on the screen.
- Click on the export tab.
- Click on the button labeled-GO
- Save your file as "sql"
- Note where you have saved your file.