Manage Databases And Hosted Servers Remotely With DbNinja
Database administration via command line is bit difficult for newbie system and database administrators. Because MySQL has numerous commands which we can’t remember all day. If you’re a Webmaster or Database Administrator who managing many remote databases, you’ll definitely need a easy to use tool to mange your remote database servers. This is where DbNinja comes in handy. Unlike other database administration tools such as phpMyAdmin, Adminer, Chive etc., it can manage multiple databases from multiple hosts at the same time from anywhere, using any browser or any operating system.
DbNinja is free and non-commercial advanced web-based application for MySQL database administration and development. It’s a must-have for those who wish to access their hosted servers remotely. DbNinja supports all the latest features including: triggers, events, views, stored routines and foreign keys; in addition it allows to import and backup data and MySQL object structures, manage users and much more. DbNinja has a highly functional and elegant user interface, and can be used securely in any modern browser on any OS.
The brief list of features of DbNinja is given below.
- Manage databases, tables, events, indices, foreign keys and triggers.
- Edit procedures, functions and views.
- Manage and export user accounts and privileges.
- Back-up and restore database structure and data.
- Compare and synchronize databases between hosts.
- Export data into CSV, SQL, Excel and JSON formats.
- Check, repair and optimize tables.
- View and terminate active server connections.
- View system status info and edit system variables.
- Connect to multiple hosts at same time.
- Do tasks simultaneously with tabs-based interface.
- Access all hosts and database objects from a tree view.
- Items can be right-clicked to show context-sensitive menus.
- Edit queries and routines efficiently with syntax highlighting.
- Work with multilingual data – different encodings are supported.
- Preview images and other binary data that’s stored in tables.
- Save your favorite queries for later use.
- Set limits on amounts of fetched data and query execution time.
- Use keyboard shortcuts for common tasks.
Install DbNinja On Linux
Installing DbNinja is pretty easy and straight forward. Please be mindful that DbNinja isn’t free software. It’s free for Personal use only. Please have a look at here for license details for commercial use.
In this tutorial let us see how to setup DbNinja on RHEL/CentOS, Debian/Ubuntu and SUSE/openSUSE distributions. Since DbNinja is web based, we should have a working LAMP stack in our server. Refer the following links to setup LAMP server on your respective distribution.
Now download the latest version of DbNinja from the official download page. Or just enter the following command to directly
# wget http://www.dbninja.com/download/dbninja.zip
Extract the zip file using command:
# unzip dbninja.zip
Move the extracted folder to your webroot folder.
# mv dbninja /var/www/html/dbninja
# mv dbninja /var/www/dbninja
# mv dbninja /srv/www/htdocs/dbninja
Make sure that you have installed the following php modules.
# apt-get install php5-mysql php5-json
# apt-get install php-mysqli php-pecl-jsonc
# zypper install php5-mysql php5-json
Don’t forget to restart apache service after this.
Set the read/write permission to the following directory.
# chmod 777 dbninja/_users/
The rest of the installation is easy. Point your browser to http://ip-address/dbninja or http://domain-name/dbninja/ and follow the onscreen instructions.
At first, you’ll be asked to agree the License agreement and click Continue.
In my case it’s 63905. So just enter it in the box and click Continue.
To Add a new mysql host, Click on the link Manage Hosts on the left In the administrative dashboard. A new window will appear. Click Add host.
That’s it. Happy managing mysql databases.
Like us on Facebook
We need your assistance to stay live
This week Top Posts
- Wow! Linux Foundation To Offer Free Linux Course This Summer Worth $2,400 on EdX : Wow! Early last week it was all over the internet, if you haven't heard it yet then this is the t...2 comments |
- Grive: An Unofficial, Open Source Linux Client For Google Drive : A couple of months before, we have featured a Linux client for Google Drive named Syncdrive, which w...2 comments |
- Top Things To Do After Installing Ubuntu 13.10 'Saucy Salamander' : Ubuntu 13.10 Saucy Salamander will be released on coming October 17th with many new salient featur...0 comments |
- Install Sublime Text 3 In Fedora Easily With Fedy : Sublime Text is a sophisticated text editor for code, markup and prose. In this tutorial we are goi...0 comments |
- How To "Fix E: Could not open file /var/lib/dpkg/status" : QUESTION: I get the following error when I use sudo apt-get update: E: Could not open file /var/...0 comments |
- Install nSnake Game In Terminal : From github repo nsnake is a clone of the classic snake game that we all used to play on our cellp...0 comments |
- News from Kaspersky Lab: Tor is protecting criminals
- Install Satis On Ubuntu Sever 13.10/13.04
- How To Access A LVM Drive / Partition in Ubuntu
- How To Disable Remember Open Files in Sublime Text 3
- Install Sublime Text 3 In Fedora Easily With Fedy
- Grive: An Unofficial, Open Source Linux Client For Google Drive
- Install nSnake Game In Terminal
- How To “Fix E: Could not open file /var/lib/dpkg/status”
- Wow! Linux Foundation To Offer Free Linux Course This Summer Worth $2,400 on EdX
- Fedora 21 Scheduled For Release In October
This work by unixmen.com is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Copyright © 2008-2013 Unixmen.com .