I have been cleaning my database as it had many dead sites. I DO back up constantly! There is something very strange going on tho! Sometimes when I check the links.db file I see lines that have been either shortened or wind up on 2 lines instead of 1 line. I also notice that sometimes the file size goes down significantly, then I do a look see and find that 1/8th the database has poofed into thin air.
What causes this, and is there a fix for it?
This is an example of 1 of the lines that goes missing. It's the one with the ://
16690|SITENAME|http://www.COM|21-Oct-2005|CAT|DESCRIPTION|NAME|webmaster@URL.com|25|No
://http://www.COM|20-Oct-2005|CAT|DESCRIPTION|NAME|webmaster@URL.com|25|No|No|0|0|Yes||WOTD
16700|SITENAME|http://www.COM|21-Oct-2005|CAT|DESCRIPTION|NAME|webmaster@URL.com|50|WOTD

This one is a 2 liner. The errored line starts with the || -
13342|SITENAME|http://www.COM|6-Apr-2005|CAT|DESCRIPTION||||No|No|||||
||stoned|||||||No|No|||||

The next kind of error is the one that eats chunks of the database -
site # 5100 will be in tact, then there will be a space on the next line.

Then the next site listed in site #5501.
There are aprox 401 entries missing in cyberspace :( (this is just an example of the sites that go missing)

There has got to be a fix for this (I'm hoping) somewhere! Please??!!

Thank you to whomever can fix this bugger!