Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

Simple CLI tool to create and delete easily MySQL databases.

Project Description

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

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
  • fs Flush a MySQL database
  • cp Copy a MySQL database to another
  • ld Import a dump into a 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 to 8)

$ aptitude install python-pip python-mysqldb

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

Manual install

$ git clone https://github.com/cypx/mysqlrocket
$ cd mysqlrocket
$ python setup.py install

Upgrade

Using pip

$ pip install mysqlrocket --upgrade

Using easy_install

$ easy_install --upgrade mysqlrocket

Uninstall

Using pip

$ pip uninstall mysqlrocket

Examples

Create a new database

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

$ mysqlrocket mk DATABASE_NAME

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

$ mysqlrocket mk DATABASE_NAME -f DATABASE_PASSWORD

Backup databases

Dump all databases available 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 available on your server

$ mysqlrocket ls

Show all databases available 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

Copy a database

Copy a database to another (flush destination database if its exist, create if not)

$ mysqlrocket cp SOURCE_DATABASE_NAME DESTINATION_DATABASE_NAME

Load dump file to database

Load dump file to database (flush destination database if its exist, create if not)

$ mysqlrocket ld SOURCE_DATABASE_NAME FILE_PATH

Flush a database

Flush a database (all content will be deleted)

$ mysqlrocket fs DATABASE_NAME

Check mysqlrocket configuration

Check your mysqlrocket config file and MySQL server connectivity

$ mysqlrocket st
Release History

Release History

This version
History Node

0.2.0

History Node

0.1.0

History Node

0.0.17

History Node

0.0.16

History Node

0.0.15

History Node

0.0.14

History Node

0.0.13

History Node

0.0.12

History Node

0.0.11

History Node

0.0.10

History Node

0.0.9

History Node

0.0.8

History Node

0.0.7

History Node

0.0.6

History Node

0.0.5

History Node

0.0.4

History Node

0.0.3

History Node

0.0.2

History Node

0.0.1

Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
mysqlrocket-0.2.0.tar.gz (8.9 kB) Copy SHA256 Checksum SHA256 Source Jan 20, 2016

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting