There is no official PHPMyAdmin Command Line Tool but a repository exists to get some functions on CLI, additionally MySQL has CLI functions. Like in a recently published article we talked about the growing importance of Database as a Service, we talked about How to Connect to MySQL Database Server Remotely, which will probably help the new users more.
MySQL, PHPMyAdmin and Command Line Tools
The Python repository which has some functions like PHPMyAdmin, which we talked before is hosted on GitHub :
1 | https://github.com/AbhishekGhosh/phpmyadmin-cli |
If you want to use this phpmyadmin-cli app, you need to have :
- Python (version 2.6 or above)
- prettytable (Python library for easily displaying tabular data in a visually appealing ASCII table format)
- Requests (A HTTP library, written in Python)
- PHPMyAdmin itself
The source of the pretty table and Requests can be found here :
1 2 | https://github.com/kennethreitz/requests/ https://code.google.com/p/prettytable/ |
Setup of PHPMyAdmin Command Line Tool
We will suggest to download the repositories or wget them to avoid installing git and subversion if you want to build from source code, obviously on a production server, you will not love to increase the number of running daemons. For pretty table, installation is easy with Python PIP or easy_install :
Advertisement---
1 2 3 4 5 6 7 8 9 10 11 12 | easy_install prettytable easy_install requests # or with pip install pip install requests # not tested pip install prettytable # important # officially you should install requests in this way curl -OL https://github.com/kennethreitz/requests/zipball/master # run -xzvf to extract the tar ball, cd to the directory with # executable and call python setup python setup.py install |
You will install PHPMyAdmin normally but you can avoid the browser based access. Now to install PHPMyAdmin-CLI, you have to work in this way :
1 2 3 4 | curl -OL https://github.com/fdev/phpmyadmin-cli/zipball/master # run -xzvf to extract the tar ball, cd to the directory with # executable and call python setup python setup.py install |
This way of installing will probably avoid the permission related issues. The usage pattern of the software is :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | phpmyadmin-cli <OPTION> <database-name> # Example phpmyadmin-cli test-database < database.sql # you can invoke the interactive mode by typing this phpmyadmin-cli # this will return some info and the interactive mode phpmyadmin> # you can type the command directly phpmyadmin> SHOW TABLES; # result +------------------------+ | Tables_in_testdatabase | +------------------------+ | article | | comment | | user | | access_log | +------------------------+ Query OK, 4 rows (0.05 sec) |
As we know, MySQL itself has interactive mode :
1 2 3 4 5 | http://dev.mysql.com/doc/refman/5.6/en/mysql.html # invoking mysql returns mysql> # run help mysql> help |
Like we have written in How to Export WordPress MySQL Database on Rackspace Deployment, you can use quite easy commands to do basic works. MySQL is a software and it depends how you will use it.
