Hi, Thanks for your reply.
I've only just moved all tables to there own table space so that I can put certain databases on different disks. Right now my shared tablespace does not hold any databases. I'm aware that I still need the shared table space but I don't need 200gb now, I just want to decrease it down to 10Gb. It seems a bit daft that I still have to dump all tables even when they are in their own tablespace. I guess this is because the table definitions are still stored in the shared space. Marvin. -----Original Message----- From: Ware Adams [mailto:[EMAIL PROTECTED] Sent: 25 July 2005 12:53 To: Marvin Wright Cc: mysql@lists.mysql.com Subject: Re: Correct way to use innodb_file_per_table? On Jul 25, 2005, at 5:47 AM, Marvin Wright wrote: > You recommend to dump tables before changing then re-import them back. > But if all databases are in there own tablespace I should need to do > this dump should I ? Unfortunately I think that's your only option to create a new table space. One way to avoid that and not waste the space might be to move some large tables into the shared table space and use file-per- table for new tables. You'd just switch file-per-table off, run ALTER TABLE tablename TYPE=INNODB to move the table into the shared space then switch file-per-table on. This won't work for a lot of table structures, but it might be a way for you to use the space. > I want to reduce it to about 10gb, that should be enough for all its > temporary storage and logs. You probably know this, but regardless of whether you use file-per- table or not you still need the separate InnoDB log files. --Ware ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
