Our lab is going to lose power for maintenance this weekend and we collect data into a mysql database. In order to solve this problem, we have decided to build a second (replica) database in another location and point our collection scripts to it. So basically, this second database will collect 24 hours worth of data which we then need to append back to our master server on monday.
Finally, my question. Does anyone know how to take a .sql file (made with mysqldump) and append it to an existing database?