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 the sql file


-----Original Message-----
From: Marij Bellen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 8:57 AM
To: Php-Db@Lists. Php.Net (E-mail)
Subject: Re: [PHP-DB] How to link a MYSQL table to a dbase file 


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 (Windows) job to dump the dbase data to a
 comma-separated-value table? Then suck up the csv into the mysql databasde.
 
=================
> 
> 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:
> -------
> I don't mean how I can put the data of the dbase-file into the table,
> but the table should be linked to the dbase file to get its data!
> 
> Background:
> -----------
> we want to upload a file with data from our own local database each night
> to our internet-mysql-database.
> 
> In MS-access such a file is called a 'external table.'
> 
> If this isn't possible and we don't have the ability to use the
> php-dbase-functions (because of our provider),
> 
> is there another solution to get the data from the dbase-file
automatically
> in the mysql-database?
> 
> Can you help me!!
> 
> Thanks.
> 
> 
> 
> -- 
> PHP Database Mailing List (<http://www.php.net/)>
> To unsubscribe, visit: <http://www.php.net/unsub.php>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to