Put "SET SQL_LOG_BIN=0" at the top of your dump file. That will turn off logging just for your session.
-Ryan > -----Original Message----- > From: sheeri kritzer [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 02, 2006 11:56 AM > To: Rithish Saralaya > Cc: MySQL general mailing list > Subject: Re: create/restore database without binary logging > > Rithish, > > It's possible to do this by turning off binary logging, > restarting the server, importing, turning on binary logging, > and restarting. > > -Sheeri > > On 2/27/06, Rithish Saralaya > <[EMAIL PROTECTED]> wrote: > > Hello. > > > > I was going to recreate a database of size 35 GB from sql > dump file. > > Wanted to know if it is possible to do it without mysql > writing into > > the binary log. If yes, how? > > > > Regards, > > Rithish. > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
