[TYPO3-english] Best practice migrating mysql 4.1.x -> 5.0.x with mixed innodb myisam tables

Bjoern Pedersen bjoern.pedersen at frm2.tum.de
Mon Jan 10 13:21:37 CET 2011


Am 10.01.2011 11:35, schrieb Götz Reinicke - IT-Koordinator:
> Hi,
> 
> the dump contains 'CREATE TABLE xxx (.... ) ENGINE=InnoDB'
> 
> I did not set a special path on both servers. All ibdata and logfiel are
> in the same directory.
> 
> But I do use differet config options in the old and new my.cnf file.
> 
> Some are defaults.
> 
> old server:
> innodb_buffer_pool_size=920M
> 
> new server:
> innodb_data_file_path = ibdata1:30M:autoextend
> innodb_flush_log_at_trx_commit=1
> 
> Regards. Götz
> 
So the problem really is a MYSQL problem. Can you create InnoDB-tables
at all?

Björn


More information about the TYPO3-english mailing list