Report this

What is the reason for this report?

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

Posted on July 31, 2013

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.



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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).

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.