Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

Working with Links SQL 2.0

Quote Reply
Working with Links SQL 2.0
Hi,
I worked previously with Links 2.0 offline by making some arrangements. Now, can anybody tell me how to work offline with Links SQL 2.0. What must I do to achieve this matter?
Thanks,

wewe
Quote Reply
Re: Working with Links SQL 2.0 In reply to
what do you mean?

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://LinkSQL.com/FAQ


Quote Reply
Re: Working with Links SQL 2.0 In reply to
You have to do the following:

1) Install DBI and Time::HighRes module from http://www.cpan.org.
2) Install MySQL from http://www.mysql.com.
3) Install Links SQL.

That should do it.

Regards,

Eliot Lee
Quote Reply
Re: Working with Links SQL 2.0 In reply to
I meant to build my DB offline. Then upload it later to comsume less time on internet connection.
Is my question clear now?

wewe
Quote Reply
Re: Working with Links SQL 2.0 In reply to
Thanks Eliot,
You always help me.
Regards,

wewe
Quote Reply
Re: Working with Links SQL 2.0 In reply to
You're welcome.

Of course, the other option is to use MS Access to create your tables and insert values into the tables via forms. Then you could export the tables into tab delimited text files and then IMPORT the files into your MYSQL tables. (Although inserting the correct values into the CATLINKS table would be quite tricky.)

But since you want to build your directory "off-line", then the best solution is the one I presented earlier, which is to install all the appropriate apps and modules, then build locally and FTP the built pages to your server.

Regards,

Eliot Lee
Quote Reply
Re: Working with Links SQL 2.0 In reply to
For future reference, it would help to also give your operating system, (Windows or Unix) and if your server runs the same OS.

Doing it off line, can have problems. Database syncing, such as not losing hit and rate counts can be a problem.

It's much harder to import off-line data into the 2.0 SQL version than into any other version, because the table relationships and data relationships are much more complex.



PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://LinkSQL.com/FAQ


Quote Reply
Re: Working with Links SQL 2.0 In reply to
Perl may be useful too Smile

Paul Wilson.
new - http://www.wiredon.net
Quote Reply
Re: Working with Links SQL 2.0 In reply to
Dear PUGDOG,
Sorry for not mentioning the operating system, it is windows 2000, however the server OS (online working) is Linux.
Please clarify your reply. Did you read Eliot Lee's response?
In fact, I worked previously with Links 2.0 script and Eliot was the one who advised me how to work with it offline. And it worked properly, then I FTP the DB and made some modification in the configuration. So according to your response do you think that this will not work with Links SQL 2.0? Does it have any difference?

wewe
Quote Reply
Re: Working with Links SQL 2.0 In reply to
Thanks, I have already Perl and apache by which I worked with Links2.0

wewe
Quote Reply
MySQL specific. In reply to
Dear Eliot,
When I tried to install Mysql I found that there are different releases for different OS. Please note that I'm using Windows2000 in the local host and using Linux in the online server. The question now is: If I work with Windows release MySQL on the local server and build the DB can I then FTP the resulting DB and work properly later with it on the server with the Linux release. If not, Can you suggest a solution?
Thanks in advance,

wewe
Quote Reply
Re: MySQL specific. In reply to
You will NOT be FTPing the DATABASE FILES! You will have to do the following:

1) SQL DUMP of all tables in your LINKS database (which will dump all data from your tables).

2) Then you will have to do a MASS IMPORT of the DUMPED tables.

You need to get away from the flat file concept of "database"...it is totally different in the RELATIONAL world of SQL.

Regards,

Eliot Lee
Quote Reply
Re: Working with Links SQL 2.0 In reply to
As eliot pointed out, working with SQL is completely different.

But, you need to understand that what you download and work with, will be out of sync with what is going on-online.

It's much better to work with the databases on-line, and just download backup copies.

PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
Quote Reply
Working with Links SQL 2.0 Problems In reply to
Dear Eliot and Pugdog,
I want to clarify that I need to build the first DB offline, i.e. building the basic categories, then after having a basic DB I will continue online.So I think it doesn't matter if I follow this way for a while. Also, I hope you advise me more about working with MySQL, I have a limited knowledge in DB environment since I worked a little previously in Oracle (just building tables, print them, and retrieve data from these tables).
As I think the hit and rate count may happen after moving to working online when I get the DB built and so I can save the time of being connected in building the categories.
Another question that I have is: Is there anything help in extracting the DB I had built previously in Links2.0 to save the time needed to repeat these data?
Thanks in advance,

wewe
Quote Reply
Re: Working with Links SQL 2.0 Problems In reply to
It would be better to do it ONLINE...This ain't anything like LINKS 2.0 (flat file version). To make sure that you have everything set-up properly...you should take advantage of the included installation service that Gossamer Threads offers.

You need to get away from the mindset of flat file systems and also Links 2.0. The LOGIC in LINKS SQL v.2.X is light years away from Links 2.0 (flat file).

Regards,

Eliot Lee
Quote Reply
Re: Working with Links SQL 2.0 Problems In reply to
I have to agree with Eliot. You need to completely re-think what you are doing. Think of MySQl as a magic black box. Your data goes in, and your data comes out, but you DO NOT TOUCH the database itself. You ASK it questions, and it answers you. You feed it data, and it organizes for you. But, get your hands in the way, and it will bite them off.

If you want to run a local database, you need to install MySQL on your local machine. The Windows version is _NOT_ completely compatible with the Unix version. They are somewhat different. You can move your data UP to the Unix version, but moving DOWN to the Windows version can create some problems (due to Windows, more than anything else).

If you are running Linux on your local machine, you can set up MySQL on your local machine, get your database working, then "mysqldump" it, upload that file, then "mysqlimport" the file into your servers copy of MySQL. This will OVERWRITE any and all data in that database, and create an EXACT COPY of the database from your local machine to the Server's copy of mysql.

During development, this might be what you want, but in operation, this is a _VERY_BAD_THING_ to do.

All Input/Output has to go through the MySQL engine, and you can't play games with it by just adding a few lines on at the end of the database (like the flat file). It won't work. You have to feed the data in, following the rules, let MySQL digest it, and then you can work with it.

There are a number of good books on MySQL and SQL in general. I really wish I had the time to add them to the FAQ....

PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
Quote Reply
Re: Working with Links SQL 2.0 Problems In reply to
In Reply To:
The Windows version is _NOT_ completely compatible with the Unix version.
Really? Most things should work almost the same, with the main difference being the windows version won't care about case, but the unix version does.

If you want to develop your database initially, you can do so offline. Setting up Links SQL locally is not too difficult. When you are done, you can use mysqldump to recreate your database on the production server.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Working with Links SQL 2.0 Problems In reply to
Thanks all.

wewe
Quote Reply
Working with MySQL on Windows 2000 In reply to
Hi everybody,
I tried to proceed with working offline with Links SQL 2.0, so I did what is required to succeed with this. However, when I installed MySQL Version 3.23.28-gamma, I tried to start it but a dos window opened without any info then closed directly. Can anybody advise me how to fix the problem if existed or to know what is the matter?
Thanks in advance,

wewe
Quote Reply
Re: Working with MySQL on Windows 2000 In reply to
Hi,

That is normal - the window pops up as mysql is executed and then hides itself.

You will probably have a mysqladmin icon in your taskbar now.

Paul Wilson.
Installations:
http://www.wiredon.net/gt/
Quote Reply
Re: Working with MySQL on Windows 2000 In reply to
Thanks.
In fact, yes I had this icon and run the mysqladmin. The now is how make account in mysqlserver and how to have a server name, username and password to input in Links sql 2.0 setup in order to operate it normally on windows2000.
Also, is there any specific configuration I have to do to let the mysql work properly and benefit from it with other scripts.
Thanks for your help.

wewe
Quote Reply
Re: Working with MySQL on Windows 2000 In reply to
Read documents at http://www.mysql.com.

Regards,

Eliot Lee
Quote Reply
Re: Working with MySQL on Windows 2000 In reply to
i would recommend www.nusphere.com for an all in one (and free) installation of perl, php and mysql. Took me 5 minutes to install the lot.

http://www.ASciFi.com/ - The Science Fiction Portal