Originally Posted by amb.godwin
The problem I found with that is, I have a given a limitation of importing only 10.2Mb of data from phpMyadmin.
At this moment I have only 55Mb of data for the whole database and I frequently upload and download one table of size 9Mb though I zip it and get 1-2 Mb, but am sure it come a time where I will be required to import say 100Mb.
By that time you'll run into PHP's memory and upload limit, especially if you're on a (budget) shared hosting environment. Only way around it then is to use SSH to get MySQL to do it for you.