Hi folks,

I have a query regarding MySQL Databases. I am thinking of setting up a home server to store data in MySQL Databases. I know that If I run out-of-space, I can install a secondary HDD and create a seperate MySQL database and store data in the newly created database. But, How can I retrieve data stored in both database at once?

For example, If I have record of two years in the database in primary HDD and the third year record in the new database in the secondary HDD. How can I retrieve data from both the databases based on some criteria, say the last 1.5 years record?