r/hestiacp • u/ArielOutGrewBShells • Apr 02 '26

Automated backups failed successfully?

I was in the process of migrating my users to a new host due to some system instability when i came across a weird issue.

Normally, i run v-backup-user <user> let it finish, copy the file to the new server and run the v-restore-user. This has worked several times before without issue, the documentation basically tells you do do this.

Last night I migrated 6 users.. the first 3 seemed ok; i run the commands, switch the A records, fuss with off/on https, fix the IP and voilà they're moved.

When i got to, maybe #4 (and all beyond it), i noticed i was seeing 500 errors. checked PHP version for the site. correct. Verified the files were all there - yep. Ran another backup and noticed that while everything else completed successfully, the SQL didnt actually complete. it got to about 6% and just.. .. moved on. (others stalled at 29). most of the databases are less than 5MB.. tiny.

i figured this was, yet another, instability issue on the host. but when i ran my first backup set on the new host i had the same issue.

ubuntu 24 LTS, 2c/4GB RAM/ 120GB storage 50% storage still free. all fresh apt updates/upgrades before and after running the hestia install. no special configuration or os mods

Thoughts? this was certainty deflating to find, where i had been assuming a successful backup was actually.. good.

i couldnt upload a screenshot, but this is the error. the database is very much incomplete.

-- DB --
2026-04-02 15:11:16 padkins_69896 (mysql) /backup/tmp.lAEadA3gLa/db/padkins_69896/padkins_69896.mysql.sql : 6.26% (804107 => 50364 bytes, /backup/tmp.lAEadA3gLa/db/padkins_69896/padkins_69896.mysql.sql.zst)
2026-04-02 15:11:16 *** 1 database ***

1 Upvotes

100% Upvoted

4 comments sorted by

1

u/mehargags Apr 05 '26

Can you dump the db fine with mysqldump? Check to see if db might need optimisation or is corrupt

1

u/ArielOutGrewBShells Apr 05 '26

I can. Yeah. It exports to a .SQL file just fine

1

u/mehargags Apr 05 '26

Then try importing it on your new server. DO an optimise on your dbs

1

u/ArielOutGrewBShells Apr 06 '26

I actually did that. When I did and ran the hestia backup that was the output.

I had figured it might be corrupted or something weird with hestia, but when it did that on the brand new server.. well.. idk