"starofframe" <[EMAIL PROTECTED]> wrote: > Hi, > > I wanna ask about InnoDB... > > I've been trying InnoDB for sometimes and I found out one thing weird that is : > > "When I make an InnoDB tables and filled it with some records ..it took about 2 Mb of > file's capacities.. > but when I delete all the records... the file's capabilities just still 2 Mb... > If I'm not wrong, Micro Access has such problem too but we can use compact database > to > refresh it..." > > So how to compact innoDB databases???
There is no command in MySQL that shrinks size of the InnoDB data file. You can dump your tables, recreate InnoDB table space and then restore tables. -- 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]