I wonder if there are any features in MySQL that I can manipulate the entire database and when I exit the MySQL no real changes made at the actual database?
The Rails has feature like this called sandbox
.
You can use MySQL transactions. It's the same Rails is using.