Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Reindexing Category Database

Quote Reply
Reindexing Category Database
I have recently imported my category database via MySQL Man. However, when I try to reindex the database, it always seems to stop at 7000 categories i.e.

"Reindexing Category Database ... 11409 categories.
1000 2000 3000 4000 5000 6000 7000" and the nhp-build.cgi seems to stop.

Any suggestions as to why this might be? Unsure

What are the implications?

Thanks in advance

Valiant
Quote Reply
Re: [valiant] Reindexing Category Database In reply to
Alex may need to take a look at this.

It may be related to the problem people had with the DMOZ import.

If the build/repair is stopping at a certain point before completion, it might be something that can be fixed in the code to get past it.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] Reindexing Category Database In reply to
Alex

Sorry, misquoted above. It is nph-index.cgi which stops after indexing 7,000 records.

Any chance of you having a look?

Thanks
Quote Reply
Re: [valiant] Reindexing Category Database In reply to
Hi,

Give it a try from shell first to see if it completes. Your server may be killing it off because it is taking to long. You might want to ask your ISP if they have something that monitors long running processes.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [valiant] Reindexing Category Database In reply to
Well... FWIW if anyone is interested,

I have my own little server here, and it's running an nph- web browser session, that has already run for about 10 hours, and indexed about 350,000 DMOZ links.

I realize I should have started it via telnet, using nohup ./nph-index.cgi but... I wanted to see if my browser would time out on the local network :)


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] Reindexing Category Database In reply to
reindexing seems to be able to run without timing out, as does repairing tables.

Not sure if that is some clever code or just fluke.
Quote Reply
Re: [RedRum] Reindexing Category Database In reply to
Alex

I have re-indexed successfully in the past, with no problems.

I do not have shell / telnet access - is there any other kind of workaround?