I have an assignment to build a development virtual machine template.
I need to add to the server MySQL databases from each one my company's products so that new developers will have the ability to develop for each one of the products.
Most databases are smaller than 1GB.
But I have a few databases which are huge (around 160G) - but I'm limited in the size of the template I'm trying to create, and it's not reasonable to add there a DB of 160GB.
Therefore, I'm trying to find the right method to extract, let's say, last month's values from this huge database and add them to the server so the developer will be able to "feel" what it's like to work on this database.
Is it possible to do such a thing and how is it done? Thanks!
Edit:
Unfortunately, there is no option for a separate main DB server which will hold all development databases, also there's no requirement to update the data regularly, I just need to present the same data as in production servers (at a random time period) as a sandbox environment for new developers.