Re: Basic Help with MySQL Tables & Access?
Hi all,
I am sure this question had been asked often but I couldn't for the life of me find anything interesting.
Here it goes:
I want to keep track of changes in my Unix environment by using a mysql database.
I have setup a DB in order to populate it with the data I'm gathering from the machines. This is going good. I have no problem updating the DB by overwriting the actual (old) data with the new data set. I'm doing this thru "LOAD DATA INFILE". It's a small file of about 28KB.
My problem is when I need to update the records for any of the machines in the database, I need to keep the old data somewhere in order to query for the changes. I need to keep data for many months/years.
How should I go about creating my DB in order to do that?
I'm a noobie as far as mysql goes but I am a Unix sysadmin in my daily life.
TIA
Francis
Subject
Views
Written By
Posted
2935
February 27, 2005 08:13PM
2287
February 28, 2005 01:26PM
Re: Basic Help with MySQL Tables & Access?
2071
March 16, 2005 11:51AM
2067
March 31, 2005 06:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.