|
Home > Archive > MySQL Server Forum > August 2005 > DBI with mysqld
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Jay Vollmer 2005-08-07, 3:23 am |
| Hi everybody.
Can I use DBI to interface Perl with mysqld running locally rather than
with a 'true' MySQL server?
If not DBI, how can I do this?
aTdHvAaNnKcSe
--
JAY VOLLMER
JVOLLMER@VISI.COM
| |
| Malcolm Dew-Jones 2005-08-07, 3:23 am |
| Jay Vollmer (jvollmer@visi.com) wrote:
: Hi everybody.
: Can I use DBI to interface Perl with mysqld running locally rather than
: with a 'true' MySQL server?
: If not DBI, how can I do this?
All modern computer systems are capable of being "servers" (though some
OS's are crippled on purpose to force you to buy a more expensive "server"
versions).
If you have a mysql database installed and the mysql processes running on
your local computer then your local computer is the mysql server.
In that case you can use DBI (with perl) to access the database. Just use
"localhost" as the server name.
If you mean that you have database _files_ but aren't running the mysql
processes then I don't know of any tool to access the database tables,
though data dump tools may exist (but I doubt they would allow you to do
updates or "normal" queries).
I suspect you are just confused. Normally a mysql installation will
include files containing data and programs that are started when the
computer is booted that are the processes with which you can communicate
to access the data. You can use the mysql client program, or DBI (in
perl) or various other libraries with other languages to talk to the
processes so as to access the data.
--
This space not for rent.
| |
| Jay Vollmer 2005-08-07, 3:23 am |
| On Sat, 06 Aug 2005 21:28:00 -0800, Malcolm Dew-Jones wrote:
> Jay Vollmer (jvollmer@visi.com) wrote:
> : Hi everybody.
>
> : Can I use DBI to interface Perl with mysqld running locally rather than
> : with a 'true' MySQL server?
>
> : If not DBI, how can I do this?
> If you have a mysql database installed and the mysql processes running on
> your local computer then your local computer is the mysql server.
>
> In that case you can use DBI (with perl) to access the database. Just use
> "localhost" as the server name.
Thanks for the reply. In answer; I tried using localhost, but it doesn't
work.
--
JAY VOLLMER
JVOLLMER@VISI.COM
| |
| Malcolm Dew-Jones 2005-08-07, 3:23 am |
| Jay Vollmer (jvollmer@visi.com) wrote:
: On Sat, 06 Aug 2005 21:28:00 -0800, Malcolm Dew-Jones wrote:
: > Jay Vollmer (jvollmer@visi.com) wrote:
: > : Hi everybody.
: >
: > : Can I use DBI to interface Perl with mysqld running locally rather than
: > : with a 'true' MySQL server?
: >
: > : If not DBI, how can I do this?
: > If you have a mysql database installed and the mysql processes running on
: > your local computer then your local computer is the mysql server.
: >
: > In that case you can use DBI (with perl) to access the database. Just use
: > "localhost" as the server name.
: Thanks for the reply. In answer; I tried using localhost, but it doesn't
: work.
"it doesn't work." is not a good enough description. Many things could be
wrong. At a minimum you need to tell us the exact error message and error
code, and also show us a minimal script that doesn't work.
--
This space not for rent.
|
|
|
|
|