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
How 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...
How 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...
Change 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 ” ....
How to check MYSQL error log
MySQL log MySQL error log ...
How 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....