I am facing a problem while migrating my Egroupware from AWS to Hetzner dedicated server. I am unable to upload the database server that I downloaded from my old Egroupware. The size of the database file is about 125MB
Any help would be much appreciated.
What exactly is that?
Only the database backup of/from EGroupware?
With or without files?
That would already be very large. I have <16MB with 120 users/10 years.
What exactly is the problem?
only the database file, I don’t know why the backup file size is so large? as you cab see in the picture
OK, then the DB is probably that big.
as you know the file size is soo large when I upload it, then it starts uploading, and after a few minutes, no backup files uploaded here.
I am quite sure there is something wrong with the Backup file, when I extract the zip file the database file size is 2.20GB
There is an upload file-size limit of 64MB on our Docker image, which normally through EGroupware does not matter, only old backup/restore is limited by it
You have now a couple of possebilities:
Btw. the backup is a text-file (CSV), you can view it with an arbitrary text-editor.
Thank you for your response, I will try to upload it again.
I opened this file on mac but unable to open this on windows because of the file size.
The database file contains millions of these entries, that’s why the database file size is soo large.
Do you have any idea why I have soo many entries like this?
I am very thankful to you.
Looks like the egw_history_log table.
You can either truncate it or pick a date how much history you want to keep and the run:
DELETE FROM egw_history_log WHERE history_timestamp < ‘2020-01-01 00:00:00’