DivaVocals:
Well there's NOTHING in your .htaccess file I see that would cause a site to redirect one from one domain to a different domain.. (Hopefully someone more knowledge than I can confirm this) so let's go back to your original post
You state that your host confirmed that the issue is the .htaccess file and gave you advice on how to fix it.
So how did they come to this conclusion??
Exactly what did they suggest to "fix" it??
In my cpanel you have an option to point the folder containing the files to the new domain name(mysite2).
The htaccess generated from this should fix this problem.
Here's the htaccess provided by webhost controlpanel.
####CUSTOM_HEADER####
#NL: Place your custom rules here
#EN: Plaats je eigen regels hier
BEGIN CEON URI MAPPING REWRITE RULE
RewriteEngine On
Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
RewriteCond %{REQUEST_URI} !.[a-z]{2,5}$ [NC]
Don't rewrite any URIs for some, popular specific file format extensions,
which are not covered by main file extension condition above
RewriteCond %{REQUEST_URI} !.(mp3|mp4|h264)$ [NC]
Don't rewrite any URIs for some specific file format extensions,
which are not covered by main file extension condition above
Uncomment the following line to apply this condition! (Remove the # at the start of the next line)
#RewriteCond %{REQUEST_URI} !.(3gp|3g2|h261|h263|mj2|mjp2|mp4v|mpg4|m1v|m2v|m4u|f4v|m4v|3dml)$ [NC]
Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/ZC_xxx [NC]
Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/editors/ [NC]
Don't rewrite ext directory
RewriteCond %{REQUEST_URI} !^/ext/ [NC]
Don't rewrite sitemap directory
RewriteCond %{REQUEST_URI} !^/sitemap/ [NC]
Don't rewrite webstats directory
RewriteCond %{REQUEST_URI} !^/webstats/ [NC]
Don't rewrite min directory
RewriteCond %{REQUEST_URI} !^/min/ [NC]
Don't rewrite bmz_cache directory
RewriteCond %{REQUEST_URI} !^/bmz_cache/ [NC]
Don't rewrite mail directory
RewriteCond %{REQUEST_URI} !^/mail/ [NC]
Don't rewrite cgi-bin directory
RewriteCond %{REQUEST_URI} !^/cgi-bin/ [NC]
Don't rewrite fonts directory
RewriteCond %{REQUEST_URI} !^/fonts/ [NC]
Don't rewrite mysite2 directory
RewriteCond %{REQUEST_URI} !^/mysite2.com/ [NC]
Handle all other URIs using Zen Cart (its index.php)
RewriteRule .* index.php [QSA,L]
END CEON URI MAPPING REWRITE RULE
####CUSTOM_TAILER####
####ERROR_HEADER####
####ERROR_TAILER####
####SUBDOMAINS_HEADER####
RewriteEngine on
#RULE:www,mysite2.com,/mysite2.com
#RULE:,mysite2.com,/mysite2.com
RewriteCond %{HTTP_HOST} ^www.mysite2.com$
RewriteCond %{REQUEST_URI} !^/mysite2.com/
RewriteRule (.) /mysite2.com/$1 [last]
RewriteCond %{HTTP_HOST} ^mysite2.com$
RewriteCond %{REQUEST_URI} !^/mysite2.com/
RewriteRule (.) /mysite2.com/$1 [last]
####SUBDOMAINS_TAILER####
they also suggested to move the lines:
RewriteEngine on
#RULE:www,mysite2.com,/mysite2.com
#RULE:,mysite2.com,/mysite2.com
RewriteCond %{HTTP_HOST} ^www.mysite2.com$
RewriteCond %{REQUEST_URI} !^/mysite2.com/
RewriteRule (.) /mysite2.com/$1 [last]
RewriteCond %{HTTP_HOST} ^mysite2.com$
RewriteCond %{REQUEST_URI} !^/mysite2.com/
RewriteRule (.) /mysite2.com/$1 [last]
under the ####CUSTOM_HEADER#### line.
