Mike Bao <[EMAIL PROTECTED]> wrote: > Last week, the all tables in one database had been deleted, which is > second times since I upgrade my operation system from NT 4.0 to Server > 2003. Before that, they had been deleted many times. > > I just copied all table files to one database(one directory). They > will work normally. I don't know my operation is correct or not. And I > want to get more suggestions about mysql security, more details > better. > > Look forward to hearing from you, thanks lot.
To ask a correct question you should know half of the answer. :) For your case, do FLUSH TABLES and LOCK TABLES before taking the files snapshot. Or, even better, use mysqlhotcopy. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]