How do I use a dynamic filename for an into outfile statement

2012-02-29 Thread Ed Patterson
Be kind, I am by no means any type of DB expert. I would like to eventually move this to a stored procedure but for now I am using the \. to fire it off. Here is what I have so far (generating a list of machines missing software) select last_logon.host_name_short from last_logon left join

innodb SuSE 9.2

2005-01-30 Thread Ed Patterson
I am trying to enable innodb tables. rcmysql returns failed when I uncomment any or all of the lines in the innodb section of the/etc/ my.cnf. So far I have not been able to locate the file that startup errors are logged to. Do I need to recompile MySQL to enable innodb tables, maybe I should

SuSE 9.2 Professional, Runlevel editor via telnet innodb

2005-01-29 Thread Ed Patterson
Greetings, I need help with a few things: First I am looking for a way to shutdown and or restart MySQL via telnet. mysqld -restart returns chroot: No such file or directory Aborting mysqld -shutdown returns: Can't start server: Bind on TCP/IP port: Address already in use Do you already have