Unable to upload MYSQL Database to new Installation

adnanbutt050 2021-06-28 07:17:16 UTC #1

Hi Dear,

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.

Kind Regards,
Adnan

StefanU 2021-06-28 07:41:46 UTC #2

Hi Adnan.

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?

Stefan

adnanbutt050 2021-06-28 08:02:13 UTC #3

Hi @StefanU,

only the database file, I don’t know why the backup file size is so large? as you cab see in the picture

Kind Regards,
Adnan

StefanU 2021-06-28 08:06:14 UTC #4

OK, then the DB is probably that big.

Stefan

adnanbutt050 2021-06-28 08:18:00 UTC #5

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.

adnanbutt050 2021-06-28 08:26:59 UTC #6

Hi @StefanU,

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

RalfBecker 2021-06-28 08:44:46 UTC #7

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:

copy the file directly to the server under /var/lib/egroupware/default/backup or
mount the backup-directory into filemanager: Admin > DB Backup and Restore > Mount backup directory to /backup and then upload the backup in filemanager to /backup or
change php.ini settings upload_max_filesize, post_max_size and probably also memory_limit

Ralf

RalfBecker 2021-06-28 08:46:04 UTC #8

Btw. the backup is a text-file (CSV), you can view it with an arbitrary text-editor.

Ralf

adnanbutt050 2021-06-28 08:48:46 UTC #9

Hi @RalfBecker,

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.

Kind Regards,
Adnan

adnanbutt050 2021-06-28 14:25:36 UTC #10

Hi @RalfBecker,

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.

kind Regards,
Adnan

RalfBecker 2021-06-28 15:13:10 UTC #11

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’

Ralf