- Open phpMyAdmin.
- Select the database you want to export in the left sidebar.
- Click the ‘Export’ button present in the top most row of your screen.
- Make sure that all the tables are selected in the ‘Export’ menu present at the top left corner of the page.
- Tick ‘Add DROP TABLE / DROP VIEW’ present in the ‘Structure’ menu.
- Tick ‘Save as file’ present at the bottom of the page and click ‘Go’ button.
This will download the back-up file of SQL.