Thanks Matt, there isnt an option in Piwik that I can select? I would hate to touch the code and ruin something.
Are you aware of any scripts I can install that can automatically or manually backup the db? Im surprised there are not as many posts on this on this forum. I would almost expect this issue to be a bigger issue for most webmasters.
You can have several different versions of the config file (with different names, of course), and then activate the desired one by using FTP to copy and re-name the version you need to be active at any given time.
By having the pre-configured different versions of the config file available, you avoid the possibility of accidentally making an on-line change that damages the config file.