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
- Download and install ActivePython
- Open Command Prompt
- Type
pypm install mysqlrocket
| Python 2.7 | Python 3.2 | Python 3.3 |
---|
Windows (32-bit) | | | |
---|
Windows (64-bit) | | | |
---|
Mac OS X (10.5+) | | | |
---|
Linux (32-bit) | | | |
---|
Linux (64-bit) | | | |
---|
Lastest release
version 0.1.0 on Jan 9th, 2014
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
- 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