Skip to content

list_mysql_databases

Martin Asser Hansen edited this page Oct 2, 2015 · 6 revisions

Biopiece: list_mysql_databases

Description

List all MySQL databases available by using list_mysql_databases, which uses the system's ´mysqlshow´. Each database is output as a Biopiece record.

See how to setup default MySQL username and password here: http://code.google.com/p/biopieces/wiki/HowTo#Howto_setup_default_MySQL_username_and_password

Usage

list_genomes [options]

Options


[-?          | --help]               #  Print full usage description.
[-u <string> | --user=<string>]      #  MySQL user           -  Default=<from ~/.biopiecesrc>
[-p <string> | --password=<string>]  #  MySQL user password  -  Default=<from ~/.biopiecesrc>
[-v          | --verbose]            #  Verbose output.

Examples

To list all MySQL databases use list_mysql_databases:

list_mysql_databases                                

DATABASE: information_schema
---
DATABASE: mysql
---
DATABASE: test
---

See also

list_mysql_databases

read_mysql

remove_mysql_tables

write_mysql

Author

Martin Asser Hansen - Copyright (C) - All rights reserved.

[email protected]

July 2009

License

GNU General Public License version 2

http://www.gnu.org/copyleft/gpl.html

Help

list_mysql_databases is part of the Biopieces framework.

http://www.biopieces.org

Clone this wiki locally