Link to home
Start Free TrialLog in
Avatar of johnyu1997
johnyu1997

asked on

output file location

If I have the mysql server on window xp, I try to export a table to a csv file.  If I run a query like

select * from <table_name> into outfile 'test.csv',

where does the file go?  On Linux, I can find it.  But on window,  I just cannot find it.  I know it is on the server side.  The file is successfully made but just can't find it.
Avatar of Rob
Rob
Flag of Australia image

It's probably in the data directory:

C:\ProgramData\MySQL\MySQL Server 5.1\data
Avatar of johnyu1997
johnyu1997

ASKER

I did a whole search on all my drives in the server and I found nothing.  But when I run the script again, it says the file already exists.
are you running the mysql command on your computer or the server?  if you have mysql installed on your computer then it will be on your computer! :)
I did a full search on the client side also too but just can't find it.
And you're searching hidden locations.  The path I posted above is in a hidden directory "ProgramData"
ASKER CERTIFIED SOLUTION
Avatar of Rob
Rob
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It says it can't read and write to c drive but it can write to my data drive.  Anyway, it works.
Good to hear. There's only so long I can bang my head against the wall before I just walk around it.... :-)