start options in mysql

Reply

Join Date: Mar 2009
Posts: 19
Reputation: srpa01red is an unknown quantity at this point 
Solved Threads: 0
srpa01red srpa01red is offline Offline
Newbie Poster

start options in mysql

 
0
  #1
Apr 28th, 2009
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
Reply With Quote Quick reply to this message  
Join Date: Jun 2008
Posts: 79
Reputation: varmadba is an unknown quantity at this point 
Solved Threads: 8
varmadba varmadba is offline Offline
Junior Poster in Training

Re: start options in mysql

 
0
  #2
Apr 29th, 2009
Try this way
put this line in my.cnf file and bin logging will be enabled

  1. 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
  1. log-BIN=/home/Bin_Log
"/home/Bin_log" ,change the location to your like
:- Varma

We are Happy to inform launch of a new site with loads of database related information Site offers wide range of functionality Forums,Blogs,Articles,Editorials and much more
http://www.sqllibrarian.info/
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC