Need to reindex 4 months data only.

[B.JEGADEESAN]

Hi

We need to reindex our 4months archive data only (eg : from 01.05.2023 to 30.08.2023).
And we need to find 4month before particular date (eg : 01.05.2023 00:00 hrs) 1st ID need to find please let us know how to achieve this.

[Janos SUTO]

Why do you need to reindex? Are the sphinx data files lost and no backup?

[B.JEGADEESAN]

We sync our store data from old server to another new server setup and database also, For now just we need to reindex last 4 months data only. So that we need to find 4month before particular date (eg : 01.05.2023 00:00 hrs) 1st ID.

[Janos SUTO]

Well, in that case run a query on the piler mysql database like below to get the 1st ID for the reindex -f option:

select id from metadata where sent >= "the timestamp value of 01.05.2023 00:00" order by id asc limit 1;

‌

The 2nd ID for the reindex -t option simply

select id from metadata order by id desc limit 1;

‌