Move domains between clients

[modcar]

If anyone wants to do this manually - heres how I did it (replace the CAPITALS with your values)

'Login to PHPmyAdmin as root, 'SQL' tab, select sentora_core database
'Get old userid and dir name

Code:

SELECT vh_acc_fk,vh_directory_vc FROM x_vhosts WHERE vh_name_vc= 'DOMAIN.com'

'Get new userid

Code:

SELECT  ac_id_pk FROM x_accounts WHERE ac_user_vc = "NEW_USERNAME"

'SSH to server, and move files
' Move website files

Code:

mv /var/sentora/hostdata/OLD_USERNAME/public_html/DOMAIN_com /var/sentora/hostdata/NEW_USERNAME/public_html/DOMAIN_com

'Move logs

Code:

mv /var/sentora/logs/domains/OLD_USERNAME/DOMAIN_com-*.log /var/sentora/logs/domains/NEW_USERNAME/

'Using PHPmyAdmin 'SQL' tab, select sentora_core database
'Update vhost

Code:

UPDATE x_vhosts SET vh_acc_fk = 'NEW_USERID' WHERE vh_name_vc = 'DOMAIN.com'

'Update mailbox

Code:

UPDATE x_mailboxes SET mb_acc_fk = 'NEW_USERID' WHERE mb_address_vc like '%@DOMAIN.com'

'Update ftp

Code:

UPDATE x_ftpaccounts SET ft_user_vc = 'NEW_USERID' WHERE ft_directory_fc like '%DIRNAME'

'Update email forwarders

Code:

UPDATE x_forwarders SET fw_acc_fk = 'NEW_USERID' WHERE fw_address_vc like '%@DOMAIN.com'

'Update DNS

Code:

UPDATE x_dns SET dn_acc_fk = 'NEW_USERID' WHERE dn_name_vc = 'DOMAIN.com'

'Update D Lists

Code:

UPDATE x_distlists SET dl_acc_fk = 'NEW_USERID' WHERE dl_address_vc like '%@DOMAIN.com'

'Update Aliases

Code:

UPDATE x_aliases SET al_acc_fk = 'NEW_USERID' WHERE al_address_vc like '%@DOMAIN.com'

' Force apache reload

Code:

UPDATE x_settings SET so_value_tx='true' WHERE so_name_vc='apache_changed'