Member Avatar for 650U

Hi guys,

I am working on a web application project where I use MySQL database. Now I need to export my database/table as a CSV file and I'm using SSH client to access my MySQL. I have no clue how to export it.

I would really appreciate if someone could help me on this!!!

  • 3 Contributors
  • 4 Replies
  • 136 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

You need to read this.

Member Avatar for smantscheff

Use the mysqldump command line tool.
You need something like mysqldump -u[I]user[/I] -p[I]password[/I] [I]database[/I] --tab [I]filename[/I] See mysqldump --help for a complete option list.

Member Avatar for 650U

You need to read this.

Thanks for your link. It was quite useful. But once I exported the file I couldn't find that file anywhere. What should I do to recover my exported file(filename.csv)??

I know its a basic idea but i'm new to this area.

Member Avatar for debasisdas

You need to look in the path from where you executed the command.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.