Since I am involved in a multi-developer, version-controlled setup, I do a lot of database importing and exporting from environments.
I notice today that when I export a database from one of our sites using the control panel "Backup Database" function, it comes out at about 3.6MB and takes about 5 minutes to import.
When I export from Sequel Pro, the database dump comes out at about 1.6MB and imports within 30 seconds.
Note, I always dump the existing tables before import.
Just wondering what the difference is here that there is such a difference in file size and import time and which way is best?