LOL. What is your definition of trashing??
Technically it means moving to your trash bin. You have the option to
restore it. That's exactly what I did by renaming the file.
Do you really think I didn't read the documentation first? I read the
notes about the shared table space.
That made me extra suspicious whether *trashing* the shared ibdata file
would actually work. So I renamed it instead of deleting it.
Did you manage to shrink the file? Mine is big. That's the whole point.
I want to get rid of the big file (15 Gb) which is 66% empty.
One way is to restore a backup. I thought you found another way. But did
you really?
Anne
No, no, no, when I said trash it I didn't 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
it's 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 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
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
