Exporting from MySQL

[Timbo]

Hi

trying to export some records i'd uploaded to a table with auto-increment so i could preserve the id's. Using the command line MySQL, i cannot save the output to a text file. I'm presuming it's taking the c:\ of my OUTFILE parameter as c:\ on the server as it's giving me an ACCESS DENIED message for the OUTFILE bit. The manual says it should take the same sort of param as LOAD DATA and i uploaded from my local c:\ drive

I tried to export to the root of my site as my user definitely has access to that but to no avail. Manual also says i'd need FILE rights but i can't get SHOW GRANTS to work either

any ideas anyone?

thanks in advance

Tim