Binary Logging stopping mysql start
I'm new to mysql and after getting installed and working successfully on Linux I wanted to add in a backup solution to protect my data.
I know how to backup a database using the command mysqldump, but I wanted to add in binary logging, so I can get my database back to exactly where it was if something goes pear shaped.
If I add this to my.cnf file
and restart mysql I get the following errors in the localhost.err file in the data directory:
060116 13:35:03 mysqld started
/usr/local/mysql/bin/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)
/usr/local/mysql/bin/mysqld: File '/usr/local/mysql/logs/update.index' not found (Errcode: 13)
060116 13:35:03 [ERROR] Aborting
060116 13:35:03 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
060116 13:35:03 mysqld ended
I scoured the Internet looking for a solution and so far I'm coming up blank, can some one please please help?