Re: access data on a backup mount
AFAIK, phpMyAdmin cannot browse two servers on one page, neither can WorkBench.
One solution is to write a PHP (or Python, or ...) script that connects to each of the two servers, sucks up required data, compares and updates as required.
Another solution is to use the Federated storage engine, see that topic in the manual.
A less direct method is to mysqldump from one server, import that to a new db in the other, then compare &c as desired. To update the server from which you exported & imported, reverse the process.
Subject
Written By
Posted
December 01, 2016 01:34PM
Re: access data on a backup mount
December 01, 2016 01:53PM
December 01, 2016 02:09PM
December 01, 2016 02:15PM
December 01, 2016 02:19PM
December 01, 2016 02:26PM
December 01, 2016 02:27PM
December 01, 2016 02:31PM
December 01, 2016 02:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.