Replication - sync slave table with master
Posted by:
Milo
Date: April 26, 2005 11:20AM
Hi,
I am using MySQL 4.1.8a on Debian Linux.
I wonder what's the best practice to sync a replicated slave table with the master table. I have a table with 8000 rows in the master table but only 7000 rows in the slave table. How can I sync the slave table? I realize the situation should not occur, but if it does... ;-)
I thought this should do it:
use <database>
load data from master;
But I get the error:
ERROR 1219 (HY000): Error running query on master: Access denied; you
need the RELOAD privilege for this operation
But in the user table I have (on both master and slave):
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Reload_priv: Y
Shutdown_priv: Y
Process_priv: Y
File_priv: Y
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
Show_db_priv: Y
Super_priv: Y
Create_tmp_table_priv: Y
Lock_tables_priv: Y
Execute_priv: Y
Repl_slave_priv: Y
Repl_client_priv: Y
Best regards
Subject
Views
Written By
Posted
Replication - sync slave table with master
11005
April 26, 2005 11:20AM
4599
April 26, 2005 06:09PM
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.