Is it possible to upload database that has been exported from phpmyadmin?

July 31, 2013 1.8k views
I have recently got a droplet and transferred most of my website from a shared hosting company, and I want to transfer a mini-blog that requires a database. Is there anyway I can export this from phpmyadmin, and transfer it to my droplet? I believe I have installed all the necessary things - such as the MYSQL server.
4 Answers
Is there a particular reason why you want to transfer your database via phpMyAdmin as opposed to other methods, such as the ones described, here: How to Migrate MySQL Between Two Servers or How to Migrate WordPress from Shared Hosting to a Cloud Server with Zero Downtime?
by Ramesh Jha
If you read through this article you'll have the knowledge to migrate your WordPress site from Shared Hosting to a Cloud Server with zero downtime.
Well I have no preference, as long as it works! Which is the easiest way?
Do you have SSH access to your shared hosting?
The easiest way would be uploading your phpmyadmin export (.sql) using the scp command (Step #2 in How to Migrate MySQL Between Two Servers) and importing it (Step #3).
Have another answer? Share your knowledge.