Control Web Panel

WebPanel => CentOS 7 Problems => Topic started by: hadd on December 18, 2024, 02:29:26 PM

Title: Lost roundcube database
Post by: hadd on December 18, 2024, 02:29:26 PM

Dear all
I don't know why I have lost all database of roundcube. rouncube database in phpmyadmin is blank now. How can I reinstall it?
Thank so much.

Title: Re: Lost roundcube database
Post by: overseer on December 18, 2024, 07:58:01 PM

Do you have backups enabled? If so, you should have sqldumps available to restore:

Code: [Select]

ls -al /backup/mysql/dailySo you should have something like this:

Code: [Select]

-rw-r--r--. 1 root root   591608 Dec 16  2021 roundcube.sql
-rw-r--r--. 1 root root   251495 Dec 18 03:29 roundcube.sql.gz

Title: Re: Lost roundcube database
Post by: hadd on December 19, 2024, 01:20:58 PM

[root@mail ~]# ls -al /backup/mysql/daily
ls: cannot access /backup/mysql/daily: No such file or directory
[root@mail ~]#
:((
Can you have a sql create database for roundcube?

Title: Re: Lost roundcube database
Post by: overseer on December 19, 2024, 10:02:57 PM

If you follow this guide to update to 1.5.9 (change all references from 1.5.8 to 1.5.9):
https://www.alphagnu.com/topic/33-update-cwp-roundcube-mail-version-158-%E2%80%93-control-web-panel/
The roundcube tarball comes with:
/SQL/mysql.initial.sql