CReate innodb database with api

[depixelfabriek]

Hi all,

I would like to know if it possible to create (or alter) a (mysql) database using the innoDB storage engine instead of the (default) MyISAM engine (using the direct admin API).

Maybe there is a other way to change or create these storage engine setting, for example using some php scripting, i am just looking for an solution, so of course i am open for alternatives..

Thanks anyway,

Sebastian

 

[hehachris]

AFAIK mysql is not compiled with innodb support by default.

 

[zEitEr]

Does it mean, that directadmin doesn't support InnoDB?

I mean "Create new Database", "Check", "Repair" and "Optimize" functions via Directadmin.

P.S. It's not a problem to re-compile MySQL with InnoDB for me.

 

[floyd]

DirectAdmin does not have anything to do with mysql.

I mean "Check", "Repair" and "Optimize" functions via Directadmin.

DirectAdmin does not perform these functions at all regardless of what the storage engine is, MyISAM or InnoDB.

DirectAdmin does create the database but this has nothing to do with storage engines for individual tables since DA does not create the tables.

 

[zEitEr]

Ok, that's clear about creating a database.

Directadmin does allow to check, repair and optimize tables of selected databases (see http://your-server:2222/CMD_DB?DOMAIN=your-domain).

Does directadmin use mysqladmin for optimizing tables? And myisamchk for checking and reparing? So if it's true, then how about InnoDB?

 

[floyd]

Directadmin does allow to check, repair and optimize tables of selected databases

I did not see that before. Maybe its fairly new. I don't use DA to create databases very often.

Does directadmin use mysqladmin for optimizing tables? And myisamchk for checking and reparing? So if it's true, then how about InnoDB?

The main thing I remember is that you cannot have skip-innodb in my.cnf.
http://www.directadmin.com/forum/showthread.php?t=29297

 

[scsi]

Directadmin does allow to check, repair and optimize tables of selected databases

Yes it does!

http://directadmin.com/features.php?id=879

 

[zEitEr]

Ok, I will test it myself. I've got reinstalled mysql from sources with InnoDB

 

[floyd]

Yes it does!

http://directadmin.com/features.php?id=879

I already admitted it was there. No need to rub my nose in it. As I said it would be easy for me to miss since I don't use it. The last time I used it, which was before May 26, 2008, those features were not there . Like I said it must be fairly new. Now that I am old 9 months does not seem that long ago.

 

[zEitEr]

Ok, I will test it myself. I've got reinstalled mysql from sources with InnoDB

That's seems to me working fine. At least no error messages have occured while/after checking and optimizing InnoDB tables in the selected database.

Repair failed with message:

The storage engine for the table doesn't support repair

 

[floyd]

The storage engine for the table doesn't support repair

That is correct for innodb.