If it worked on your test box, but not in production, what is different about those 2 boxes? Common sense says "If it worked on one box but not another, it's not the software, but a difference between the 2 boxes."
And you can always file a bug report with MySQL or get a consultant (through MySQL AB or not) to help you. This list isn't the entirety of knowledge out there on MySQL, although it's pretty good. -Sheeri On 5/29/06, Bgs <[EMAIL PROTECTED]> wrote:
It seems nobody has a clue here :( I've given up with MySQL replication... Hope it will work in 5.1 ... BTW: Any official info or estimate about the production release? Bgs wrote: > Nope... pure myisam... > > sheeri kritzer wrote: > >> yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA >> FROM MASTER only works for MYISAM. >> >> http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html >> >> -Sheeri >> >> On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote: >> >>> Bgs wrote: >>> > >>> > No ideas? >>> > >>> > I tried playing around with read/write timeouts (even thought the >>> > replication is fast), all size limits are greater than the whole >>> > replicated db. The last table with accesses MYD and zero size is a >>> small >>> > one (a couple of dozens kBs). >>> > >>> > Bgs wrote: >>> > >>> >> >>> >> Greetings, >>> >> >>> >> I played around with load data from master (ldfm) and it worked fine >>> >> in test environment. Now I want to replicate our actual db to a >>> slave. >>> >> When I issue the ldfm command, it starts the replication. I get Query >>> >> OK, but only about 5% of the db is replicated. Apparently all tables >>> >> that are on the slave in the end are exact copies of the master >>> >> tables, but most MYD files are zero sized.... >>> >> >>> >> >>> >> Any ideas? >>> >> >>> >> Thanks in advance >>> >> Bgs >>> >> >>> >> >>> > >>> >>> Hi - >>> >>> Which storage engine are you using for the tables or database which >>> you're trying to replicate? >>> >>> Thanks >>> -dant >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >>> >>> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]