|Think about Loose Coupling|
Using multiple MySQL DB's on a Serverby bladx (Chaplain)
|on Jan 12, 2002 at 10:02 UTC||Need Help??|
bladx has asked for the
wisdom of the Perl Monks concerning the following question:
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.
JATU -- Just Another Tilly Underling