Evolution user backup restore

[LawsHosting]

When you select a backup, namely, a HUGE 18Gig file, what's the meaning of a .tmp being created? It increases in size, eventually vanishes... Then Evo just stalls doing sweet F A.

Can't it handle massive backups? Or can't it import backups created at Reseller level (username.tar.gz)?

I only want to restore a database, and I thought doing it via the user restore would be quick...... Hell no....

 

[factor]

The fastest way to restore a huge db file is in ssh.

But I do wonder the answer to the question from evo.

I assume it’s using tmp to decompress the backup. Is there a space limit on tmp?

By the way I like the new avatar.

 

[LawsHosting]

The tmp file is created in the same directory eg. username.tar.gz.tmp

Give it 2 years, I am going to quit....... Really had enough of servers and websites.

 

[LawsHosting]

The fastest way to restore a huge db file is in ssh.

ERROR 1062 (23000) at line 2555: Duplicate entry 'topic_cache-new' for key 'PRIMARY'

I thought .SQL files had a drop table <punches wall>

 

[factor]

ERROR 1062 (23000) at line 2555: Duplicate entry 'topic_cache-new' for key 'PRIMARY'

I thought .SQL files had a drop table <punches wall>

Depending on how the sql file was created. n PMA you need to choose the add drop table to the export.

The tmp file is created in the same directory eg. username.tar.gz.tmp

oh I thought you were referring to the tmp dir sorry. Usually when expanding an tar gz it can need more than double the file size to expand. So the space for whatever partition the dir is in would need 36GB available. Is there around 36GB free?

 

[LawsHosting]

Depending on how the sql file was created. n PMA you need to choose the add drop table to the export.

This was the .SQL file from the Reseller backup (username.tar.gz) file, so surely if you need to restore everything via the Reseller, it'll fail as well then? ?‍

Are user backups different to the Reseller ones?

So the space for whatever partition the dir is in would need 36GB available. Is there around 36GB free?

Nearly 1.8TB free......

 

[factor]

Are user backups different to the Reseller ones?

I dont have resellers...
Not sure.

 

[Richard G]

Are user backups different to the Reseller ones?

As far as I know, yes for the full backups. At least they will have packages and package settings for the user included which the normal user backup might not have.
I'm not sure for the rest.

 

[LawsHosting]

So, if someone borks up their database and we do nightly backups via a Reseller, unless we manually extract and import the .SQL file from the archive, the WHOLE account (domains, www, db, mail, ftp) would be restored....... Bit of a bummer, that - especially if it's a huge account and they did modifications to files too.

 

[factor]

Yes correct. It’s just like admin backups it is all point and time.

There is no native real-time or incremental support in da yet.

 

[Richard G]

So, if someone borks up their database and we do nightly backups via a Reseller,

Then you would backup a corrupt database too. So it doesn't really matter, does it?
Except if you could use a previous backup. But indeed you have to extract the sql file from that.

 

[factor]

if someone borks up their database and we do nightly

Hopefully the users keep user back ups as well. Also hopefully you keep a few full backups. As Richard said if it's borked it might be borked..

 

[LawsHosting]

Then you would backup a corrupt database too. So it doesn't really matter, does it?

Luckily they borked it after the morning backup.........

Anyway, would like confirmation if username.tar.gz created via resellers' Manage User Backups can be restored as a user.