Mysql server and InnoDB engine must to be running!
Check mysql connection:
cat /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php |grep mysql: $config['db_dsnw'] = 'mysql://roundcube:lasMubMX08D3HKtr@unix(/var/lib/mysql/mysql.sock)/roundcube';
mysql -u roundcube -p
show tables;
All tables should be in place:
+---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | cache_index | | cache_messages | | cache_shared | | cache_thread | | contactgroupmembers | | contactgroups | | contacts | | cp_schema_version | | dictionary | | identities | | searches | | session | | system | | users | +---------------------+ 15 rows in set (0.00 sec)
Cpanel keeps roundcube backups here:
/var/cpanel/roundcube
Go ahead and drop broken database
mysqladmin drop roundcube Rebuild roundcube using the following two commands: rpm -e --nodeps cpanel-roundcubemail /usr/local/cpanel/scripts/check_cpanel_rpms --fix Database roundcube should be recreated automatically. To restore missed data like address books, etc we use cPanel's sql dump. mysql roundcube < /var/cpanel/roundcube/roundcube.backup.sql.1495215554
Done!
Similar Posts:
- How to install/reinstall mailman on cPanel server
- How to switch PHP handler from SuPHP to FastCGI
- How to create a MySQL database, username, password and privileges from the mysql command line
- How to connect at MySQL database
- How to create database, database username and grant all rights on cPanel server via command line using UAPI