There are two ways you could accomplish this:
- You could create the RDS instance manually on your Amazon AWS account. This requires some knowledge with regard to setting up remote access to the RDS instance using Security Groups but there is plenty of documentation out there. Once this is done then you need to modify the heatmap tracker config.php to use the RDS instance. You need to make a copy of the following:
- The username - this is the Master Username,
- The password - this is the Master Password,
- The database name - this is not the name of the RDS instance (DB Instance Identifier) but of the Database you created during the RDS instance creation referred to as the DB Name.
- The host (RDS endpoint - note that the endpoint usually ends in :3306. That number could be different if you have changed the port during the creation of the RDS instance. You need to copy the whole endpoint including the colon and port number.)
- This option is by far the easiest option and the one I recommend using. If you rename or delete the config.php file then Heatmap Tracker will be prompted to re-register with a new database. Select 'Use Amazon RDS' and follow the prompts and forms. This option will go through the RDS setup automatically and create the Security Group required as well as setup the config.php file. The only proviso is if you're using Personal version of Heatmap Tracker then you first need to de-register your license for the activation server. To do this you need to go to http://heatmaptracker.com/login/, log in and go to the download section and click the de-register button next to your license key.
With both options there is no easy way of transferring the data from your current MySQL database. You will have to transfer that data manually as well. You can export the tables and import them into the RDS instance and if your config.php file is setup correctly you should be able to login as per normal.