following the instruction at
I copied my 1.3 dB and called it magento14, got the code for 1.4 and going through the installer yields this :
error: 1005 Can’t create table ‘./magento14/#sql-7ae4_84d.frm’
That seems like a *very* strange name for a table, obviously ..
Most of the 1005 threads I’m seeing seem to be fixed with “ALTER TABLE core_store ENGINE=INNODB” and friends, but in those cases the table name is always something sensible ..