Hi everyone-
This past week, I experienced a terrible occurance having to do with MySQL mainly (as well as Perl, because that is how I can connect to the DB.) For a little background, I have set up and run the whole web site for my High School, for about a month and a half now. It is running on a server, and the main data for news articles, etc. are in one database (with many different tables too). Anyways, what happened this past week is: When I tried to connect to a new database for something else I was working on, it seemed to be working alright. However, the following day, when I came back to the server computer, I found out that all of the MySQL databases where deleted. This was not due to any mischievious deeds or anyone getting into the server itself. I suspect it had to do with me switching the databases when I was was using another DB the previous day. Unfortunately, I was naive enough to think that I wouldn't need to backup my DB for a while, but this happened before I actually did.

My main question is: Is there a way I can be running a server that uses one database in MySQL while I am using another database from either within mysql itself, or through connecting with say DBI in Perl? Or, another view on this problem is, is there an obvious reason (or reasons) why this type of thing would happen?

Thanks for any help, this has bothered me this whole week. Fortunately, we haven't had a lot of articles on the site quite yet, and that means not many things were lost in the lost DB.

Andy Summers
JATU -- Just Another Tilly Underling

In reply to Using multiple MySQL DB's on a Server by bladx

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.