I have a similar mysql database both onine and in offline, with a few common tables in them. How can I synchronize both the databases to make sure the 'similar tables' in offline & online databases have the same data.
How can I do this with phpmyadmin.
if by "offline" you simply mean not in active use by the application then I'd recommend replication with simple replication filters for the few databases / tables you want to keep in sync.
If not, then a periodic pt-table-sync command should do it as well. This is from the percona-toolkit and can be run simply from cron.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.