Thanks for the extra information!
I've just tried running this in phpMyAdmin and got an error
I must admit, I'm getting out of my comfort zone with this, but at least it's all on what is, effectively, a test database at present!Static analysis:
10 errors were found during analysis.
Unexpected character. (near "{" at position 31)
Unexpected character. (near "}" at position 37)
Unexpected character. (near "{" at position 73)
Unexpected character. (near "}" at position 83)
Unexpected character. (near "{" at position 85)
Unexpected character. (near "}" at position 97)
Unexpected character. (near "[" at position 99)
Unexpected character. (near "]" at position 107)
Unexpected beginning of statement. (near "RewriteEngine" at position 0)
Unrecognized statement type. (near "On" at position 14)
SQL query:
RewriteEngine On RewriteCond %{HTTPS} !=on RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RewriteEngine On
RewriteCond %{HTTPS} !=on
RewriteRule ^(.*)$ https://%{HTTP_H' at line 1