Question

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

Posted July 31, 2013 3.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.
Add a comment
212nath
By:
212nath

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.

×
4 answers
pablo July 31, 2013
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?
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.
Reply Report
212nath July 31, 2013
Well I have no preference, as long as it works! Which is the easiest way?
Reply Report
pablo July 31, 2013
Do you have SSH access to your shared hosting?
Reply Report
kamaln7 August 1, 2013
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).
Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help