1. Open phpMyAdmin.
  2. Select the database you want to export in the left sidebar.
  3. Click the ‘Export’ button present in the top most row of your screen.
  4. Make sure that all the tables are selected in the ‘Export’ menu present at the top left corner of the page.
  5. Tick ‘Add DROP TABLE / DROP VIEW’ present in the ‘Structure’ menu.
  6. Tick ‘Save as file’  present at the bottom of the page and click ‘Go’ button.

This will download the back-up file of SQL.