cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL OUTFILE exporting data

Highlighted
Newbie
Posts: 7
Registered: ‎21-08-2007

MySQL OUTFILE exporting data

I'm quite new to the MySQL stuff and have searched the net for an answer to exporting (backup) all the data from a table.
I have tried the command localy (localhost) and it works fine but when i use the PlusMySQLAdmin interface it returns an error. Can someone help please?
Heres the command I'm using:
SELECT * INTO OUTFILE 'C:/backup.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM myTable;
3 REPLIES 3
Highlighted
Grafter
Posts: 393
Registered: ‎26-07-2007

Re: MySQL OUTFILE exporting data

Quote
I have tried the command localy (localhost) and it works fine

Do you mean your own MySQL installation, if so is it version 4 like Plusnet?
Why don't you use the MySQL Dump program instead, it seems to be what most people use?
Highlighted
Newbie
Posts: 7
Registered: ‎21-08-2007

Re: MySQL OUTFILE exporting data

Like i explained, I'm faily new to this. Whats the MySQL dump?
Highlighted
Newbie
Posts: 7
Registered: ‎21-08-2007

Re: MySQL OUTFILE exporting data

I think I found it. Sorry had a blonde moment ???.
I've been going about it all the wrong way. I've been using command lines to develop my databases and should have realised that the wheel has already been invented....
Thanks for kicking my brain into gear.