Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Official instructions for transfer onto a new server

(Page 1 of 2)
> >
Quote Reply
Official instructions for transfer onto a new server
Hello everyone!

I've searched through the forum and user manual, but I can't find any official instruction about how to move GLinks, GForum and GCommunity onto a new server?

I really looking forward to hear about this issue.

Many thanks in advance.
Quote Reply
Re: [katakombe] Official instructions for transfer onto a new server In reply to
Hi,

Short answer - its not easy :P

I'll post a rough guide - but I may miss something :) (I'm used to normally just doing it, not explaining =))

1) Backup your cgi-bin in SSH, with:

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

2) Backup your "pages" folder, with:

cd /path/to/your/www/links
tar -cvvf www.tar *

3) Backup your DB:

mysqldump --add-drop-table -uUSERNAEM -pPASSWORD DB_NAME > backup.sql

4) Download these files locally, and upload to your new server

5) Decompress in THEIR NEW FOLDERS:

cd /path/to/new/www/folder
tar -xof www.tar

cd /path/to/cgi-bin/links
tar -xof cgibin.tar

6) Then, you need to "grep" the files, so do:

cd /path/to/cgi-bin/links
grep -r -l '/old/path/to/cgi-bin/links' .
perl -p -i -e 's|/old/path/to/cgi-bin/links|/new/path/to/cgi-bin/links|g' `grep -r -l '/old/path/to/cgi-bin/links' .`

(the 2nd command, just confirms you gonna be grepping the right file, and will return a list of files matching the path you entered)

7) If that all works, the admin panel should work =)

8) Now, you just need to restore the DB ... with:

cd /path/to/where/you/uploaded/backupsql/
mysql -uUSERNAME -pPASSWORD DB_NAME < backup.sql

Phew - think thats about it Tongue

This is **just** for GLinks btw ... the others are different. If you don't mind paying, I could do the transfer for you (just shoot me a PM or email)

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!
Quote Reply
Re: [katakombe] Official instructions for transfer onto a new server In reply to
Just a short notice:

Thanks to Andy, migration has ended very quickly and smoothly. All databases and all templates are as they was on the old server, no change was needed by me. I'm very satisfied and I can recommend Ultraneards to other GT users who want to do the same.

Once again, thanks Andy.
Quote Reply
Re: [katakombe] Official instructions for transfer onto a new server In reply to
Hi,

No problem, and thanks for the kind comments :)

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!
Quote Reply
Re: [Andy] Official instructions for transfer onto a new server In reply to
HI Andy,

Following your instructions, i got to the part:

6) Then, you need to "grep" the files, so do:

cd /path/to/cgi-bin/links
grep -r -l '/old/path/to/cgi-bin/links' .
perl -p -i -e 's|/old/path/to/cgi-bin/links|/new/path/to/cgi-bin/links|g' `grep -r -l '/old/path/to/cgi-bin/links' .`

Is this 1 command, or 2?
When I type the first grep, by its self (whole line) it just sits there for a LONG time... (waited some 5 minutes), is it suppossed to take that long? Or is it one whole long command? Also im guessing the periods dont count at the end of the line, and the last upper comma doesnt either. Or do they?

Thanks,

Juan Carlos
Quote Reply
Re: [Gorospe] Official instructions for transfer onto a new server In reply to
Hi,

Quote:
cd /path/to/cgi-bin/links
grep -r -l '/old/path/to/cgi-bin/links' .
perl -p -i -e 's|/old/path/to/cgi-bin/links|/new/path/to/cgi-bin/links|g' `grep -r -l '/old/path/to/cgi-bin/links' .`

Is this 1 command, or 2?

Its a couple.

First:

Code:
cd /path/to/cgi-bin/links

..then:

Code:
grep -r -l '/old/path/to/cgi-bin/links' .

(this shows you files matching the query, and should show all the .cgi scripts, and some .pm files - if you have the value correctly put in)

..and finally:

Code:
perl -p -i -e 's|/old/path/to/cgi-bin/links|/new/path/to/cgi-bin/links|g' `grep -r -l '/old/path/to/cgi-bin/links' .`

(obvioulsy replace the /old/path/to/cgi-bin/links and /new/path/to/cgi-bin/links bits to the correct paths =))

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!
Quote Reply
Re: [Andy] Official instructions for transfer onto a new server In reply to
Hmmm the command:

grep -r -l '/path/to/cgi-bin/admin'

Has been "working for some 10 minutes now... nothing happening on screen. Is this correct?
Quote Reply
Re: [Gorospe] Official instructions for transfer onto a new server In reply to
The . at the end is VERY important Wink

