Viewing 1 to 10 of 16 items
Tag Archives: mysql

How do I find mysql root password in Ensim server?

Ensim was a popular control panel usually installed on linux servers as well as windows servers. Here is the command which you may execute on your ssh console of the server and will output the mysql root password cd /usr/lib/opcenter/mysql/ && python2.2 -c ‘from mysqlbe import *; print read_mysqlpass();’   PS. If you have a  Full Article…

0

Steps to restore an innodb database

Below are the steps to restore mysql database with innodb tables , without contacting r1soft. Set up a temporary mysql “sandbox” instance  using the innodb files and the fil ebased backups of  the database and create a mysql dump of the database. 1. restore these files to a temporary directory  /dbrestore  /var/lib/mysql/ibdata1  /var/lib/mysql/ib_logfile0  /var/lib/mysql/ib_logfile1  (restore to “alternate  Full Article…

0

Optimize database using phpMyAdmin

Over a time as your website add contents to it’s database, the files/tables will become fragmented resulting in slower performance. Optimizing the database will essentially defragment the files, and is something you should perform regularily if you do have a busy website. Log into cPanel, and click on the PHPMyAdmin icon in the database section,  Full Article…

0

Mysql database size not showing in cpanel

You may see the mysql database size is zero in cPanel >> Mysql Databases, though the databases contains tables and data. In order to include the size of the databases while displaying disk usage in cPanel/WHM, use either of the following steps: 1) SSH to your server as root and edit the cpanel.config file #  Full Article…

0

Reset mysql password if root password is not known

One of the common issue encountered by server admins while manging mysql is that, the root passwords are unknown. We can reset the root password for getting into the mysql prompt by following the below steps.   Stop mysql service /etc/init.d/mysql stop Start to MySQL server w/o password mysqld_safe –skip-grant-tables & Connect to mysql server  Full Article…

0

Performance Tuning Scripts for Mysql

  Performance Tuning Primer Script is the shell script which gets performance related information from MySQL engine and produce some recommendations for tuning of MySQL server variables. It’s easy to use and offers valuable output for MySQL performance optimization. tuning-primer.sh Performance Tuning Primer Script Usage [*] Download the shell script here. [*] Upload the shell  Full Article…

0

Databases missing in cPanel

  In some cases cPanel will not show the databases in cPanel>>Databases>>MySQL database; though the database is present in /var/lib/mysql/ folder with the contents in it, hence it is clear that the database are not lost from the server. The issue is due to the permission conflict to the folder /var/cpanel/databases/, the permission should be  Full Article…

0

InnoDB

  MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default storage engine chosen by MySQL database, when creating a new table. The default engine is MyISAM which is very fast but does not support higher level functionality such as foreign keys or transactions. # mysql> SHOW  Full Article…

0

Remove e-mail accounts in plesk server

There might be instances when the removal of email accounts from frontend fails in plesk control panel. One of the following 2 methods can be used to resolve the issue: ♦ Remove the mail account via SSH. # /usr/local/psa/bin/mail –remove email@domain.tld ♦ If the above method doesn’t work, remove the email account from the Plesk  Full Article…

0