Howdy, I'm running a website (dah) and chose to store images in the database. What I didn't take into consideration however, was that some images would be larger than the amount of data a BLOB can store. Just didn't notice it while testing. (Stupid me). Currently, the site is stuck with some half displayed images, and some ppl are not happy about that. I wonder why...
So, my tactic was to change the datatype of the data column from blob to longblog - so that at least new images were to be stored in full. I ran the alter table query, some time later my phone rang - site down, harddisk full. Clearing out some old backups, moving some files around, when I'm done I'll be at around 6 gig free space. While the images table is probably some 15 gig in size (or, that's the size of the ibdata1 file). Would I be able to support the datatype change on this? And more generally; can somebody advice me on (maybe some other) strategy for changing the datatype? Thanks a lot! Wouter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
