Hi Jen,
Jen mlists wrote:
Hello members,
When I do mysql replication,I didn't replicate the system's "mysql"
database.
but someone updated the mysql db in master,then I got the errors on slave.
How to resolve it?Do I need to always replicate mysql db?thanks.
ERROR: 1146 Table 'mysql.mobilearea' doesn't exist
070717 15:23:46 Slave: Error 'Table 'mysql.mobilearea' doesn't exist'
on query. Default database: ''. Query: 'DELETE FROM
`mysql`.`mobilearea`', Error_code: 1146
070717 15:23:46 Error running query, slave SQL thread aborted. Fix
the problem, and restart the slave SQL thread with "SLAVE START". We
stopped at log 'DB3-bin.185' position 39946
You can avoid replicating it, but the rules are complex. You should be careful to read
this section of the manual:
http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html
Some of the replication options don't do what you think they will from their
names.
Cheers
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
