querylog table

KMandalia · Post by **KMandalia** » Mon Jan 31, 2005 1:30 pm

I have an old profile with querylog table storing last 6 months data.

I created new profile with lots of changes and additions (no deletions from the old profile) in the walk status.

My question: Can I delete the querylog table of the new profile (which is blank since it is not live yet) and then bring over (copy) the querylog table of the old profile to the newly created profile.

Am I right to say that the only thing I have to make sure is that querylog table of the old profile is not being modified when I am copying it, right? Are there any other issues?

Post by **mark** » Mon Jan 31, 2005 1:38 pm

Make sure query logging is off in both profiles during the copy or that no queries occur.
You'll also need to bring over the index files xmmquerylogInfo* and xqueryid* .

KMandalia · Post by **KMandalia** » Mon Jan 31, 2005 2:44 pm

perfect.

Thank you.