I've always relied on mysqldump for backups. I don't know whether that would work if you have mime type data in your tables... The newest release of MySQL is supposed to have some new transaction recovery features, and, if I remember correctly, you can use something other than ISAM tables for the data? I'm no expert, but if you're going to store binary data in tables, you may need to write your own table backup and recovery scripts. If you can afford to stop the server, it would be easy to "back-up everything", but if you want to backup your server without stopping the mysql daemon I'd not rely on mysqldump. At 12:45 PM 2/23/2001 -0800, "Bob Crandell" <[EMAIL PROTECTED]> wrote: >This is good information. This is also why the first question a >tech asks is ,"When was your last backup." It's a good idea to >keep anything you care about in 2 or more places. > >Thanks > >>>> [EMAIL PROTECTED] 2/23/2001 12:34:51 PM >>> >It only happened once to us, but all the images were broken and >unreadable. We had to rely on a backup of the database and >overwrite >the database files. Once we did that, the images worked again. >We >never figured out what happened or why, but it made me wary >enough to >start using the alternative of putting the image in a separate >directory and using some kind of naming link thru the database. > >It was with MySQL 3.22.x > >> On 20010223.1219, Bob Crandell said ... >> >> Data corruption? How bad? Do you know what is causing the >> corruption? Is it MySQL or any database? Is it something >that >> better error checking would prevent? >> >> Thanks guys. I'm learning a lot here. >> >> >> >>> [EMAIL PROTECTED] 2/23/2001 9:10:31 AM >>> >> This might not be what your asking for, but I've done this >> before so >> maybe it will help. >> >> I've also encountered data corruption when using binary info >in >> a >> database. I would recommend a file upload type thing in PHP >> that >> writes the image to a certain directory using the unique >table >> key, >> the just calling it from the page with >> <? echo "<img src=\"$uniquekey.jpg\">"; ?> >> or something. >
