antispam, Tuesday, September 24, 2002, 8:30:35 PM, you wrote: aafdn> I dont know what exactly happened but suddenly one tables just went back 10 days.. it only has 10 days back information.. please help me.. what happened with mysql ?? how can i retrieve those aafdn> information...
I also don't know what _exactly_ happened with your table, but I'm sure MySQL can't delete data by itself. There are a lot of possible causes, like somebody deleted data from the table, or restore table from backup that was made 10 days ago, or somebody runs MySQL server with another datadir that contains old table and so on ... If logs is turned on, check it if there was any DELETE on this table. Do you make table backups? If so, restore table from last backup. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
