Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Installation Headaches

Quote Reply
Installation Headaches
I am curious to know if there exists a list of all the files that are associated to Links SQL and which directories they get installed in. I need to reinstall the product but want to be sure I have removed all the files from the previous install completely.
Thanks.

Jaggster
Quote Reply
Re: [Jaggster] Installation Headaches In reply to
(1). If upgrading from an earlier version, chose Upgrade as install option.
(2). If installing the same version, do it as a new install, but keep the earlier paths as the paths for new install. It will overwrite the files.

In option 1 your tables would automatically be altered, new tables added (if any) as per specs of newer version that you are installing.

In option 2 you can chose not to overwrite the database tables to keep your database intact.

If you have data in linksdb do a

mysqldump -u linksdbusername -p linksdbname > linksdb.sql

just in case it may be needed for a recovery back.

Backup your templates in case any modifications have been done.

HyTC.
Quote Reply
Re: [HyperTherm] Installation Headaches In reply to
Not sure if MySQLDump is fussy, but I believe you don't need the spaces after -u and -p. i.e, it should look like;

Code:
mysqldump -uUSERNAME -pPASSWORD linksdbname > linksdb.sql

Also, when doing a backup... be sure to tar up your whole LSQL folder too;

Code:
cd /full/path/to/your/cgi-bin/links
tar -cvvf cgibin.tar *

Just thought I would post this... in case the other command didn't work =)

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] Installation Headaches In reply to
In Reply To:
Not sure if MySQLDump is fussy, but I believe you don't need the spaces after -u and -p. i.e, it should look like;

Code:
mysqldump -uUSERNAME -pPASSWORD linksdbname > linksdb.sql


http://dev.mysql.com/doc/mysql/en/mysqldump.html
Hmm that makes a note of a Space between -u ....
Works for me V4.0.20 Smile

HyTC
Quote Reply
Re: [HyperTherm] Installation Headaches In reply to
Ah, I guess its fussy on different servers. If I type;

mysqldump -u USERNAME -p PASSWORD database_name > test.sql

...then it gives me an error about "permission denied for use xx@foobar.com".

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] Installation Headaches In reply to
And if i type:

mysqldump -ulinksusername -plinkspassword linksdbname > linksdb.sql

mysqldump: Got error: 1045: Access denied for user: 'linkusername@localhost' (Using password: YES) when trying to connect

mysqldump -u linksusername -p linksdbname > linksdb.sql [ENTER]

Prompts for Password
Backup done :)

HyTC
Quote Reply
Re: [HyperTherm] Installation Headaches In reply to
Thank you all for your help and suggestions. I wasn't really concerned with the back as the previous install for this site was done some time ago and never actually used. The hosting company I use moved my account to a new server and the directories that Links SQL was in got screwed up. I tried to reinstall it as is and ended up with a mess of files and directories all over the place.
I actually ended up hearing from GT Support and they gave me the info I needed about what files to remove from where. Hopefully this will help. Will be doing the reinstall later today. Wish me luck.

Thanks again.

Jaggster