Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

Dumping ONLY URL's from Links SQL DB

Jun 26, 2000, 12:39 PM
pauls
User (61 posts)
Jun 26, 2000, 12:39 PM
Post #1 of 2
Views: 1600
Shortcut
Quote Reply
Dumping ONLY URL's from Links SQL DB
Hi there.. I have Links SQL running on MySQL just fine.

I need a way (novice Mysql user) to dump a list of just URL's from the Links db to a text file.

Can anyone help me with the command to do this? :)

Thanks again,

Paul


---
Paul Stewart
Nexicom Inc.
http://www.nexicom.net
Jun 27, 2000, 10:58 AM
pugdog
Veteran / Moderator (6956 posts)
Jun 27, 2000, 10:58 AM
Post #2 of 2
Views: 1554
Shortcut
Quote Reply
Re: Dumping ONLY URL's from Links SQL DB In reply to
From the SQL monitor:

SELECT URL from Links INTO OUTFILE 'filename'




http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/