Restore Table on Slave Server

9:15 PM

1) Stop Slave on the Slave server

slave stop;

2) Will create a sql file of the table from the master server

mysqldump -u -p <database_Name> <table_Name> > <full_path><table_Name>.sql

3) Import the sql file to the slave server

scp <full_path><table_Name>.sql <slave IP>:<full_path>

4) Restore the table on the slave server

mysql -u -p <database_Name> < <full_path><table_Name>.sql

5) Start slave on the Slave server

slave start;

You Might Also Like

0 comments

Contact Form

Name

Email *

Message *

Translate

Wikipedia

Search results