List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 10 2000 7:48pm
Subject:Re: Dumping table to CSV file
View as plain text  
At 5:41 PM -0200 12/10/00, Nando2 wrote:
>Hello everybody,
>
>I'm trying to use mysqldump to dump one of my tables to a CSV text 
>file (a file with fields separated by ;).
>
>The name od the table is tbl_id and it is located inside db_parts database
>
>So I've tried many command syntax and none seems to work.
>
>I have tried this :  mysqldump -h localhost -u root -ppassword 
>db_parts tbl_id --fields_terminated-by=';' < tbl_id.csv
>
>What I'm trying to say is : dump the data from db_parts.tbl_id into 
>file called tbl_id.csv and make the table fields separated by ;
>
>The command doesn't work this way. Can anyone point me how to write 
>this dump command?
>
>Thank you,
>
>Carlos Fernando.

All the options beginning with - or -- must precede the database and
table name.

-- 
Paul DuBois, paul@stripped
Thread
Dumping table to CSV fileNando210 Dec
  • Re: Dumping table to CSV filePaul DuBois10 Dec
  • Re: Dumping table to CSV fileNando210 Dec
    • RE: Dumping table to CSV fileSales-DataTrak Business Solutions10 Dec
      • Re: Dumping table to CSV fileCarlos Fernando Scheidecker Antunes10 Dec
    • Re: Dumping table to CSV filePaul DuBois10 Dec
RE: Dumping table to CSV fileQuentin Bennett10 Dec
  • Re: Dumping table to CSV fileNando210 Dec
  • Re: Dumping table to CSV fileNando210 Dec
RE: Dumping table to CSV fileQuentin Bennett10 Dec
  • Re: Dumping table to CSV fileNando210 Dec