Search code examples
mysqldiskspace

Restore mysqldump file without writing to general_log


It's basically what the subject says. I've read about disabling binary log when restoring a DB dump, but I can't find how to do this with general log (all the INSERT statements end up there and they take a lot of space). Is it possible to disable this kind of logging just for the restore operation?


Solution

  • Read this.

    SET GLOBAL general_log = 'OFF'; And restart the server.