Normally, you can't check to see if a database is there before making a connection. Remember that you make a connection to a database server, one that has zero or more databases available. It's the same that you cannot determine whether a URL exists without contacting the server; you can't determine whether an email address exists without asking the appropriate server; and you can't determine whether you still have ice-cream without opening the freezer.

There are of course exceptions. If you have access to the machine the MySQL server runs on, you have the appropriate permissions, you know where the server keeps its datafiles, and you know the structure of said files (and directories), you can find out. You also might be able to find out whether the database exists by peeking in the appropriate log file.

Abigail

In reply to Re: check if databse exists before connection is made! by Abigail-II
in thread check if databse exists before connection is made! by Nik

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.