473,574 Members | 2,668 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PHP/mySQL getting .csv file exported

Howdy,

I'm looking for a little help.
I had a W2K server with Apache/PHP/mySQL installed and working. I had
a specific page that ran a mySQL SELECT INTO OUTFILE and dumped the
outfile into a web accessible directory. Now mySQL has been moved to
another server and my SELECT INTO OUTFILE no longer works.

mySQL help tells me SELECT INTO OUTFILE only can create a file on the
local system.
I've tried mapping a directory with no luck.

I looked into running a mysql -e command from the command line using
php's exec() but I can't get the results into a .csv file like I need.

So, can anyone help me with either getting the mysql -e to spit out to
a comma seperated file or point me in another direction to get the
file out of the DB into a .csv file on the webserver?

I hope that made sense.

J-
Jul 17 '05 #1
2 3390
Jason Reljac wrote:
I'm looking for a little help.
I had a W2K server with Apache/PHP/mySQL installed and working. I had
a specific page that ran a mySQL SELECT INTO OUTFILE and dumped the
outfile into a web accessible directory. Now mySQL has been moved to
another server and my SELECT INTO OUTFILE no longer works.

mySQL help tells me SELECT INTO OUTFILE only can create a file on the
local system.


Have you tried with the absolute path?

--
Pieter Nobels
Jul 17 '05 #2
Yep, I tried that and it didn't like that either for some reason.
I think it has something to do with mySQL...

J-

"Pieter Nobels" <pi******@MOVEp cmania.be> wrote in message
news:WD******** *************** @phobos.telenet-ops.be...
Jason Reljac wrote:
I'm looking for a little help.
I had a W2K server with Apache/PHP/mySQL installed and working. I had
a specific page that ran a mySQL SELECT INTO OUTFILE and dumped the
outfile into a web accessible directory. Now mySQL has been moved to
another server and my SELECT INTO OUTFILE no longer works.

mySQL help tells me SELECT INTO OUTFILE only can create a file on the
local system.


Have you tried with the absolute path?

--
Pieter Nobels

Jul 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2578
by: Peter Sullvan | last post by:
Sorry for being a little off-topic, but I guess PHP users are often MySQL users too. We have a few rather advanced calculation routines developed in C++. Currently we are using a Sybase ASA database for our app. and these routines are accessible by so called external functions exported by a DLL (dynamic link library) that we wrote in C++....
0
3936
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest version of this document can be found at: http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download
2
3312
by: Steve | last post by:
Hi. I've got an exported database from an external system. It's in the format of MYI, MYD and frm extension files. However, one table in this database has book.frm, book.MYD, book.MYI _AND_ book.TMD. When I've created a database in phpmyadmin/mysql, moved all the files into the proper directory, every table can be looked at and selected but...
0
1458
by: Jason Reljac | last post by:
Howdy, I'm looking for a little help. I had a W2K server with Apache/PHP/mySQL installed and working. I had a specific page that ran a mySQL SELECT INTO OUTFILE and dumped the outfile into a web accessible directory. Now mySQL has been moved to another server and my SELECT INTO OUTFILE no longer works. mySQL help tells me SELECT INTO...
115
14022
by: TheAd | last post by:
At this moment I use MsAccess and i can build about every databound application i want. Who knows about a serious open source alternative? Because Windows will be a client platform for some time, i prefer a solution that (also) supports Windows. On the net I found a number of products that i looked at, but none of them gave me the impression...
3
4907
by: Xerxes | last post by:
Hi, I would like to import the tables from MySQL database into Access database and I am not sure how to go about it. I tired to "Import External Data" from Access, selected "ODBC database" from file type dropdown, selected "New data source" and picked SQL Server from the list. I specified the server name (mydomain.com) along with user id and...
1
2434
by: gordon.dtr | last post by:
Hi, Has anyone had this problem ? I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11 standard log. I created my tables in MS Access, then exported them via ODBC to an externally hosted MySQL database (fasthosts) . I then import-linked
2
2701
by: David | last post by:
Hi, Has anyone had this problem ? I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11 standard log. I created my tables in MS Access, then exported them via ODBC to an externally hosted MySQL database (fasthosts) . I then import-linked
0
3463
by: NewbieSupreme | last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a table to a text file, tab-delimited, text qualifyer of "none" (this is how I read to do it from newsgroups). When I use the Query window in phpmyadmin to import the text file, it waits a while,...
0
7803
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8044
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8230
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7810
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5618
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5299
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3739
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1056
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.