Error 2013

[oldandgrey]

I have just downloaded XAMPP for Linux 1.4.12 and installed it on Suse 9.1.

I loaded up some tables (no data) and tried to use the ALTER TABLE command to change them to innodb using phpMyAdmin and an SQL statement. This did not appear to have any effect so I downloaded Mysql-administrator from the mysql site (RPM), but now executing the same command in it gives -

Error executing SQL commands to update table.
MySQL Error Nr. 2013
Lost connection to MySQL server during query

Can anyone point me in the right direction.

thanks

[oldandgrey]

Reinstalled over installation and the problem went away. However now I find that phpMyAdmin only allows me heap,merge and myisam table types. What happened to the innodb?

[Wiedmann]

What happened to the innodb?

You must enable InnoDB in the file "my.cnf":

Code: Select all

[mysqld]
#skip-innodb

(prepend a "#" in front of the line)