On Thu, Aug 16, 2001 at 08:56:33PM -0700, Lists Servers Email wrote:
>
> Does any know how to fix this database replication problem.
>
> Last Lines from Err File
>
> 010815 21:38:55 Slave thread exiting, replication stopped in log
> 'salem-bin.013' at position 6867
>
> 010815 21:38:55 Error running query, slave aborted. Fix the problem, and
> re-start the slave thread with "mysqladmin start-slave". We stopped at log
> 'salem-bin.013' position 6867
>
> 010815 21:38:55 Slave: error running query 'UPDATE themes SET
> textcolor='#00000a' WHERE theme_id = 2 AND theme_name = 'Ocean' AND bgcolor
> = '#FFFFFF' AND textcolor = '#000000' AND color1 = '#CCCCCC' AND color2 =
> '#9BB6DA' AND table_bgcolor = '#000000' AND header_image =
> 'images/toxicmold1.gif' AND newtopic_image = 'images/new topic.gif' AND
> reply_image = 'images/reply.gif' AND linkcolor = '#011001' AND vlinkcolor =
> '#2100cc' AND theme_default = 0 AND fontface = 'sans-serif' AND fontsize1 =
> '1' AND fontsize2 = '2' AND fontsize3 = '-2' AND fontsize4 = '+1' AND
> tablewidth = '95%' AND replylocked_image = 'images/reply_locked-dark.jpg''
>
> ERROR: 1146 Table 'mold_db.themes' doesn't exist
Make sure that all the tables and databases which should be replicated
actually exist on the slave?
How did you setup your inital replication?
Perhaps you can use mysqlsnapshot
http://jeremy.zawodny.com/mysql/mysqlsnapshot/
to reset things and be sure that it's correct?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 3 days, processed 34,014,583 queries (109/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
