I want to protect my mysql database from my website host (I am on shared hosting). They should not be able to see the database.
As far as PHP scripts are concerned I understand that using the Zend or another encoder will protect the source code from even the host.
What can be done to encode/decode OR crypt the entire mysql database so that it is useless to the host.
Please give your expert opinion.
Will the following solution work:
Using mcrypt to encrypt / decrypt all the data in the database. Using XML-RPC to store the key to the encryption on another website (different host). Also the database dump is emailed daily to keep a latest copy.