What is the GUI interface of mongodb referred as
phpMoAdmin – MongoDB GUI administration tool for PHP by- eLite Server Management We Specialize In cPanel Server Management Affordable 24/7 Technical Support Company
Read MoreHow to install mongodb on cpanel server
Install the MongoDB repo cd /etc/yum.repos.d nano -w mongodb.repo Paste below code inside [mongodb] name=MongoDB Repo baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/ gpgcheck=0 enabled=1 Install MongoDB package using Yum yum install mongo-10gen mongo-10gen-server Configure MongoDB to automatically start after reboot chkconfig mongod on service mongod start Install MongoDB PHP Extension pecl install mongo Restart Apache to apply changes service httpd…
Read MoreHow to extract single table from .sql file
awk ‘/– Table structure for table .tbl_first./,/– Table structure for table .tbl_second./{print}’ mydumpfile.sql > mytable.sql by- eLite Server Management We Specialize In cPanel Server Management Affordable 24/7 Technical Support Company
Read MoreChange Database collation script
<?php // your connection mysql_connect(“localhost”,”root”,”notime”); mysql_select_db(“medrek_test”); // convert code $res = mysql_query(“SHOW TABLES”); while ($row = mysql_fetch_array($res)) { foreach ($row as $key => $table) { mysql_query(“ALTER TABLE ” . $table . ” CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci”); echo $key . ” => ” . $table . ” CONVERTED<br />”; } } ?> by-…
Read MoreHow to check MYSQL error log
MySQL log MySQL error log /var/lib/mysql/{SERVER_NAME}.err MySQL slow query log (if enabled in my.cnf) /var/log/slowqueries by- eLite Server Management We Specialize In cPanel Server Management…
Read MoreHow to upgrade mysql with cloudlinux and cpanel
Using the mysql upgrade option in cpanel will not work with cloud Linux Please make sure to take backup of mysql folder in tar as well as .sql format. For upgrading to MySQL 5.5(for example), you should to do: /usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55 /usr/share/lve/dbgovernor/db-select-mysql –install-now That’s it root@bima [~]# mysql -V mysql Ver 14.14 Distrib 5.5.34, for…
Read More