1.  Log in on phpMyAdmin.

2.  Select the database of your WordPress site in the left hand column.

3.  Click on the tab Export.

 


5.  For Export method select 'Custom'.

6.  Within 'Database(s)' click on 'Select All'.

7.  For 'Output' select 'Save output to file' and use the following settings:

- Character set of the file: utf-8

- Compression: zipped

8. For 'Format' select the option SQL.

9.  For 'Object creation options' tick on the option to add the statement ‘DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT’.

10.  Click on 'Go'.