Open a command line by opening the Start menu, typing "cmd" into the search bar, then clicking "Command Prompt" from the results. Log in to the MySQL server by typing "mysql -u MySQLuser -p ...

The MySQL command line can be a bit daunting at first, but once you get the hang of it, it’ll become second nature. SEE: Server deployment/migration checklist (Tech Pro Research) ...

Whether you're running a LAMP stack on Ubuntu or CentOS, you need to back up your MySQL databases. Learn how to do this with the help of the mysqldump command.

For example, type "mysql -u root -p" (without the quote marks) and enter your password when prompted. Create a MySQL SELECT query to select the data you want to output to CSV.