I store images in the database for a few reasons. I do make sure they are in their own table though and link to another table via a key so I would have tbllisting with all the textual data information on a listing and then tbllisting_image which is just the primary key linking to tbllisting and a blob column. That way if you don't need an image at a certain time the DB does not have to deal with it.
I would use mysqldump over a zip of the databases. MySQL's bin files are not portable an may not work on other systems. mysqldump creates scripts that you can execute against a database. And it's human readable. Serge. ----- Original Message ----- From: "Mauricio Sthandier R." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 9:35 AM Subject: BLOBs and DataBase... is it likely to corrupt it with them ? > I'm working with BLOBs in mySQL and Visual Basic... i read that storing > images in the database has worst performance than the filesystem, but anyway > I'm planning to store them in MediumBlobs. > My specific problem is that I don't know if I'm risking too much the > database, perhaps the chance it will get corrupt is likely, or perhaps it > almost never happens. > > With a good backup plan... no problem ? > > (Another question... should I zip and copy the database files, or better I > do a mysqldump ?... which is better as backup ?) > > I'm working in Windows 2000, and I will use the BLOBs alone in their tables > with and id, not with the other string or numeric data. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
