When you run Import.pl to import a Links 2 database into Links SQL, it automatically removes the unused ID numbers and effectively renumbers the database. At first I thought this was nice; compress unneeded "space." Then it occured to me that I'll have a bit of a problem with that...
I have a list of around 200 hard coded links using the jump.cgi?id=x method. The reason why I have that isn't too important, but I figured it would be much more likely for their URL's to change than it would be their Links ID #'s... Oops.
So, is there any way to tell Import.pl not to remove the blanks? I only have ~150 unused ID #'s scattered throughout my database (haven't been able to run more than about 10% of a verify to look for dead links ), so compression isn't currently of much need to me.
Oh yeah, for those of you that are more of a newbie to Links SQL than I, as Alex pointed out to me in an email, the instructions for Import.pl are inside the script. I went ahead and ran it throught telnet without knowing to direct output to an error file, although I did log the process...
Thanks,
Dan
p.s. pugdog, I'll get a new sig set up per your request. For now, my Links SQL temp setup is at http://run-down.com/links/ and my Links 2 (which will become the location for the SQL when it's ready) is at http://run-down.com/ .
I have a list of around 200 hard coded links using the jump.cgi?id=x method. The reason why I have that isn't too important, but I figured it would be much more likely for their URL's to change than it would be their Links ID #'s... Oops.
So, is there any way to tell Import.pl not to remove the blanks? I only have ~150 unused ID #'s scattered throughout my database (haven't been able to run more than about 10% of a verify to look for dead links ), so compression isn't currently of much need to me.
Oh yeah, for those of you that are more of a newbie to Links SQL than I, as Alex pointed out to me in an email, the instructions for Import.pl are inside the script. I went ahead and ran it throught telnet without knowing to direct output to an error file, although I did log the process...
Thanks,
Dan
p.s. pugdog, I'll get a new sig set up per your request. For now, my Links SQL temp setup is at http://run-down.com/links/ and my Links 2 (which will become the location for the SQL when it's ready) is at http://run-down.com/ .