Mysql Export

petenyce · 09-29-2005, 11:49 AM

im trying to create a script that outputs my mysql table data to a csv file. Now i cant get it to write a file? is their something wrong with permissions? i have all privilidges, im looged in as root.. Do i need brackets nothing seems to be working. i have full read write priviledges

thanks

test.sh
/usr/bin/mysql -h localhost -u root ehpadmin </usr/etc/referral.sql

referral.sql
select * INTO OUTFILE '/usr/etc/ReferralAuth.txt'
FIELDS Terminated BY ';' Lines Terminated by '\n' from ehpadmin.referral_Authorization

Hko · 09-29-2005, 01:04 PM

You say you're logged in as "root". Did you mean on the system as well? Or are you logged in as "root" only in the database?

One possible reason:
You don't have write permissions to the /usr/etc/ directory. Try this:

Code:

select * INTO OUTFILE '/tmp/ReferralAuth.txt'
FIELDS Terminated BY ';' Lines Terminated by '\n' from ehpadmin.referral_Authorization

(normally every Linux use has write permissions to /tmp)

If it still does not work, check this page for possible reasons for "access denied".