mysqlrocket 0.3.1

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)

$ apt-get install python-pip python-mysqldb libmysqlclient-dev

(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

Using pip

$ pip install mysqlrocket --upgrade

Using easy_install

$ easy_install --upgrade mysqlrocket

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