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

How do I delete all my data?

Apr 5, 2004, 9:18 AM
banana
User (164 posts)
Apr 5, 2004, 9:18 AM
Post #1 of 3
Views: 1693
Shortcut
Quote Reply
How do I delete all my data?
Hi, by accident I created 3,000 categories in Links SQL. Those should be links, not categories. No harm is done as this is a test/experiment only. I need to delete those categories and import my data from fresh again. I don't want to delete 3000 categories one by one. Is there any way that I can delete data without causing my Links SQL to act with errors?

Please help
Apr 5, 2004, 9:30 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Apr 5, 2004, 9:30 AM
Post #2 of 3
Views: 1608
Shortcut
Quote Reply
Re: [banana] How do I delete all my data? In reply to
Setup > SQL Database > 2nd option down I think, and that should clean out your database to its original format.

Otherwise, you can type this into MySQLMonitor;

Quote:
DELETE FROM lsql_Links;
DELETE FROM lsql_CatLinks;
DELETE FROM lsql_Category;

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!
Apr 6, 2004, 10:32 AM
banana
User (164 posts)
Apr 6, 2004, 10:32 AM
Post #3 of 3
Views: 1580
Shortcut
Quote Reply
Thanks. It works In reply to