Using 2 mysql databases

[sooty2006]

hi im making a website and on the frist mysql server i want user infomation and website stats etc...on the second mysql server i want to insert logs for when users login or other logged stuff!how can i use 2 mysql databases together!thanks all!

[Lulzim]

$conn1 = mysql_connect('mysqlserver1', '', ''); //connect to mysql server 1mysql_select_db('db1', $conn1)$conn2 = mysql_connect('mysqlserver2', '', '');//connect to mysql server 2mysql_select_db('db2', $conn2)$query1 = mysql_query("sql", $conn1); //query mysql server 1$query2 = mysql_query("sql", $conn2); //query mysql server 2

[sooty2006]

ok but will that cause any errors im just making sure is it completely safe to do that?be cause ive tryied it this way a few months back it creates errors sometimes! :)do i need to do this query for all statements or just the one i want to go to the (log) mysql serverINSERT INTO `database2`.`logs` (`id`, `to`, `from`, `msg`, `rea`, `sav`, `dat`, `cla`) VALUES (NULL, '23434', '34234', '3446fdgrwbgytgoreqbgytnhuiwnhoihneiohneyjjeytjyetj', 'no', 'no', NOW(), 'normal');

[justsomeguy]

It doesn't create errors if you do it right. PHP doesn't just pop up with errors for no reason, if you see an error it's because you didn't do something right.Another question you need to ask yourself is why you need 2 database servers. Why can't you have the logs on the same server as everything else?

[sooty2006]

because my host gave me 2 mysql servers i onli host one site on the server plus i need the database space the mysql server is holding alot of information i dont reli want it to get to the point were it carnt store anymre

[jhecht]

AS long as there's room on the server itself, your database can be as large as you really want it to be. And why not just use one database? It seems silly to do it on more than one(just complicates your life)I made a database class for php That I'm appending things to(parameter parsing, etc) if you like, i can post the code for it up here so you can look at it and use it. Much easier(all you would have to do is go

$server1 = new Db('localhost,'user','pw','db1');$server2 = new Db('localhost','user','pw','db2');

And then just make subsequent calls to the query method.