MySQL Forums
Forum List  »  Microsoft Access

Re: Basic Help with MySQL Tables & Access?
Posted by: Francis Le Quellec
Date: March 16, 2005 11:51AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2935
February 27, 2005 08:13PM
Re: Basic Help with MySQL Tables & Access?
2071
March 16, 2005 11:51AM


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.