Keeping the Querylog Table

[wally.hartshorn]

Whenever we rewalk our website (which we do nightly), the querylog table is cleared out. We generate a report showing the most popular queries, but this would be more useful if we could keep more than a single day's worth of data in the querylog table. Is there any way to keep the querylog table from being cleared by a rewalk? Alternatively, is there a way to export the querylog table and then reimport it after the rewalk is completed? Would this cause any problems?

[mark]

There's no provision for keeping querylog across -rewalks. But you can cheat a little. Before rewalking, copy querylog.tbl and xqueryid.btr somewhere else. Then after the rewalk move them both back. Make sure you always do both files. Also, if there's a query going on when you copy out in or move back in it could cause problems. It would be best to prevent logging while moving it around.