How can I extract data for a mysql-table from a dbase file?
This is the situation:
1) we have a dbase-file with data
2) the dbase-file is put on the server
3) we have a mysql-table that needs to get his data out of this dbase-file.
How can I link this mysql-table to this file!
!!note:
Can you use a cron (Unix) or at (Windows) job to dump the dbase data to a
comma-separated-value table? Then suck up the csv into the mysql databasde.
-Original Message-
From: Marij Bellen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 8:37 AM
To: '[EMAIL PROTECTED]'
Cc:
I run my site on a linux webserver.
I don't really know what a cron is?
I can also get a csv file.
I also have a function to translate the dbase-file to sql.
Is a cron a tool or whatever to automatically load data into the database?
==
Can you use a cron (Unix) or at
cron is an application/utility on ALL unix servers. It is used to execute
ANY unix command or script at specified dates, times, etc.
type the following to learn more:
man cron
man ctrontab
your cron job would execute the command to translate the dbase file to sql.
Then execute mysql to read in
Hi Marij,
Cron is a tool in UNIX/LINUX server used to execute commands/programs
automatically in a fixed period basis. You can always read unix man pages to
learn more , just type man cron and man crontab. You may also want to see
this link: