BinLog and BLOBS (LOAD_FILE)
OK...when i tried to use replication from a DB that used LOAD_FILE() to insert into blobs it failed on the slave since the file was not available locally. So i resorted to doing nightly mysqldumps.
Now my databases are getting huge! And mysqldumps are not so much fun. Questions...
1] If i copied the data directory and restarted the server on a backup server...would this work?
2] Do the binlogs only contain the SQL statements...like the way it works for replication?
3] Anyway to replicate this architecture?
4] Can I put large binaries DIRECTLY in the INSERT statement and get rid of LOAD_FILE?
Subject
Views
Written By
Posted
BinLog and BLOBS (LOAD_FILE)
3278
March 11, 2006 02:43PM
1550
March 12, 2006 04:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.