[SMS]

[baboo]

I stopped mysql and then uncommented innodb. Now when I try to start I get the following:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

Here was the problem:

'innodb_log_arch_dir=/var/lib/mysql/'

fixed now

thanks

[gerasimos_h]

You can also switch to MyISAM as the default storage engine instead of uncomment lines.
Just add in /etc/my.cnf

[baboo]

thanks will take a look.

[baboo]

I need the transactional capability of INNODB for financial transactions.

thanks

[baboo]

so is there a way to enable innodb without the dreaded mysql.sock error? Most of my databases require innodb.

[gerasimos_h]

If you want to enable innodb, the minimum option in /etc/my.cnf is "innodb_data_file_path =" e.g.
innodb_data_file_path = ibdata1
innodb_data_file_path = ibdata1:10M:autoextend
innodb_data_file_path = ibdata1:10M:autoextend:max:800M

Can you post your innodb settings?


gerasimos_h

[baboo]

all I did was uncomment the innodb options in my.cnf. I did not modify them.

[gerasimos_h]

What /var/lib/mysql/yourserver.err says?

Also look at /etc/mysql/ examples (large, huge) and follow instructions.

[baboo]

I have no errors right now. As posted above, I fixed it. The problem was the error stated above:

'innodb_log_arch_dir=/var/lib/mysql/'

Once I commented that out, it worked. So, I gather from your response that if I had left that commented, then there would not have been a problem.

[gerasimos_h]

Well that my.cnf was from mysql-5.0.x days so ti might contain deprecated options as
innodb_log_arch_dir , I just try it and get