This is more about speed increases rather than troubleshooting... I noticed my WordPress-powered blog is SIGNIFCANTLY faster in all aspects by having the mysql database hosted on a separate server. I use cloud hosting. Another "Linode" is $10 extra a month. Should I use the same strategy with Amember? (Or is this just throwing $10 a month out of the window?) If so, what files do I need to edit to point the new mysql file?
I am afraid I do not sure how it improve performance (it depends on many factors) but you can test it and in case you do not like new setup then revert it back. You can find database connection settings in file amember/application/configs/config.php Best Regards.
It depends on your server configuration. You need to fill in correct credentials for mysql server in this file. I suggest to contact your system administrator for details. Please take into account new server should have aMember database in place. You can copy database from current server to new one.