On Tue, 13 Aug 2002, Mauricio Sthandier R. wrote: > 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 ?
Mauricio, putting binary data into blobs does not corrupt your tables. BLOBs are made to store binary data in them. Data corruption is caused by hardware failure or bugs in your OS. > (Another question... should I zip and copy the database files, or better I > do a mysqldump ?... which is better as backup ?) Backups are always a good idea. Have a look at the `mysqlhotcopy' Perl script. > 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. I prefer to backup string data with mysqldump because it's readable with any editor. Regards, Thomas --------------------------------------------------------------------- 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
