February 27, 2012

How can you dump MySql database after each update?

Question by Craig Ward

After I make a change to a database in MySql (Update, Delete, Insert, Create etc) is it possible to get MySql to dump the database or export the last run query to a sql file?

Answer by Starx

What you are looking for is backing up every transactions on the db.

So, check this page, and start using transactions on your query.

Author: Nabin Nepal (Starx)

Hello, I am Nabin Nepal and you can call me Starx. This is my blog where write about my life and my involvements. I am a Software Developer, A Cyclist and a Realist. I hope you will find my blog interesting. Follow me on Google+

...

Please fill the form - I will response as fast as I can!