Got another fun one:
Trying to run this code/query from a php page:
mysql_connect('localhost', 'dwdc_pps', 'hidden') or die(mysql_error());
mysql_select_db('dwdc_pps') or die(mysql_error());
$q = "SELECT * INTO OUTFILE \"/Macintosh HD/Users/donwieland/Desktop/data_test.csv\"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY \"\n\"
FROM snomed_db";
echo $q;
$result=mysql_query($q) OR die("Error:".mysql_error());
Generating an error: Error:Access denied for user 'dwdc_pps'@'localhost' (using password: YES)
Basically I am trying dump a tables contents LOCALLY on my MAC. This PHP is in a sub-domain of where the mysql database was created.
Any ideas on what my problem is and how to remedy it?
Don Wieland
D W D a t a C o n c e p t s
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
