The test box doesn't have incoming data when he's taking the snapshot. Lock
the production database while taking snapshot and setting up replication or
you will have this problem. I've tried all the methods (snapshot, dump,
hotcopy etc) and the issue is always the same. You can't bootstrap
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
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
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
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
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
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
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
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