[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