Exporting your joomla database with phpMyAmin:

Once you have logged into your phpMyAdmin on your server, do the following-

dtb

  • 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.

dt2

  • 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.