Transfer database between 2 host using PHPMyAdmin
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
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.
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.
Related Questions
How to stay updated in the Metaverse space?
How many email accounts can be created in CPanel hosting?
Can I restore a backup if I switch to another hosting provider?
