No, no, no, when I said trash it I didnt mean delete it!
The shared tablespace still contains the table definitions, thus it still needs to exist. Shrinking it is a really complicate matter, if its not really big I suggest you to leave it just like that. _____ Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Anne Inviato: mercoledì 1 agosto 2007 16.46 A: DBMail mailinglist Oggetto: Re: R: R: [Dbmail] Table dbmail_messages is full Later on when youll have done the alter table on every table to take them all out of the single innodb tablespace/file (which wont decrease when tables will be getting out of it), you can just trash it and manually reclaim all your disk space. Andrea, I've tested it. Don't forget to: - check my.cnf that you don't have innodb_data_file_path = .... left The dbmail tables were already InnoDB. I optimized them so the tablespaces were created. I stopped Mysql, renamed ibdata1, removed the ib_ logfiles, started Mysql A new 10 Mb ibdata1 is created. When I browse the database (using SQLyog), all the tables are missing. Mysql logs this error for each table: 070801 16:17:14070801 16:17:14 [ERROR] Cannot find table dbmail/dbmail_acl from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html how you can resolve the problem. Did you have this problem? Anne
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
