Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

duplicated all links

Quote Reply
duplicated all links
Oops...apparently while importing links I somehow now have 3 of everything listed. Is there a way in the SQL monitor to delete all of my existing links so I can reupload them correctly this time? If there is a way, what is the command and where do I enter it?
http://link-fabulous.com
Groovy adult links
Quote Reply
Re: [HotMop] duplicated all links In reply to
Use the EMPTY option. (delete) Not in the SQL Monitor...in the table view option...click on the EMPTY option...that will "empty" or purge all records in the LINKS table.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [AnthroRules] duplicated all links In reply to
Hmmm.....I don't see the option you're talking about. Here's the table that I have:

Table Maintenace: Links

Help | SQL Monitor | Import data | Export data | Add a new Field | Delete a Field | Edit Table Definition

Are you meaning the 'delete a field'?
http://link-fabulous.com
Groovy adult links
Quote Reply
Re: [HotMop] duplicated all links In reply to
UH...LOOK AT THE INDIVIDUAL TABLE INFORMATION!!!!

You SHOULD SEE the FOLLOWING options:

Links | Browse | Select | Properties | Insert | Drop | Empty

C L I C K on EMPTY!

duh!
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [AnthroRules] duplicated all links In reply to
uhhh....I'm using
Links SQL Administration Menu
Version: 1.11

I don't see any of that. Where should I be looking?
http://link-fabulous.com
Groovy adult links
Quote Reply
Re: [HotMop] duplicated all links In reply to
Download MySQLMan and use that to administrate your backend....

Sorry...I thought you had it installed and using it.

And if you want to use the SQL monitor in the table maintenance script that comes with LINKS SQL v.1.13, the one you are using...

Then all you have to enter is:

Code:

DELETE FROM Links



========================================
Buh Bye!

Cheers,
Me