Later on when you'll have done the alter table on every table to take
them all out of the single innodb tablespace/file (which won't
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
