Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Does mysqldump backs up BLOB fields of tables?

    I would like to make my backups of MySQL using mysqldump.
    My question is: what happens if I have blob fields?
    does mysqldump can dump the data on those fields correctly
    in a plain text sql script file? I ask this because
    I have blob fields containing images and other binary
    information (not plain text).

    Thanks a lot in advance.

  2. #2
    Join Date
    Jul 2004
    Dundee, Scotland
    Yes they are dumped correctly with all special characters qouted etc.

    as per a google search which found this:

    I especially like "mysqldump is THE backup software supplied with mysql and if it couldn't handle to take backup of some of the column types then it would be very useless."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts