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

November 4, 2016 69 views
Getting Started

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.

1 Answer

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.

Have another answer? Share your knowledge.