Grover, I am carbon copying this to [EMAIL PROTECTED]
----- Original Message ----- From: "Grover Cussi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 01, 2003 2:16 AM Subject: Problems with innodb > Hello! > > I have various databases, one has a table with more than 3 millions of > registers, and other has 250 MB, 50MB, all of the innodb type. My ibdata1 > grow to more than 1 G, well I do not want my big database, I drop the > database but the size of the ibdata continues with the same size, what can > I do?? I waant my ibdata with only the small databases, but I want with > the correct size not 1 G!, > > How can restore to minium size the ibdata file? without making mysqldump > of all the databases and creating a new one, if it is posible?? You have to dump your tables and recreate the whole InnoDB tablespace and log files. Support for multiple tablespaces in InnoDB is planned. You would have an option to store every table in its own tablespace. > Grover Cussi > System Administrator > www.cs.umss.edu.bo Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- 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
