-r <region_id>
to set a region ID for the new region. The default region is automatically assigned a region ID of 1, so your first additional region might be region 2.
cloudstack-setup-databases cloud:<dbpassword>@localhost --deploy-as=root:<password> -e <encryption_type> -m <management_server_key> -k <database_key> -r <region_id>
# mysqldump -u root -p<mysql_password> -h <region1_db_host> cloud account user domain > region1.sql
# mysql -u root -p<mysql_password> -h <region2_db_host> cloud < region1.sql
mysql> delete from account where type = 5;
mysql> update account set default_zone_id = null;
cloudstack-setup-databases cloud:<dbpassword>@localhost --deploy-as=root:<password> -e <encryption_type> -m <management_server_key> -k <database_key> -r <region_id>
# mysqldump -u root -p<mysql_password> -h <region1_db_host> cloud account user domain > region1.sql
# mysql -u root -p<mysql_password> -h <region3_db_host> cloud < region1.sql
mysql> delete from account where type = 5;
mysql> update account set default_zone_id = null;