Results 1 to 10 of 10

Thread: MySQL-binary blobs

  1. #1

    MySQL-binary blobs

    I need to update a database for a client which uses MySQL. My problem is that the descriptions for the products in the database are blobs that are in binary format ... and using phpMyAdmin I don't seem to be able to change their content. How would I go about doing this either vua phpMyAdmin, the command line, or through another tool.

  2. #2

    Re:MySQL-binary blobs

    I should note the database is on a diffrent box/network than what I am on and I access it via ssh/ftp/phpMyAdmin

  3. #3

    Re:MySQL-binary blobs

    There has to be a mysql freak on this board :P

  4. #4

    Re:MySQL-binary blobs

    I probably can't help but how do you display their blobs if it is in binary format? Because if their is a third party program used to display the binary info then maybe this program have an edit function(??????)

    OR

    I would assume that you would need to have the sources and know how they encoded/compiled the blobs and then edit the old sources/create new ones and re-encode/re-compile them?? Sorry like I said I'm probably not gonna be able to help but just a thought.

  5. #5

    Re:MySQL-binary blobs

    [quote author=Izan Seth link=board=2;threadid=5683;start=0#55283 date=1039324398]
    I probably can't help but how do you display their blobs if it is in binary format? Because if their is a third party program used to display the binary info then maybe this program have an edit function(??????)
    [/quote]

    The binary blob is just a long string of text/html that describes products in the database. AFAIK it shows the blob as is on the site but according to the database it's binary and thus I am not sure how to edit it (the front end I use says binary - do not edit and doesn't allow me to see it)

    OR

    I would assume that you would need to have the sources and know how they encoded/compiled the blobs and then edit the old sources/create new ones and re-encode/re-compile them?? Sorry like I said I'm probably not gonna be able to help but just a thought.
    It's inputed as type blob function binary (or vice versa) so when I look at the original SQL table stuff it's in plain text/html.

  6. #6

    Re:MySQL-binary blobs

    Well I'm glad that I at least attempted to help, but it is clear to me that you know WAY MORE about MySQL than I do! The only other thing I can think of is that they didn't give your user permission to change that column of data... but again I had no idea that there was a binary data type good way to keep things hidden from people.

  7. #7

    Re:MySQL-binary blobs

    [quote author=Izan Seth link=board=2;threadid=5683;start=0#55309 date=1039332697]
    The only other thing I can think of is that they didn't give your user permission to change that column of data... but again I had no idea that there was a binary data type good way to keep things hidden from people.
    [/quote]

    I have user permissions to change anything I just have no clue how to change a binary blob. Thanks for responding!

  8. #8
    Junior Member
    Join Date
    Jan 2002
    Posts
    89

    Re:MySQL-binary blobs

    when you say you want to change it....

    do you mean that you are upgrading to a newer version of mysql or what? i'm a little confused as to what exactly it is you are trying to do.

    but if you're upgrading you prolly don't have to worry about anything, just keep the database the same.

    in any case, if you do something you're not too sure about, either play with it in a test db, or back up with mysqldump or however you like to do it.

  9. #9
    Junior Member
    Join Date
    Jan 2002
    Posts
    89

    Re:MySQL-binary blobs

    AHA! having re-read your post i am no longer confused

    but i now see that i can offer no assistance

    you might be able to change the data type through the command line client, but not too sure about that.

  10. #10

    Re:MySQL-binary blobs

    Yup, command line client was the way to do it. phpMyAdmin (at least the version my server is using) doesn't support binary blob editing.

Similar Threads

  1. Looking for cupsd binary
    By Compunuts in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 05-14-2006, 02:43 AM
  2. Binary Information
    By Ashcrow in forum Linux - General Topics
    Replies: 3
    Last Post: 07-24-2002, 03:37 PM
  3. Binary Clock
    By gmoreno in forum General Chat
    Replies: 8
    Last Post: 06-01-2002, 02:46 PM
  4. binary or source ?
    By boblucci in forum Linux - General Topics
    Replies: 6
    Last Post: 01-22-2002, 08:26 PM
  5. Reading binary data in C++
    By t048 in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 12-21-2001, 03:26 PM

Bookmarks

Posting Permissions

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