Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Re: [Jag] Deleting everything except the categories

Aug 26, 2004, 9:56 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Aug 26, 2004, 9:56 AM
Views: 2916
Shortcut
Quote Reply
Re: [Jag] Deleting everything except the categories In reply to
In MySQLMonitor;

Code:
DELETE FROM lsql_Links;
DELETE FROM lsql_CatLinks;
UPDATE lsql_Category SET Number_of_Links = '0';

...and then run "Repair Tables" in your LSQL admin panel.

Please be sure that you have the names of the tables right... just in case you delete something you didn't want to =)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread Deleting everything except the categories Jag 3008 Aug 26, 2004, 9:49 AM
Thread Re: [Jag] Deleting everything except the categories 		Andy 2916 Aug 26, 2004, 9:56 AM
Thread Re: [Andy] Deleting everything except the categories 		Jag 2901 Aug 27, 2004, 12:16 PM
Thread Re: [Jag] Deleting everything except the categories 		Andy 2910 Aug 28, 2004, 12:00 AM
Thread Re: [Andy] Deleting everything except the categories 		Jag 2892 Aug 28, 2004, 10:04 AM
Thread Re: [Jag] Deleting everything except the categories 		Andy 2876 Aug 31, 2004, 12:14 AM
Thread Re: [Andy] Deleting everything except the categories 		Jag 2856 Aug 31, 2004, 8:19 AM
Post Re: [Jag] Deleting everything except the categories 		Andy 2872 Aug 31, 2004, 8:25 AM
Thread Re: [Andy] Deleting everything except the categories 		junior_33 2874 Aug 30, 2004, 1:09 PM
Post Re: [junior_33] Deleting everything except the categories 		Andy 2867 Aug 31, 2004, 12:16 AM