Download file from mysql coamnd line

MySQL and most databases are designed to be interacted with, so you likely have some sort of programming language connected to MySQL already. Most languages can also write to disk, so you can create your own CSV output scripts by reading fields from the database directly, escaping them properly, and writing a comma-delimited file. The above article may contain affiliate links, which help support CloudSavvy IT. See Section 4.

Using Options on the Command Line. Using Options to Set Program Variables. Command Options for Connecting to the Server. Connection Transport Protocols. Connection Compression Control. Just in case you want to be extra safe you can use the following command and enter the password in the command line input:.

All the top answers are good. But just in case someone wants to run the query from a text file on a remote server AND save results to a file instead of showing on console , you can do this:.

I came here searching for this answer as well, and here is what I found works the best for me: Note I am using Ubuntu Use no quotation. Even if the path contains space ' ' use no quotation at all. For future reference, I've found this to work vs the aforementioned methods, under Windows in your msql console:. If your root drive isn't called "c" then just interchange with what your drive is called. First try backslashes, if they dont work, try the forward slash.

If they also don't work, ensure you have your full file path, the. Finally, the problem was that my folder had a space in the folder name which appearing as a forward-slash in the folder path, once i found and removed it, it worked fine. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 10 months ago. Active 28 days ago. Viewed k times. PiJei 4 4 silver badges 15 15 bronze badges. This option results in nontabular output format and escaping of special characters. See --auto-rehash. See --column-names. Set by default, see --comments to enable. See --line-numbers. See --progress-reports. See --reconnect. Starting with MariaDB In order to verify the server certificate, the user must specify the --ssl-verify-server-cert option.

This option requires that you use the absolute path, not a relative path. This option implies the --ssl option. The directory specified by this option needs to be run through the openssl rehash command. This option is only supported if the client was built with OpenSSL.

This is the default for interactive use, but can be used to produce table output in batch mode. Does not work in batch mode. Disable with --disable-tee. A TLS protocol version will only be enabled if it is present in this list.

All other TLS protocol versions will not be permitted. This option was added in MariaDB See the mysqldump --xml option for more. Option Description --print-defaults Print the program argument list and exit. Available starting with MariaDB For example, mysqldump. This is useful for options like socket and port, which is common between the server and the clients. Command Description? Optional arguments are db and host. Same as quit. Execute an SQL script file.

Takes a file name as an argument. Execute a system shell command. Only works in Unix-like systems. Append everything into given outfile. Takes database name as argument. Might be needed for processing binlog with multi-byte charsets. Comments loading Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB.

The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party. Enable automatic rehashing. No automatic rehashing. Print results using tab as the column separator, with each row on a new line. Directory for character set files. Write column names in results. Preserve comments. Notify the server that this client is prepared to handle expired password sandbox mode even if --batch was specified.