MySQL : How to copy MySQL database from one host to another via migration wizard

preview_player
Показать описание
MySQL : How to copy MySQL database from one host to another via migration wizard
******************************************************************************************
Online copy of data over network due to small db size.

Setup
*******
Host OS Mysql server version
192.168.1.51(linux2) OEL 6.5 8.0.19
192.168.1.61(linux3) OEL 6.5 8.0.19

MYSQL Workbench installed on local system
Linux2 and Linux3 are on VM and installed of course remotely.

User management :

Create 2 users so that they connect remotely to migrate data from one server to another.

User Creation on Linux3 ( Temporary and needs to delete if not required)
************************************************************************
mysql -u root -p

GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER ON *.* TO 'mysqlbackup61'@'192.168.1.9';
GRANT LOCK TABLES ON *.* TO 'mysqlbackup61'@'192.168.1.9';
grant all on *.* to 'mysqlbackup61'@'192.168.1.9';

Test connectivity from Localsystem via cmd.
*******************************************
mysql -u mysqlbackup61 -h 192.168.1.61 -p

User Creation on Linux2 ( Temporary and needs to delete if not required)
************************************************************************
mysql -u root -p

GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER ON *.* TO 'mysqlbackup51'@'192.168.1.9';
GRANT LOCK TABLES ON *.* TO 'mysqlbackup51'@'192.168.1.9';
grant all on *.* to 'mysqlbackup51'@'192.168.1.9';

Test connectivity from local system via cmd.
********************************************
mysql -u mysqlbackup51 -h 192.168.1.51 -p

Connect both mysql servers via MYSQL WORKBENCH
***********************************************
IP userid password

Start Migration wizard using source database server.
Рекомендации по теме
welcome to shbcf.ru