Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [blacknight] How Can I Reset Link ID?

Quote Reply
Re: [blacknight] How Can I Reset Link ID? In reply to
It's pretty simple to do. You just need some Perl code to insert a new ID into each record but make sure you update the CatLinks table too. Actually, I think the database module updates all foreign keys automatically.

When someone creates a new record the ID will still start at the last ID MySQL recognizes which will be 50 million or whatever the last ID was so if that's a problem you may need to look into ways of resetting the auto increment ID in MySQL.
Subject Author Views Date
Thread How Can I Reset Link ID? blacknight 2716 Jul 20, 2008, 6:24 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 2689 Jul 20, 2008, 6:32 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 2652 Jul 20, 2008, 6:33 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 2646 Jul 20, 2008, 6:37 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 2641 Jul 20, 2008, 6:38 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 2653 Jul 20, 2008, 6:39 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 2644 Jul 20, 2008, 6:40 AM
Post Re: [blacknight] How Can I Reset Link ID?
Wychwood 2615 Jul 22, 2008, 2:40 AM