[PHP-DB] How to link a MYSQL table to a dbase file
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
RE: [PHP-DB] How to link a MYSQL table to a dbase file
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: '[EMAIL PROTECTED]' Subject: [PHP-DB] How to link a MYSQL table to a dbase file 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
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
RE: [PHP-DB] How to link a MYSQL table to a dbase file
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
RE: [PHP-DB] How to link a MYSQL table to a dbase file
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: http://www.faqts.com/knowledge_base/view.phtml/aid/1005/fid/436 Gurhan Ozen MCI WorldCom Quality Assurance Team [EMAIL PROTECTED] ph: 703-449-4754 Vnet: 228-4754 AIM: Greywolf1923 -Original Message- From: Marij Bellen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 9: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