List Info

Thread: Connectivity of a Database




Connectivity of a Database
country flaguser name
United States
2007-05-28 13:21:54

Hi All,
I have mysql running in a Solaris server, in which 4 Different databases are there.
Please let me know how do I shutdown any one of the database.

My application refers all 4 DBs at any instance, I need to verify how my application works if any one of the Database is down. How do i do that?

-anbu
Senthil.

---------------------------------
Pinpoint customers who are looking for what you sell.

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___
Re: Connectivity of a Database
country flaguser name
United States
2007-05-31 19:01:43

--- In perl-beginner%40yahoogroups.com">perl-beginneryahoogroups.com, Jack <senthil_jack...> wrote:
&gt;
> Hi All,
>; I have mysql running in a Solaris server, in which 4 Different
databases are there.
&gt; Please let me know how do I shutdown any one of the database.
>
> My application refers all 4 DBs at any instance, I need to verify
how my application works if any one of the Database is down. How do i
do that?
&gt;
> -anbu
&gt; Senthil.
>
>
> ---------------------------------
> Pinpoint customers who are looking for what you sell.
>
> [Non-text portions of this message have been removed]
>

simply issue the statement handel a disconnect .

$dbh->disconnect;

where $dbh is the statement handle you created when you did the
DBI->connect call.

your using DBI.pm correct ?

and your not confusing Data Base Tables with Databases , you say
your connecting to 4 at one time. Not likly to happen with the
standard DBI interface for Perl.

Show your connection code and we can see what your talking about.

Greg

__._,_.___
.

__,_._,___
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )