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

What's the easiest way to move Links SQL to a new host?

Quote Reply
What's the easiest way to move Links SQL to a new host?
What's the easiest way to move Links SQL to a new host?

I have just switched hosts...the old one did not allow the use of sendmail...buh bye.

I don't have any links added yet, but do have some categories identified.

Should I just down/upload or use nph-build.cgi?

Thanks,


------------------
Neophyte740

Quote Reply
Re: What's the easiest way to move Links SQL to a new host? In reply to
You need to make sure your new host has MySQL available, and you'll need to re-install Links SQL according the the instructions.

Once you do that, you can import your backup files.

If you still have access to your old server, you can do a database dump, to get all the SQL statements along with the data.

The process for doing that is in the new instructions with the current version of Link SQL upgrade from 1.0 to 1.1



------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/








Quote Reply
Re: What's the easiest way to move Links SQL to a new host? In reply to
Yes my host has MySql installed and they have created a database for me on it.

Will there be a problem installing Links SQL at the temp address of my site while I wait for InterNIC to update their db?

I have nothing in my backup dir.
I have copied the pages dir. w/ categories.

As my name implies, I am a neophyte. So a "database dump" is unfamiliar and the readme .txt is just a little confusing for an absolute neophyte...
*****
2.1 SQL Server Setup
----------------------------------------------------
We have included a setup script that will create all the
tables for you. You will need to edit the following line:

$db->connect (['DBI:mysql:links:localhost', 'user', 'pass']);
*****
this line does not appear in setup.cgi it appears in SQL.cgi...

and...
******
Once you've set that, simply run the setup script SQL.pl from within
the setup directory and all your tables will be created.
*****
Do I run SQL.pl from a browser?

Alex installed it for the first time and I was able to edit Links.pm, templates etc. and everything worked except for the mailing features and that was due to sendmail being off limits.

Thanks,






------------------
Neophyte740

Quote Reply
Re: What's the easiest way to move Links SQL to a new host? In reply to
Just install Links and run the setup.cgi ... make sure to change the Links.pm file to reflect the new server paths (use the IP address and change it to the domain name when the InterNIC catches up -- remember, it can take a week for the change to propagate fully after the InterNIC makes the update).

Setup CGI asks for the database name, userid and password, and sets everything up.

Just click the buttons in order along the bottom of the screen -- create tables, update defs (just for certainty) and then Admin.

You should be up and running at that time.

In the Upgrade.text docs, there is :

Code:
mysqldump -uYOURUSENAME -pYOURPASSWORD --add-drop-table YOURDATABASENAME > backup.txt

This will create a file called backup.txt that is a current snapshot of
your database. You can then restore your database at any time by running:

mysql -uYOURUSERNAME -pYOURPASSWORD YOURDATABASENAME < backup.txt

and all the data will be restored.

This is typed at the command line.

Hopefully this is enabled at your ISP.

Quote Reply
Re: What's the easiest way to move Links SQL to a new host? In reply to
Can people on Virtual servers have permission to download/upload with those commands?
Quote Reply
Re: What's the easiest way to move Links SQL to a new host? In reply to
Ok, the issue isn't "virtual" servers or not.

If your user shell (or system) is set up to allow access to the .../mysql/bin directory, you have access to that command.

There is no real reason to not allow that, since it's just a command line interface and you still need to have a userid and password to do anything to the mysql database or daemon, but it might have been overlooked as an option if the MySQL was installed for perl back end use primarily.

Quote Reply
Re: What's the easiest way to move Links SQL to a new host? In reply to
Thanks.

------------------
Neophyte740