Hello,
I am currently, restoring a 2.8G file dump of a MySQl backend on a 2.10.10
sequoia platform.
The process is very long at the end of the restoration because of the
setting of the auto_increment variable on each tables (I have 3 big
tables).
the "alter table" statement result in a copy of the whole table in a
temporary table ('copy to tmp table' in the state column of the
processlist) ... so with a big table it could be very long.
I read this bug
http://www.mail-archive.com/sequoia@lists.forge.continuent.org/msg01077.html
about this problem.
Is it possible for you just to insert the "alter table" after each "create
table" instead of after the "insert" statements at the end of the dump
script ?
Cheers,
--
Damien
_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
http://forge.continuent.org/mailman/listinfo/sequoia
