0

Transfer database between 2 host using PHPMyAdmin

Asked 3 weeks ago (Feb 17, 2021) in the field of Web Hosting by Mike

Hi, I have two servers that I want to move database host A to host B. I know how to do this through the Linux shell but I only have access to PHPMyAdmin. Now I want to know if I can connect from PHPMyAdmin server B to PHPMyAdmin server A and get a backup from its database and transfer it? The database size I have is large and I can not export then import on server B there.


Answers


0
Answered 3 weeks ago (Feb 18, 2021) by Eldernode Staff

When exporting from the first host database, in the output section it tells you that if you want this backup to be saved in /var/lib/phpMyAdmin/save/, check to keep the database backup in that path.

Transfer database between 2 host using PHPMyAdmin

 

Then tell the server admin to move the database backup from the save directory to /var/lib/phpMyAdmin/upload/ on your second host.

On the other hand, if you go to your second host, when importing, in the File to import section, it will tell you if the backup file of your database is in the path /var/lib/phpMyAdmin/upload/, check here.

We are by your side every step of the way

Think about developing your online business; We will protect it compassionately

We are by your side every step of the way

+18054214518

7 days a week, 24 hours a day