Also:

Code:
grep -r -l '/path/to/cgi-bin/admin' .

..should be more like:

Code:
grep -r -l '/home/user/domain.com/cgi-bin/links/admin' .

(or whatever you "old" path to the site is)

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!
Quote Reply
Re: [Andy] Official instructions for transfer onto a new server In reply to
Thank you Andy, worked great.

One thing that wasnt on there...
I have a field to attach a pdf to each ID. The DB has the path since its uploaded via admin panel. I opened the sql file and simply replaced the path with the new one.

Thought Id add that simple step, cause it took some time to figure it out.

All working great Andy, thank you again.
Quote Reply
Re: [Gorospe] Official instructions for transfer onto a new server In reply to
Quote:
I have a field to attach a pdf to each ID. The DB has the path since its uploaded via admin panel. I opened the sql file and simply replaced the path with the new one.

Yeah, I normally just do a search and replace on the File_Path in glinks_Links_Files. The above wasn't mean't to be a full tutorial - just a guidline Smile

Glad it worked for you though :)

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!
Quote Reply
Re: [Andy] Official instructions for transfer onto a new server In reply to
Hi Andy,

I make every thing you wrote and change my old path from /kunden/homepages/22/d290891059/htdocs to /homepages/22/d290891059/htdocs
when I now grep for the old path nothing will find.
But when I want to change some entrys I got many errors an some with different path Angelic

Quote:
Stack Trace
======================================
Links (20000): Links::environment called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links.pm line 750 with no arguments.

Links (20000): GT::SQL::Admin::process called at /kunden/homepages/22/d290891059/htdocs/html/cgi-bin/admin/admin.cgi line 79 with arguments
(Links::Admin=HASH(0x84d548c), db, GT::SQL=HASH(0x8357e74), cgi, GT::CGI=HASH(0x834fbc8)).


Can you tell me where I can find and change the path for that?

Regards
Frank
Quote Reply
Re: [qix] Official instructions for transfer onto a new server In reply to
Hi,,

When you say "change some entrys" .. where exactly are you getting that error?

In SSH, try running this command:

grep -r -l '/kunden/homepages' .

...to see if any of the files were not updated properly.

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!
Quote Reply
Re: [Andy] Official instructions for transfer onto a new server In reply to
Hi,

when I type grep -r -l '/kunden/homepages' . than nothing will found Blush
Here ist the complete Debug error when I do the following:
Click on "Datenbank" and then choose "Einträge" and "suchen" click on go.


