Thanks! In that case, what can I do about the #sql-....frm files? Those must be related to the temp InnoDB tables. If I delete the .frm file, will InnoDB release the respective part of its tablespace when I start MySQL? If not, is the only choice to backup / restore the database?
-----Original Message----- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 8:52 AM To: [EMAIL PROTECTED] Subject: Re: #sql-... files "Sergei Skarupo" <[EMAIL PROTECTED]> wrote: > I see some files in the data dir with names like #sql-85d_4.MYI. Some of = > these are pretty old. Are these the temp tables that didn't get deleted = > properly? Is it OK to shut down the server and delete them? The answer is yes to both questions. :) -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]