Report this

What is the reason for this report?

How to import database with Adminer for a site that's going to be migrated?

Posted on November 4, 2016

I am trying to migrate a live site (thats being hosted elsewhere now).

So I read this tutorial for importing the database: https://serverpilot.io/community/articles/how-to-manage-your-database-with-adminer.html#importing_your_database

So I installed Adminer but I can’t access the database login page. I assume because the site is using the nameservers of the shared hosting account that is currently hosting it. Is there anyway to do this without having to change nameservers now and having the site be down while I do this?

Thanks in advance.



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.

For anyone who may face the same issue in the future, I have figured out how to do this.

Instead of using your domain name to login to the database dashboard, use you server’s IP address. Like so: (replace the ip with yours)

http://12.34.162.40/adminer.php

That way you can import everything first and have the site tested before actually changing nameservers. Once you made sure all is good, change nameservers so you dont face any down time.

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.