List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:May 1 1999 10:22pm
Subject:export of blobs in MySQL dump
View as plain text  
>>>>> "Georg" == Georg Cantor <georgcantor@stripped> writes:

Georg> The MySQL manual states that LOAD DATA INFILE, SELECT DATA INFILE do not
Georg> support blobs, but the exportSQL library, for use with MS Access, appeared
Georg> able to export Access graphic blobs.

Hi!

LOAD DATA INFILE doesn't support BLOBS for FIXED size rows;  (Using
BLOBS on FIXED size rows are not that common :).  If you have some
delimiter between your columns, BLOBS will work just fine.

Georg> Does that require alternate escape sequences and delimiters?
 
You have to escape the delimiter and the escape character

Georg> Will the attempt to load the data into Access or vice versa be problematic?

I don't think so.

Georg> Will it break down later?

See above.

Georg> ---------------------------------------------------------------------
Georg> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
Georg> posting. To request this thread, e-mail mysql-thread2713@stripped

Regards,
Monty
Thread
export of blobs in MySQL dumpGeorg Cantor1 May
  • export of blobs in MySQL dumpMichael Widenius2 May