Quote:
A fatal error has occured:
Can't call method "fetchrow_array" on an undefined value at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links/HTML/Links.pm line 382.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (23256): Links::environment called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links.pm line 750 with no arguments.
Links (23256): Links::fatal called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links/HTML/Links.pm line 382 with arguments
(Can't call method "fetchrow_array" on an undefined value at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links/HTML/Links.pm line 382.
).
Links (23256): Links::HTML::Links::get_all_categories called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links/HTML/Links.pm line 393 with arguments
(Links::HTML::Links=HASH(0x8361cc0), ARRAY(0x859efac), CatLinks.CategoryID).
Links (23256): Links::HTML::Links::get_categories_with_html called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links/HTML/Links.pm line 210 with arguments
(Links::HTML::Links=HASH(0x8361cc0), ARRAY(0x859efac), CatLinks.CategoryID).
Links (23256): Links::HTML::Links::_plg_form called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links/HTML/Links.pm line 47 with arguments
(Links::HTML::Links=HASH(0x8361cc0), HASH(0x859e1e4)).
Links (23256): Links::HTML::Links::__ANON__ called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/GT/Plugins.pm line 133 with arguments
(HASH(0x859e1e4)).
Links (23256): GT::Plugins::dispatch called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/Links/HTML/Links.pm line 47 with arguments
(GT::Plugins=HASH(0x835e990), form_link, CODE(0x859e58c), HASH(0x859e1e4)).
Links (23256): Links::HTML::Links::form called at GT::SQL::Admin::search_form line 290 with arguments
(Links::HTML::Links=HASH(0x8361cc0), HASH(0x859e1e4)).
Links (23256): GT::SQL::Admin::search_form called at /homepages/22/d290891059/htdocs/html/cgi-bin/admin/GT/SQL/Admin.pm line 121 with arguments
(Links::Admin=HASH(0x84d547c)).
Links (23256): GT::SQL::Admin::process called at /kunden/homepages/22/d290891059/htdocs/html/cgi-bin/admin/admin.cgi line 79 with arguments
(Links::Admin=HASH(0x84d547c), db, GT::SQL=HASH(0x8357e74), cgi, GT::CGI=HASH(0x834fbc8)).
Links (23256): main::db_request called at /kunden/homepages/22/d290891059/htdocs/html/cgi-bin/admin/admin.cgi line 57 with no arguments.
Links (23256): main::main called at /kunden/homepages/22/d290891059/htdocs/html/cgi-bin/admin/admin.cgi line 24 with no arguments.
System Information
======================================
Current user: u53998342 (6291769)
Perl version: 5.8.8
Gossamer Links version: 3.2.0
GT::SQL version: 1.111
GT::Template version: 2.161
DBI.pm Version: 1.53
Running under mod_perl: No
Running under SpeedyCGI: No
@INC =
/homepages/22/d290891059/htdocs/html/cgi-bin/admin
/etc/perl
/usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
.
GT::SQL::error = Could not connect to database: Access denied for user: 'dbo291402993@localhost' (Using password: YES)
DBI::errstr = Access denied for user: 'dbo291402993@localhost' (Using password: YES)
CGI Input
======================================
ID =>
ID-opt => =
ReviewID =>
ReviewID-opt => =
Username =>
Username-opt => =
db => Links
do => search_form
keyid =>
keyword =>
todo => search_form
CGI Cookies
======================================
__utma => 133724620.1454468262.1247066307.1247157946.1247240720.3
__utmz=133724620.1247066308.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd => (none)
Environment
======================================
AUTH_TYPE => Basic
DBENTRY => /kunden/homepages/22/d290891059/htdocs:d0000#CPU 60 #MEM 131072 #CGI 347 #NPROC 100 #TAID 53998342 #WERB 0 #LANG 0 #PARKING 1 #STAT 1
DOCUMENT_ROOT => /kunden/homepages/22/d290891059/htdocs
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /homepages/22/d290891059/htdocs/html/cgi-bin/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => de
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => __utma=133724620.1454468262.1247066307.1247157946.1247240720.3; __utmz=133724620.1247066308.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
HTTP_HOST => s290891093.online.de
HTTP_REFERER => http://s290891093.online.de/...cgi?page=db_nav.html
HTTP_UA_CPU => x86
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; Alexa Toolbar)
PATH => /bin:/usr/bin
PATH_INFO => /html/cgi-bin/admin/admin.cgi
PATH_TRANSLATED => /kunden/homepages/22/d290891059/htdocs/html/cgi-bin/admin/admin.cgi
QUERY_STRING => keyword=&Username=&ID=&ReviewID=&do=search_form&ID-opt=%3D&Username-opt=%3D&ReviewID-opt=%3D&db=Links&todo=search_form&keyid=
REDIRECT_DBENTRY => /kunden/homepages/22/d290891059/htdocs:d0000#CPU 60 #MEM 131072 #CGI 347 #NPROC 100 #TAID 53998342 #WERB 0 #LANG 0 #PARKING 1 #STAT 1
REDIRECT_QUERY_STRING => keyword=&Username=&ID=&ReviewID=&do=search_form&ID-opt=%3D&Username-opt=%3D&ReviewID-opt=%3D&db=Links&todo=search_form&keyid=
REDIRECT_SCRIPT_URI => http://s290891093.online.de/...-bin/admin/admin.cgi
REDIRECT_SCRIPT_URL => /html/cgi-bin/admin/admin.cgi
REDIRECT_STATUS => 200
REDIRECT_UNIQUE_ID => Smh7hqwd1zUAAGRQBFE
REDIRECT_URL => /html/cgi-bin/admin/admin.cgi
REMOTE_ADDR => 78.48.114.44
REMOTE_PORT => 1768
REMOTE_USER => admin
REQUEST_METHOD => GET
REQUEST_URI => /html/cgi-bin/admin/admin.cgi?keyword=&Username=&ID=&ReviewID=&do=search_form&ID-opt=%3D&Username-opt=%3D&ReviewID-opt=%3D&db=Links&todo=search_form&keyid=
SCRIPT_FILENAME => /kunden/homepages/22/d290891059/htdocs/html/cgi-bin/admin/admin.cgi
SCRIPT_NAME => /html/cgi-bin/admin/admin.cgi
SCRIPT_URI => http://s290891093.online.de/...-bin/admin/admin.cgi
SCRIPT_URL => /html/cgi-bin/admin/admin.cgi
SERVER_ADDR => 87.106.58.132
SERVER_ADMIN => webmaster@s290891093.online.de
SERVER_NAME => s290891093.online.de
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache
STATUS => 200
UNIQUE_ID => Smh7hqwd1zUAAGRQBFE

