I sent in a ticket asking my hosting provider how I would be able to upload config files with the DB info of my VPS MySQL, and still haev all the correct tables showing up.
On my VPS I'm hosting a private server, so I use a program called Navicat to edit stuff in the MySQL database, and site files to htdocs in XAMPP, files you can view by going to 126.96.36.199
Now, the all the files I upload to that IP site have the VPS MySQL info in it(DB name, username, pass, host) so they're all connected to the MySQL (the register page, ranking page, and UserCP).
If I upload those files to my .net site via FTP, it shows up all messed because in the config files, the database isn't matching my actual .net database, so it doesn't show up properly (this is expected).
I contacted my hosting provider asking if I could do this, and if it would put stress on the server, and they said no, you just need to 'configure your script to use remote mysql host'.
Then I asked they how, and they pointed my towards fixmyscript.com
Can anyone here tell me how I can make it so if I upload files with the info in config.php matching my VPS MySQL database?
For examples of my pages:
But, I'd like those to be:
I've done it with the UserCP before, but I had to point my name servers towards my VPS's, and according to my hosting provider it ended up messing my site (only certain people can view it... not even I can).
So, I need to know how to 'configure your script to use remote mysql host' so I can upload the same config files in XAMPP to my FTP and still have them connected.