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
.013' at position 6867
I have done mysqladmin start-slave and it does not work, The master is a
Linux and the slave is Windows 2000 pro.
Slave
Ver Server version 3.23.40-nt
#This File was made using the WinMySQLAdmin 1.2 Tool
#8/14/2001 11:42:25 PM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/mysql
#bind-address=10.100.4.105
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
master-host=10.100.4,102
master-user=repl1
master-password=eatme
master-port=3306
server-id=2
replicate-do-db=mold_counter_db
replicate-do-db=mold_db
peplicate-do-db=vpopmail
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=repl1
password=eatme
QueryInterval=10
Master
Ver Server version 3.23.40-log
# Example mysql config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld deamon
# doesn't use much resources.
#
# You can copy this file to
# /etc/mf.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/var) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer=16K
set-variable = max_allowed_packet=1M
set-variable = thread_stack=64K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_length=2K
server-id = 1
log-bin
# Uncomment the following if you want to log updates
#log-bin
# Uncomment the following if you are NOT using BDB tables
#skip-bdb
# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:100M
#innodb_data_home_dir = /usr/local/var/
#innodb_log_group_home_dir = /usr/local/var/
#innodb_log_arch_dir = /usr/local/var/
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M
[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M
[mysqlhotcopy]
interactive-timeout
---------------------------------------------------------------------
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
