Multiple mysql databases
Posted: Mon Aug 10, 2009 1:31 am
Hi all,
I'm after some advice. I am reasonable with php mysql but not great. What I have is a quickly growing project and database size limitations (Host driven).
What I would like to do is to use two databases. At the moment I use one for all the users and photo galleries but I'd like to use a different one for the next bit of the project.
My question is can I have two running together.
If I have two comm includes at the start of the file will mysql just find the correct table from my queries.
I hope I have explained this well enough but I'm not certain. If you need any more help let me know.
I'm after some advice. I am reasonable with php mysql but not great. What I have is a quickly growing project and database size limitations (Host driven).
What I would like to do is to use two databases. At the moment I use one for all the users and photo galleries but I'd like to use a different one for the next bit of the project.
My question is can I have two running together.
If I have two comm includes at the start of the file will mysql just find the correct table from my queries.
I hope I have explained this well enough but I'm not certain. If you need any more help let me know.