Archive for the ‘MySQL’ Category

What is the GUI interface of mongodb referred as

MySQL 7.8.2016 No Comments

  phpMoAdmin – MongoDB GUI administration tool for PHP by- eLite Server Management We Specialize In cPanel Server Management Affordable 24/7 Technical Support Company

Read More

How to install mongodb on cpanel server

MySQL 7.8.2016 No Comments

  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 More

How to extract single table from .sql file

MySQL 7.8.2016 No Comments

  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 More

Change Database collation script

MySQL 7.3.2015 No Comments

<?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 . ” =&gt; ” . $table . ” CONVERTED<br />”; } } ?> by-…

Read More

How to check MYSQL error log

MySQL 7.3.2015 No Comments

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 More

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. 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