Merging existing MySQL database with new data pulls

weecology / mete-geog

Research on making geographic predictions for macroecological patterns using the Maximum Entropy Theory of Ecology

2 stars 3 forks source link

Merging existing MySQL database with new data pulls #5

Closed dmcglinn closed 10 years ago

dmcglinn commented 10 years ago

Assuming that the existing MySQL server on Serenity is the best host for our SQL queries it will be necessary to update the databases on that server. BBS and FIA are the most likely to be changed. What is the best protocol for carrying this update out. Alternatively is it a better approach to create a new independent MySQL server for this?

ethanwhite commented 10 years ago

Updating the databases on Serenity is fine. I archive dumps of them at the end of projects so it's same to just reinstall them using the Retriever. If you run into permissions issues let me know.