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

List of categories

Mar 18, 2003, 8:50 AM
rayhne
Enthusiast (582 posts)
rayhne's avatar
Mar 18, 2003, 8:50 AM
Post #1 of 7
Views: 2037
Shortcut
Quote Reply
List of categories
What do I need to download in order to just get a list of categories in my database?
Mar 18, 2003, 8:54 AM
pugdog
Veteran / Moderator (6956 posts)
Mar 18, 2003, 8:54 AM
Post #2 of 7
Views: 1964
Shortcut
Quote Reply
Re: [rayhne] List of categories In reply to
Categories are stored in the Category table.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Mar 18, 2003, 9:50 AM
rayhne
Enthusiast (582 posts)
rayhne's avatar
Mar 18, 2003, 9:50 AM
Post #3 of 7
Views: 1991
Shortcut
Quote Reply
Re: [pugdog] List of categories In reply to
How do I download them for use in...say....Excel?

Last edited by:

rayhne: Mar 18, 2003, 9:51 AM
Mar 18, 2003, 9:54 AM
Paul
Veteran (19537 posts)
Mar 18, 2003, 9:54 AM
Post #4 of 7
Views: 1978
Shortcut
Quote Reply
Re: [rayhne] List of categories In reply to
Use the export function in mysqlman - it lets you export specific columns.
Mar 18, 2003, 10:46 AM
rayhne
Enthusiast (582 posts)
rayhne's avatar
Mar 18, 2003, 10:46 AM
Post #5 of 7
Views: 1945
Shortcut
Quote Reply
Re: [Paul] List of categories In reply to
I tried that, I get this.
MySQL Said: Access denied for user: 'rayhne_rayhne@localhost' (Using password: YES).

Query: SELECT Name INTO OUTFILE '/usr/tmp/GTMM10480131352509091' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM links_Category

Mar 18, 2003, 10:50 AM
Paul
Veteran (19537 posts)
Mar 18, 2003, 10:50 AM
Post #6 of 7
Views: 1943
Shortcut
Quote Reply
Re: [rayhne] List of categories In reply to
That means your host hasn't given your mysql account "FILE" privileges.
Mar 18, 2003, 10:55 AM
rayhne
Enthusiast (582 posts)
rayhne's avatar
Mar 18, 2003, 10:55 AM
Post #7 of 7
Views: 1946
Shortcut
Quote Reply
Re: [Paul] List of categories In reply to
hee. I got it...:)