Versions des environnements
>I have a web site working fine with a MySQL Database but I am having great difficulty getting data out of it for processing in VFP.
>
>I developed a Remote View with ODBC which worked fine on my local host but it appears that there are security issues that prevent me from applying this technique to my public host. They have given me a very primitive interface which I would like to avoid if possible.
>
>I am only interested in one or the 6 tables. Is there anyway of exporting the data in a table from MySQL?
>
Select * from myTable INTO OUTFILE /some/silly/linux/path.txt
Check permissions to be sure you can write into your chosen dir.
you can see the syntax on MySQL.com
You have to specify the field delimiters and record delimiters.
Load Data Infile
and
Select into Outfile
are really awesome commands for bulk loading and bulk exporting.
ALSO
PhpMyAdmin will dump your entire database if it is more of a one time thing.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement