By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 775 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

mySQL getting .csv file exported to different server

P: n/a

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.
(mySQL now is on a Windows 2003 Server)

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.

Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.