Hi Baynaa, > I am trying to install syslog-ng + phpsyslogng ... It pipes all the > log messages to a pipe file mysql.pipe in sql statement format.
> But now the problem is mysql can not read from the pipe file. When > I give the command: > $ mysql -u sysloguser -p xxxx syslog < mysql.pipe Does the mysql command return, or hang? If it returns: You could test mysql reading from a pipe in a more controlled manner: shell> mkfifo sql.fifo shell> echo "INSERT INTO whatever_table ... " > sql.fifo and from another shell run your original command but reading from the new sql.fifo . If it hangs: Sounds like there's nothing to read from the pipe. What does 'cat mysql.pipe' print? HTH, Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
