I would like to know if it is possible to use my database on a server different from the one i have the webpage and the coppermine files on. i could not finish the installation and i thought this might be the reason. I tried different mySql configurations but either i get
MySQL error was : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
as an error message (when i enter localhost as mySql host) or i get
MySQL error was : Lost connection to MySQL server during query
(when i enter my database server as mySql host).
Can anyone help me out?
Yes you can. You just need to make sure you enter the correct info for the database server, username, and password. And if required, the database would need to be set up to allow remote connections from your site.
I think I may have to do this as my server load is stonking on our busy days. :o
If I was to move the database to a different server would I put the IP address in the config file?
$CONFIG['dbserver' ] = 'localhost' ;
to something like:
$CONFIG['dbserver' ]='84.23.76.234/~username'
I hope that's not a dumb question......showing my ignorance....sorry.
IP address or host name (using name resolution over DNS) - however, this is something that you'll have to ask the webhost who is in charge of the mysql server. The mysql service is not tied to a user home, so /~username doesn't apply.
Cool thanks, I'll let you know how it goes. :)