Logging MySQL database on UNIX server

[johndayo]

Hi

I currently have the following command running as default which creates a log file for all dbs:

/server_path/safe_mysql --log-bin --user=mysql &

The file this produces is the default "hostname-bin.###"

I want this command to create a log file for a particular database (not all) and to give it a specific filename.

I tried the following, but it didn't work:

/server_path/safe_mysql --log-bin=filename binlog-do-db=db_name --user=mysql &

Any ideas would be well recieved. And if anyone has any actual examples rather than just giving me a link to the mysql.com documentation that would marvellous as well

Cheers