Member Avatar for srpa01red

hello hi
i am using mac osx 10.5
i want to start mysql in it with --log-bin option so as to take incremental backup.so how can i start mysql with that option.
i start mysql as mysql -u root -p.
plz help me.
where can i find my binlogs

  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by varmadba
Member Avatar for varmadba

Try this way
put this line in my.cnf file and bin logging will be enabled

log-bin=/home/Bin_Log

i start mysql as mysql -u root -p.

This command is not to start Mysql but to connect to Mysql

if you Mysql installed as service try
service mysql start or go init.d

where can i find my binlogs

log-bin=/home/Bin_Log

"/home/Bin_log" ,change the location to your like

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.