>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only