Mysql

Edit:  /home/mydomain/pathtoroundcube/config/main.inc.php and changed $rcmail_config[‘default_host’] = ‘ssl://imap.site.com’; to $rcmail_config[‘default_host’] = ‘mail.mydomain.com‘;

When I run the following command at mysql> I get an error which read as follows: mysql> use dbname; mysql> show tables; ERROR 1018 (HY000): Can’t read dir of ‘./dbname/’ (errno: 13) Solution to this is to set right permissions #cd /var/lib/ chown mysql.mysql  mysql -R This fixed the issue and can run any commands […]

Facing issues in Virtualizor for database crash ? The mysql library is not located in normal  /var/lib/mysql it located in /usr/local/emps/bin/ To repair database you need to use below command [root@hostabc.virtualizor]# /usr/local/emps/bin/myisamchk -r *.MYI Once completed all things should back to normal :)