MySQL Forums
Forum List  »  Memory Storage Engine

backup a memory based db
Posted by: CHarles Pareto
Date: November 18, 2007 11:33PM

I would like to use a memory based db for my project. My db is only a couple of MB's in size so I think it would be perfect, but the data in a memory based db erases if the db is shut down. So I thinking, there are very few writes to this data base every day (like 5-10) so what if I do a hard backup of the whole bd every time a write occurs? This way I save the database in a hard copy in case the the power goes out or someone unplugs the server. And when the power gets restored I have a hard copy that can be loaded right back into the db.
Is this a good idea?

Options: ReplyQuote


Subject
Views
Written By
Posted
backup a memory based db
9090
November 18, 2007 11:33PM
5363
February 26, 2009 12:30PM
5185
February 27, 2009 03:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.