I'm using mySQL 5.1 on Windows Web Server 2008 R2. I'm trying to set it up for binary logging to do incremental backups.
To start with binary logging enabled (I hope) I added
log-bin = "C:/binlogs"
binlog_do_db = mySQLdata
to my.ini . My dayabase is "mySQLdata". Is that right?
When I add some lines of data to the database I don't see any log files being written in the binlogs folder .
From serverfault
Saul
-
MySQL won't pick up my.ini changes without restarting it.
Saul : This is getting worse, I tried restarting via MySqlWorkbench, and only got as far as stopping mysql, it wont restart. Rebooted, still not running. tried at the windows command prompt F:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld nothing happens. Tried under control panel > services to start service , but get "could not start the service , error 1067 the process terminated unexpectedly"Saul : If I comment out log-bin = "C:/binlogs" it will start, the directory exists. i've tried C:\binlogs and with and without parenthesesCraig : Look at the MySQL error log file for hints about what the problem isFrom Craig
0 comments:
Post a Comment