Hi, Eric.
What I'm trying to do is have my install program check to see if a database
of a certain name exists, if it does then the install needs to create
another one (using a name given by the user), if not then it needs to create
it with the original name.
But I cannot figure out how to connect to mysql without already having a
database setup.
I'll use dbtemp as an example db.
I can try to connect to dbtemp and if it successful, I know it exists. So I
prompt the user to enter another db name. I can then check if this exists
and if it doesn't I can use the dbi to create the new db WHILE I am still
connected to dbtemp.
If dbtemp does not exist I need to create it. The problem is dbi needs to
connect to a database even to create another one. So what/how do I connect
to initially to create that first database?
I realize, for geeks (myself included), that you could simply create the db
manually and then install the program.. but the program is to be usable by
the layperson.. which means that there is a chance they don't know anything
about mysql other than the guy on tech support said it's installed on the
server.
How do I connect to mysql without connecting to a database?
John
-----Original Message-----
From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 1:21 PM
To: John Tsangaris; [EMAIL PROTECTED]
Subject: Re: Perl DBI
Connect to the mysql database if you have access. It always exists.
----- Original Message -----
From: "John Tsangaris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 1:58 PM
Subject: Perl DBI
> Is it possible to connect to mysql without connecting directly to a
> database, check to see if a particular database exists, and if it doesn't
> exist create it?
>
> I have not been able to find a way of connecting to mysql without having a
> database already (I want perl to be able to make the db.. not have it
> already made before hand.)
>
> tia
>
> John
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
