up vote 0 down vote favorite
share [g+] share [fb]

I'm trying to change the logsize for my innoDB tablespace, and follows this instruction I found here:

http://dev.mysql.com/doc/refman/5.0/en/innodb-data-log-reconfiguration.html

(the last part, about log size).

I have seen the same description elsewhere, but when I restart my server, I get the error

[ERROR] Cannot find table dbname/tablename from the internal data dictionary

For every table in my dataspace.

Anyone has any suggestion on how I can successfully change the logsize without dumping and restoring all data? We're talking around 20gb of data which I don't really wanna do this procedure for...

link|improve this question
71% accept rate
Can you elaborate exactly what you did? you still have ibdata* and the .frms for the tables? – 3molo Nov 17 '10 at 11:38
My bad, It wasn't at all all tables, that was related to another problem I had before I didn't remove the old log files. It was one single table that was missing from the data-file, but hat it's .frm still in the filesystem. – jishi Nov 17 '10 at 13:12
So it's solved now? :-) – 3molo Nov 21 '10 at 7:46
Yes, it wasn't really a problem, it was just me making assumptions to early :) – jishi Nov 22 '10 at 14:52
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.