Question

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

Posted November 4, 2016 5k 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.

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.

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

Submit an Answer