MySQL Forums
Forum List  »  Backup

Quicker way to restore database to a certain point
Posted by: Tomas Seal
Date: February 08, 2018 05:08PM

I've created a copy of a production database. This copy will be used to test new changes to the site which will include changes to the database schema, new data, etc.

I want to be able to restore this test database to its initial stage in case the tests fail so I can work on the changes and try again. The database is quite big so I'm trying to avoid mysqldump.

What would be the best way to restore the database to a certain point? I'm using AWS RDS so I have limited access to the data files, because otherwise I was thinking of creating a copy of the data files which I would use if I need to revert the database.

Any suggestions?

Options: ReplyQuote

Written By
Quicker way to restore database to a certain point
February 08, 2018 05:08PM

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.