Welcome, guest | Sign In | My Account | Store | Cart

Notice! PyPM is being replaced with the ActiveState Platform, which enhances PyPM’s build and deploy capabilities. Create your free Platform account to download ActivePython or customize Python with the packages you require and get automatic updates.

Download
ActivePython
INSTALL>
pypm install mysqlrocket

How to install mysqlrocket

  1. Download and install ActivePython
  2. Open Command Prompt
  3. Type pypm install mysqlrocket
 Python 2.7Python 3.2Python 3.3
Windows (32-bit)
Windows (64-bit)
Mac OS X (10.5+)
Linux (32-bit)
Linux (64-bit)
0.1.0 Available View build log
 
License
GPL
Imports
Lastest release
version 0.1.0 on Jan 9th, 2014

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

System Message: ERROR/3 (<string>, line 42)

Unknown directive type "code-block".

.. code-block:: bash

        $ pip install mysqlrocket

Using easy_install

On most Linux distribution

System Message: ERROR/3 (<string>, line 51)

Unknown directive type "code-block".

.. code-block:: bash

        $ easy_install mysqlrocket

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

System Message: ERROR/3 (<string>, line 57)

Unknown directive type "code-block".

.. code-block:: bash

        $ aptitude install python-pip python2.6-mysqldb

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

Upgrade

Using pip

System Message: ERROR/3 (<string>, line 69)

Unknown directive type "code-block".

.. code-block:: bash

        $ pip --upgrade mysqlrocket

Using easy_install

System Message: ERROR/3 (<string>, line 76)

Unknown directive type "code-block".

.. code-block:: bash

        $ 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

System Message: ERROR/3 (<string>, line 88)

Unknown directive type "code-block".

.. code-block:: bash

        $ mysqlrocket mk DATABASE_NAME

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

System Message: ERROR/3 (<string>, line 94)

Unknown directive type "code-block".

.. code-block:: bash

        $ mysqlrocket mk DATABASE_NAME -f DATABASE_PASSWORD

Backup databases

Dump all databases avalaible on your server to the current directory

System Message: ERROR/3 (<string>, line 103)

Unknown directive type "code-block".

.. code-block:: bash

        $ mysqlrocket bk

Dump database

Dump a databases to the current directory

System Message: ERROR/3 (<string>, line 112)

Unknown directive type "code-block".

.. code-block:: bash

        $ mysqlrocket dp DATABASE_NAME


Show all databases

Show all databases avalaible on your server

System Message: ERROR/3 (<string>, line 122)

Unknown directive type "code-block".

.. code-block:: bash

        $ mysqlrocket ls

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

System Message: ERROR/3 (<string>, line 128)

Unknown directive type "code-block".

.. code-block:: bash

        $ mysqlrocket ls -a

Remove a database

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

System Message: ERROR/3 (<string>, line 137)

Unknown directive type "code-block".

.. code-block:: bash

        $ mysqlrocket rm DATABASE_NAME


Check mysqlrocket configuration

Check your mysqlrocket config file and MySQL server connectivity

System Message: ERROR/3 (<string>, line 147)

Unknown directive type "code-block".

.. code-block:: bash

        $ mysqlrocket st




Subscribe to package updates

Last updated Jan 9th, 2014

What does the lock icon mean?

Builds marked with a lock icon are only available via PyPM to users with a current ActivePython Business Edition subscription.

Need custom builds or support?

ActivePython Enterprise Edition guarantees priority access to technical support, indemnification, expert consulting and quality-assured language builds.

Plan on re-distributing ActivePython?

Get re-distribution rights and eliminate legal risks with ActivePython OEM Edition.