MySQL Forums
Forum List  »  Replication

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication - sync slave table with master
11097
April 26, 2005 11:20AM


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.