This one time, at band camp, "Richard Lynch" <ceo@xxxxxxxxx> wrote: > I'm more concerned about the disaster recovery of a DB from a crashed > hard drive, which has been cluttered up with binary data, making data > recovery. One of the greatest benifits of binary DB storage is a single point of back up mysqldump db_name > backup.sql -u username -p It really is as simple as that and no need to bother about referential integrity when rebuilding, simple mysql db_name < back.sql -u username -p How much easier does it get? > Then your field storage size has to be large enough. LONGBLOB > Given the number of posts here in PHP-General alone, of people getting > tripped up by these things, I have concluded that cramming images into > the DB is far more trouble than it is worth. > > It *seems* like a Good Idea until you actually do it for awhile, and > then run into all these snags. Oddly enough, I have never run into them. Nor has terraserver which stores hundreds of thousands of images in its db, although not mysql. Kevin -- "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
