Hi guys. I wanted to know if something would be possible. I currently have a server that runs mySQL and i created a database on there for use with PHP-Nuke Treasury module. I don't know much in the way of MySQL besides the basics. I uploaded the .sql file to the database without any problems.
Is there then a way i can connect to this database (say is on oldsite.net) from my other web server (say, newsite.net which is currently without MySQl for a while)?
Lets say the database is called "myDatabase" with user "database" with password "password" given full access privileges. How could i then connect to this database using a script on my newsite.net server?
Any ideas? I tried simple things like oldsite.net as server instead of localhost - but as i said, im new to this MySQL thing.
I also enabled newsite.net to be allowed remote access to oldsite.net - but still wont work
Any questions? Answers? Help? --- much appreciated in advance.