Saturday, January 29, 2011

Setting up mySQL to do binary logging for incremental backups on Windows Web Server 2008 R2

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 .

  • 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 parentheses
    Craig : Look at the MySQL error log file for hints about what the problem is
    From Craig

0 comments:

Post a Comment