phpmyadmin

[Luftwaffe]

Hi,

Why doesn't phpadmin display InnoDB as one of the type of tables that can be created. However on another server this option is enabled. Is there a speical way to enable users to creare InnoDB tables? Some phpmyadmin have this option and some don't.

 

[infinityws]

I'd like to know the same thing.

 

[mickalo]

Originally posted by Luftwaffe
Hi,

Why doesn't phpadmin display InnoDB as one of the type of tables that can be created. However on another server this option is enabled. Is there a speical way to enable users to creare InnoDB tables? Some phpmyadmin have this option and some don't.

what version of MySQL are you running ? Is it disabled in the my.cnf file ??

Mickalo

 

[infinityws]

I'm running 3.x. Whatever comes with cpanels basic install.

 

[mickalo]

Originally posted by infinityws
I'm running 3.x. Whatever comes with cpanels basic install.

then you need to update to Version 4.0.18 or .20 which comes with InnoDB enabled by default. Version 3.x+ doesn't come w/InnoDB enabled with the standard RPM's

Mickalo

 

[infinityws]

Can it be installed on 3.x on a cpanel server?
Is there information on how to do this?

 

[mickalo]

Originally posted by infinityws
Can it be installed on 3.x on a cpanel server?
Is there information on how to do this?

Your better off upgrading to the 4.0.18 or .20 which is now the most stable version released.

If you can get the 3.x RPM's for your system, use the mysql-max-server RPM which should have InnoDB enabled by default. If your positive your running version 3.x on your system, in the WHM you can do a "tweak setting" to have the next update go with version 4.x instead of 3.x.

Mickalo

 

[infinityws]

Well I'm just afraid that it might break some scripts...have you had any issues?

 

[mickalo]

Originally posted by infinityws
Well I'm just afraid that it might break some scripts...have you had any issues?

No issues that I'm aware of. if you review the Mysql 3.x to 4.x Upgrade from MySQL docs, the only thing to be concerned about is the change in the user privilege setup.

Mickalo