I see that Links can't reach the DB, but I dont know why Mad
When I want to change the SQL Server he com back with:
Fehler: Could not connect to database: Access denied for user: 'dbo291402993@localhost' (Using password: YES)

Regards,
Frank
Quote Reply
Re: [qix] Official instructions for transfer onto a new server In reply to
Hi,

Yeah, looks like your login details are not correct.

Check your /admin/defs/database.def file, to make sure all the settings are correct.

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!
Quote Reply
Re: [Andy] Official instructions for transfer onto a new server In reply to
Hmmm, I can't find the problem Frown

Here is the database.def
Quote:
{
'driver' => 'mysql',
'PrintError' => '',
'database' => 'db291402993',
'port' => '',
'password' => 'srfege.heo98',
'host' => 'localhost:/tmp/mysql5.sock',
'login' => 'dbo291402993',
'RaiseError' => '',
'AutoCommit' => '1',
};
And here are the infos I got from my provider:
Quote:
Datenbankname: db291402993
Hostname: localhost:/tmp/mysql5.sock
Benutzername: dbo291402993
Passwort: srfege.heo98
Socket: /tmp/mysql5.sock

I think thats ok ... but Iam not sure Unsure

Thanks,
Frank
Quote Reply
Re: [qix] Official instructions for transfer onto a new server In reply to
I find it hard to believe your host server is:

Code:
'host' => 'localhost:/tmp/mysql5.sock',

Try just:

Code:
'host' => 'localhost',

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!
Quote Reply
Re: [Andy] Official instructions for transfer onto a new server In reply to
Andy wrote:
I find it hard to believe your host server is:

Code:
'host' => 'localhost:/tmp/mysql5.sock',

But that the info I can see in my SQL Konfig.

Andy wrote:
Try just:

Code:
'host' => 'localhost',


Cheers

Nothing, same errorFrown
Quote Reply
Re: [qix] Official instructions for transfer onto a new server In reply to
Hi,

I start a very new DB and got the same problems Crazy
Quote Reply
Re: [qix] Official instructions for transfer onto a new server In reply to
Hi,

Ok, I would ask your host to take a look - as it looks like their problem :(

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!
Quote Reply
Re: [qix] Official instructions for transfer onto a new server In reply to
Hi Frank,

looks like your provider is 1und1. Can't believe that the MySQL-server is on the same machine. In most cases the db-host is something like "db1234.1und1.de".

Merten
Quote Reply
Re: [neves] Official instructions for transfer onto a new server In reply to
Hey Merten,

yes my provider is 1und1.
Here you can see the config help for the MySQL Server.

http://hilfe-center.1und1.de/...klusiv_server/9.html

Thanx,
Frank
Quote Reply
Re: [qix] Official instructions for transfer onto a new server In reply to
When I test the MySQL-Server with SSH:

mysql --host=localhost --user=dbo291402993 --password=******** -S /tmp/mysql5.sock db291402993

That works fine Crazy

Regards,
Frank
Quote Reply
Re: [qix] Official instructions for transfer onto a new server In reply to
Hi, i got as far as:

cd /path/to/where/you/uploaded/backupsql/
mysql -uUSERNAME -pPASSWORD DB_NAME < backup.sql

I'm in SSH in the directory where my backup sql file is in and i'm logged into mysql as root and have the prompt:

mysql>

my db name is links, that i had created using phpmyadmin, so i entered:

mysql> use links;

mysql> links < backup.sql;

and i got the error 1064 (42000): you have an error in your sql syntax..

Can you provide some help on what i'm typing wrong here? thanks
Quote Reply
Re: [yo Huge] Official instructions for transfer onto a new server In reply to
Hi,

You need to do it *outside* the MySQL prompt.

For example, if your DB name is "test", and your username is "andy" and password "1234", you would use:

mysqldump --add-drop-table -uandy -p1234 test > backup.sql

This would then make a backup of your database into the backup.sql file (in the directory you are in)

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!
Quote Reply
Re: [Andy] Official instructions for transfer onto a new server In reply to
Hi Andy, how's it going?

i actually already have the backup.sql dump done from before and i'm having a hard time getting it to 'import' to the newly created blank mysql db on my new server. any ideas?

i thought the line from within mysql would be:

mysql> use test;
mysql> test < backup.sql;

but its not working
> >