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

Posted July 31, 2013 4k 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.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
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).