The size of the database dump can be many times smaller than the size of the hosting database.
To export the database via phpMyAdmin, do the following:
-
Select a database from the list on the left:

Open the "
Export", Make sure the radio button is checked next to the"
Quick"And in the field"
Format»Selected«
SQL", and press "
Forward»:

This will download a file in SQL format with the current contents of the database. The resulting file can be used for subsequent import.