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
