DbNinja ເປັນ Open source ທີ່ໃຊ້ສໍາລັບບໍລິຫານຈັດການ Database ທີ່ໜ້າສົນໃຈອີກ 1 ຕົວ ທີ່ເຮົາຈະມາແນະນໍາໃຫ້ຮູ້ຈັກ ເໝາະສົມສໍາລັບ SYSAdmin ທີ່ຕ້ອງດູແລ Database ຫຼາຍເຄື່ອງຜ່ານສູນກາງບ່ອນດຽວ ແລະ ຍັງສາມາດເຮັດວຽກແທນ phpMyAdmin, Adminer, Chive ແລະ ອື່ນໆໂດຍມີຟັງຊັ່ນທີ່ຈໍາເປັນຄົບຖ້ວນຫຼັງຈາກທີ່ເຮົາໄດ້ທົດລອງນໍາໃຊ້ມາແລ້ວ
DBNinja Feature
– 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.
ຂັ້ນຕອນການຕິດຕັ້ງ DbNinja (CentOS 6.5)
1 > ຕິດຕັ້ງ LAMP Server
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm yum -y install httpd mod_ssl yum install php-pear-Net-Socket php-pear php-common php-gd php-devel php php-mbstring php-pear-Mail php-cli php-pear-Auth-SASL php-ldap php-pear-Net-SMTP php-imap php-snmp php-pdo php-xml php-mysql php-fpm php-pecl-json -y service httpd restart chkconfig httpd on
ທົດລອງເວັບ server : http://ip-address
2 > ດາວໂຫຼດ DbNinja ຈາກຜູ້ພັດທະນາ
wget http://www.dbninja.com/download/dbninja.zip unzip dbninja.zip mv dbninja /var/www/html/dbninja chmod 777 /var/www/html/dbninja/_users/
3 > ຕິດຕັ້ງ DbNinja (http://ip-address/dbninja)
กด I Agree
ສາມາດເບິ່ງເລກສໍາລັບ Authen ໄດ້ຈາກ
ls /var/www/html/dbninja/_users
ຕັ້ງຄ່າ Password
ຫຼັງຈາກຕິດຕັ້ງຮຽບຮ້ອຍໃຫ້ລອງເຂົ້າທີ່ http://ip-address/dbninja
ລາຍລະອຽດເພີ່ມເຕີມ
http://www.dbninja.com/
http://www.unixmen.com/manage-databases-hosted-servers-remotely-dbninja/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+unixmenhowtos+%28Unix
