skip to navigation
skip to content

Not Logged In

mysqlrocket 0.1.0

Simple CLI tool to create and delete easily MySQL databases.

MysqlRocket is a Simple CLI tool to create and delete easily MySQL databases.

Flattr this git repo

usage: mysqlrocket [-h] [-v] [-u U] [-H H] [-p P] {bk,dp,mk,ls,rm,st} ...

mysqlrocket commands are:

  • bk Backup all databases on MySQL server
  • dp Dump and gzip a MySQL database
  • mk Create a MySQL database with an dedicated user and a random password
  • ls Show databases on MySQL server
  • rm Delete a MySQL database
  • st Check your mysqlrocket config and MySQL server connectivity

Optional arguments:

  • -h, --help show this help message and exit
  • -v, --version Show program version.
  • -u U mysql user
  • -H H mysql host
  • -p P mysql password

See 'mysqlrocket <command> -h' for more information on a specific command.

PyPI package http://pypi.python.org/pypi/mysqlrocket

Sources https://github.com/cypx/mysqlrocket

Installation

Install it easily:

Using pip

$ pip install mysqlrocket

Using easy_install

On most Linux distribution

$ easy_install mysqlrocket

But on some, prerequisites are required, for example, on Debian 6

$ aptitude install python-pip python2.6-mysqldb

(mysqldb could not be installed by easy_install cause of some system dependencies)

Upgrade

Using pip

$ pip --upgrade mysqlrocket

Using easy_install

$ easy_install --upgrade mysqlrocket

Examples

Create a new database

Create a new database whith an associated user account using the same name and a random password

$ mysqlrocket mk DATABASE_NAME

Create a new database whith an associated user account using the same name and force password

$ mysqlrocket mk DATABASE_NAME -f DATABASE_PASSWORD

Backup databases

Dump all databases avalaible on your server to the current directory

$ mysqlrocket bk

Dump database

Dump a databases to the current directory

$ mysqlrocket dp DATABASE_NAME

Show all databases

Show all databases avalaible on your server

$ mysqlrocket ls

Show all databases avalaible on your server and some information (tables number, size...)

$ mysqlrocket ls -a

Remove a database

Remove a database and all user account with the same name if they exist

$ mysqlrocket rm DATABASE_NAME

Check mysqlrocket configuration

Check your mysqlrocket config file and MySQL server connectivity

$ mysqlrocket st
 
File Type Py Version Uploaded on Size
mysqlrocket-0.1.0.tar.gz (md5) Source 2013-04-26 7KB
  • Downloads (All Versions):
  • 40 downloads in the last day
  • 437 downloads in the last week
  • 1329 downloads in the last month