MySQL Forums
Forum List  »  MySQL Administrator

Turn off logging while restoring
Posted by: J Wyllie
Date: April 30, 2009 07:00AM

Hi

I used mysqldump to backup a database to file. I then used:
mysql -u DBName < backupfile.sql to restore it to DBName (in fact a different database).

Even though the database is small this produced several huge c. 300Mbs binary log files.

Any idea why this might be and, can I turn off logging temporaily on the command line (not by changing the options and restarting the server).

Thanks

Justin

Options: ReplyQuote


Subject
Written By
Posted
Turn off logging while restoring
April 30, 2009 07:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.