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 Create mongodb.repo file: nano -w mongodb.repo Paste this code inside: [mongodb] name=MongoDB Repo baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/ gpgcheck=0 enabled=1 Install MongoDB using Yum yum install mongo-10gen mongo-10gen-server At this point, you should have MongoDB installed on your CentOS + cPanel box. Configure MongoDB to automatically start after reboot: chkconfig mongod on…
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