Hi, I have a problem with regards to building all of my directory pages. Sometimes, my database becomes completely empty (thank god for backups) and sometimes a large chunk in the middle of it disappears. After the first incident, I decided to make two similar databases, links.db and links2.db. links2.db is the one that gets to be used by my search.cgi script, while links.db stays untouched but for the updating of stats and adding new links/building directories. I update links2.db only about twice a month by just copying and renaming links.db. That worked a little, since most of the heavy usage is focused on links2.db thus avoiding possible corruption on links.db although links.db is more updated. Only yesterday while I was adding new links, links.db suffered a major corruption, wherein right smack in the middle, more than a thousand worth of links data vanished. this happened while i was building the directory pages, or while i was adding those new links. do you guys have any good advice to avoid this from happening again?
i'm an editor of the Open Directory and i noticed that when i add and approve link submissions, only the directory page in question is updated, not the whole open directory. i wonder if this is possible at all for links 2.0, so as to avoid putting too much stress on the server and the poor ol' database.
i'm an editor of the Open Directory and i noticed that when i add and approve link submissions, only the directory page in question is updated, not the whole open directory. i wonder if this is possible at all for links 2.0, so as to avoid putting too much stress on the server and the poor ol' database.