sergei, no i meant loading it up from raw data again. in the sense, i empty the database, then i have a script which takes a directory full of files and reads them into the database. each time i do that the database ends up corrupted.
is there any way to figure out where the corruption is? is it the files? different character sets (some are italian, some english, etc)? or maybe something that my script is doing? thanks, marko Quoting Sergei Golubchik <[EMAIL PROTECTED]>: > Hi! > > On Jul 26, Marko Djukic wrote: > > Sergei, > > > > finally managed to try out this solution, resolved my out of disk > > space problem... > > > > and it works now! just as you found out the boolean searches work fine > > now... > > > > any idea what causes the corruption in the first place? different > > charsets? because this happens every time i load up the database from > > zero. it's not a horrible thing, but still a bit weird having to tell > > customers that they need to repair the database each time they load it > > up. > > Strange. > I dumped the whole table with mysqldump, and loaded it up again. > No bug - works fine for me. > > Regards, > Sergei > > -- > MySQL Development Team > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > <___/ > --------------------------------------------------------------------- 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
