An error occurred during the restore.

Daniel_Dog

Verified User
Joined
Nov 16, 2019
Messages
452
Hello everyone,

I am currently in the process of moving a user to a new server as I am decommissioning that server.
I created a admin backup of the user and uploaded it to the new server.
When I restored the backup via my admin account I got the following error:
Domain **First domain** Created: Domain Created Successfully

Domain **Second domain** Created: Domain Created Successfully

Domain **Thirth domain** Created: Domain Created Successfully

Database: User **My username**_api@localhost password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.
User **My username**@localhost password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.
Error altering user '**My username**': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '**Text with database password**' at line 1
Error Adding Main Username to database: (above)
User **My username**_loginsystem@localhost password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.
User **My username**@localhost password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.
Error altering user '**My username**': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '**Text with database password**' at line 1
Error Adding Main Username to database: (above)
User **My username**@localhost password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.


Error with system Quotas
setquota: Mountpoint (or device) / not found or has no quota enabled.
setquota: Not all specified mountpoints are using quota.

Debug Guide

Error with system Quotas
setquota: Mountpoint (or device) / not found or has no quota enabled.
setquota: Not all specified mountpoints are using quota.

Debug Guide
After the error I notice that the user is missing 2 databases and that the MySQL users do not work anymore.
The Quotas errors is something that I do not really care about since I do not use it but it is still wierd it is giving me errors.

Does anyone know how to fix this/could the DA team fix this error?

EDIT:
I do know that I can restore the databases & MySQL users by hand but this should be done automaticly by admin backup/restore
 
password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.

Happend me once, regenerated new password at the old server and import went fine
This works but I understand that is not desirable
 
Last edited:
Back
Top