Hi,

I installed mysql-max-4.0 RPM in control center, can someone tell me where is mysql installed and where can I view the log file?

Another question, in the descrption it says mysql-max-4.0 support Innodb, but when I create table with "TYPE = InnoDB", it has error:
ERROR 1005: Can't create table './MySQLfast/log.frm' (errno: 150)

Does anyone know how can I get Innodb support?

Thank you in advance!

Anyone knows?

If you want a log file, you have to turn it on.
Stop the database with
/usr/local/bin/mysqld stop

The start it with
/usr/local/mysql --log[=file] &

This does affect performance and has been deprecated in mysql 5.
Using the binary log is probably your best bet.
This is explained in the documentation.
The manual is downloadable as a single or multiple html, or on line @
http://dev.mysql.com/doc/

ALSO

You dont need to create innodb tables, they are the default from version 4 onwards.

Type "which mysql" in a terminal

the answer should be

/usr/bin/mysql

Thank you MunterMan.

So far as I know, innodb tables is supported from MySQL 4, but if you want to create a innodb table, you should add "TYPE = InnoDB" explictly.

Do you know where MySQL installed in Mandrake by default, I mean where the data is, not the command in "/usr/bin"?

The data is in

/var/lib/mysql

create a database and you will see a directory appear here. Empty of course.

Though you need not bother with the location if you are using mysql as you can create load and drop
the databases from the mysql prompt.

It does beg the question if it is in the root and the database outgrows the root drives space should it not be in the larger drive space home?

This is a quote from the manual

In MySQL-4.0 you are not required to do anything specific to enable InnoDB tables.

so don't do anything.
Perhaps the question should be...
What is it you are trying to do that needs specific innodb support?

Thank you Barrys, I got it.
I need to import some data from textfile into Database and the file should be where
the database locates.

Yes, MunterMan
"In MySQL-4.0 you are not required to do anything specific to enable InnoDB tables."
because it is SUPPORTED by default.
BUT in order to CREATE a Innodb table(of course, use it later), you MUST specify and ENGINE = InnoDB or TYPE = InnoDB option in the table creation SQL statement.
check the manual here:http://dev.mysql.com/doc/mysql/en/Us...DB_tables.html

I found the problem why I get errors when creating Innodbs, it's about foreign key constraints(this problem
can be happen in MySQL4.0, not 4.1 or later)
check the manual here:http://dev.mysql.com/doc/mysql/en/In...nstraints.html

The reason why I use Innodb, you can find the Innodb's features here:
http://dev.mysql.com/doc/mysql/en/InnoDB_overview.html


Anyway, Thank you for all your help.
Good luck!