How to move users from specific reseller to serveradmin
Important notes: before doing these steps please backup your MSPC database. Do not move next user if you are not finished with current or you are not sure that all works fine. Also please take into account recommendation from point #7 and of this guide. Point #8 is required only in case you use custom path for reseller folders.
1. Open user home page and pick up UserID in browser URL
2. Open user space home page and pick up PackageID in browser URL
3. Every user in MSPC has parent user and every package (Hosting Space) has parent package. In case user is created under serveradmin, then he has parent user – serveradmin (always UserID = 1 in database) and parent package is “System” space (PackageID = 1 in db)
4. To move specific user from reseller to serveradmin use the following script on MSPC database:
update [dbo].[Users] set OwnerID = '1' where UserID = USER_ID
USER_ID – value from point 1.
5. To move specific hosting space from reseller space to serveradmin “System” space use the following script on MSPC database:
update [dbo].[Packages] set ParentPackageID = '1' where PackageID = PACKAGE_ID
PACKAGE_ID – value from point 2
6. Login in panel as serveradmin and find moved user. Open space under user and go to space details.
7. Assign Hosting Plan. Please note that assigned plan should have enough quotas to cover your moved space, so we recommend before moving users, please create or prepare existent Hosting Plan for migrated clients.
8. This step required if you use custom path for you reseller folders. In other words if you keep your user folders under reseller folder.
If you use this option you should perform 2 additional steps:
a. Copy user folder from reseller folder to general folder for hosting spaces (name HostingSpaces by default). Please, use smart file manage that has option to save NTFS permissions in copy procedure.
b. Update Hosting Space file location in MSPC database using following script.
SET ItemName = 'd:\hostingspaces\xxx' -- folder path (new folder path
from point 8.a. )
WHERE PackageID = A -- packageid - SpaceID from request string in the
Browser (you already have it in point 2)
AND ItemTypeID = 2
AND ServiceID = B -- serviceid - ServiceID of "OS" service (see picture