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 https://pypi.org/project/mysqlrocket/
Sources https://github.com/cypx/mysqlrocket
Installation
Install it easily:
Using pip
$ pip install mysqlrocketUsing easy_install
On most Linux distribution
$ easy_install mysqlrocketBut 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 installUpgrade
Using pip
$ pip install mysqlrocket --upgradeUsing easy_install
$ easy_install --upgrade mysqlrocketUninstall
Using pip
$ pip uninstall mysqlrocketExamples
Create a new database
Create a new database with an associated user account using the same name and a random password
$ mysqlrocket mk DATABASE_NAMECreate a new database with an associated user account using the same name and force password
$ mysqlrocket mk DATABASE_NAME -f DATABASE_PASSWORDBackup databases
Dump all databases available on your server to the current directory
$ mysqlrocket bkDump database
Dump a databases to the current directory
$ mysqlrocket dp DATABASE_NAMEShow all databases
Show all databases available on your server
$ mysqlrocket lsShow all databases available on your server and some information (tables number, size…)
$ mysqlrocket ls -aRemove a database
Remove a database and all user account with the same name if they exist
$ mysqlrocket rm DATABASE_NAMECopy a database
Copy a database to another (flush destination database if its exist, create if not)
$ mysqlrocket cp SOURCE_DATABASE_NAME DESTINATION_DATABASE_NAMELoad dump file to database
Load dump file to database (flush destination database if its exist, create if not)
$ mysqlrocket ld SOURCE_DATABASE_NAME FILE_PATHFlush a database
Flush a database (all content will be deleted)
$ mysqlrocket fs DATABASE_NAMECheck mysqlrocket configuration
Check your mysqlrocket config file and MySQL server connectivity
$ mysqlrocket st
