Author Topic: Lost roundcube database  (Read 62 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Lost roundcube database
« 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.

Offline
*****
Re: Lost roundcube database
« Reply #1 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

Offline
*
Re: Lost roundcube database
« Reply #2 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?

Offline
*****
Re: Lost roundcube database
« Reply #3 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