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

Written By
backup a memory based db
November 18, 2007 11:33PM
February 26, 2009 12:30PM
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.