Restoring accounts from backup and database users
I'm going through the process of restoring an account from an offsite incremental backup. So far I've rysnced over the backed up data to the new server, then I've done a restore via:
This all worked great. But I noticed that none of the database users for the account has been recreated. I'm testing out this procedure since we want to be prepared if we need to restore an entire server. Does this mean I'd need to manually re-create the db users and passwords for hundreds of accounts in the event of a server failure? Also note that I do in fact have system backups, but I don't see any documentation on how I'd restore all the database users from these backups. Can anyone provide some insight on how to restore the database users from either the account or system backups?
/scripts/restorepkg accounts/myuserThis all worked great. But I noticed that none of the database users for the account has been recreated. I'm testing out this procedure since we want to be prepared if we need to restore an entire server. Does this mean I'd need to manually re-create the db users and passwords for hundreds of accounts in the event of a server failure? Also note that I do in fact have system backups, but I don't see any documentation on how I'd restore all the database users from these backups. Can anyone provide some insight on how to restore the database users from either the account or system backups?
-
So not sure what happened, but when I deleted the account and ran the script again all the mysql user accounts were recreated. 0 -
Hi @greatwitenorth When you restore using a cPanel backup through cPanel (or using the script) it automatically restores the database users as well as the databases. You shouldn't need to restore the users on the same system. 0
Please sign in to leave a comment.
Comments
2 comments