Todd you need to look at how InnoDB is configured and learn a bit about how Innodb uses and manages its tablespace. if you look in the my.ini options file you should see how innodb is set up for your installation. Take a look at the link below that explains how InnoDB can be set up:
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html Regards Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services Todd Smith" <[EMAIL PROTECTED]> wrote: > Hello > > I have inherited an INNODB database. I am new to MySQL and may not be > describing my problem correctly so any suggestions or questions are welcome. > I have data files named ib_data_00 through ib_data_14 all of which are 2.0G. > I also have ib_data_15 which is 26G. I am receiving errors saying that the > innodb space is full. I know that the space isn't full because it is still > working. I am wondering how I can get a true size of the space used. I > would like to get back into the 2G segments. Any suggestions. > > Todd > Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]