GoAdmio
← All commands
COMMAND

csv

Export a MySQL/MariadB table to a CSV file

Syntax

csv -s <SQL Query> -o <Output CSV File Name>

Examples

To export Users Table from CRM Database to CSV File
$ /go/csv -s "select * from crm.users" -o users.csv

Related Commands

copydatabase Copy MySQL/MariaDB Database from One GoAdmio Server to Another copytable Copy MySQL/MariaDB Table from One GoAdmio Server to Another innodb2myisam Convert MariaDB/MySQL Tables from InnoDB to MyISAM in GoAdmio installmariadb Install or update MariaDB to the Latest Version installsqlite Installi the Latest SQLite Version on GoAdmio Server mariadb2postgre Convert SQL File from MariaDB to PostgreSQL myisam2aria Convert MariaDB/MySQL Tables from MyISAM to Aria in GoAdmio myisam2innodb Convert MariaDB/MySQL Tables from MyISAM to InnoDB in GoAdmio mysql Create a MySQL Database mysqlsync Copy MySQL Databases from Local to Remote Server sql Create a MySQL database and import an SQL file into it table import a single table from a dump file in MySQL/MariaDB
↑