replication and lower_case_table_names

replication and lower_case_table_names

am 03.11.2005 19:58:26 von Daniel da Veiga

Greetings,

I had this master running on Linux, version 4.1.14, all working fine,
using the lower_case_table_names=3D1 variable, and a server running on
win32 that I plan on using as a slave, well, I accidently forgot to
set the lower_case_table_names at the slave and, started it. At this
point you all know what happened, at the first update, the damn table
had an uppercase name, and it all failed miserably with an error shown
with the "show slave status".

As I got the error after some time of the slave running, I want to
know if there's a way to be SURE that the slave didn't miss the
updates during the time I was checking it. Its running OK now, but is
there a command that I can use to check if the slave tables are all
exavt clones of the master's tables?

Thanks for your time,

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org