At work we have a script that does a mysql data dump everynight. For development we usually need to work with data from the most recent dump. We kept doing a database restore every day for some time but now we are getting to a point where the restore is taking close to an hour everyday. Is there a way for us to do a delta restore in mysql or maybe just do a delta dump. Kind of like a patch file but for mysql. Any help on this topic would be greatly appreciated.
-Hrithik
An incremental backup will probably be your best option. Using a log file it creates something similar to a patch file.
If both servers are running the same version of MySQL you can simply copy the MySQL files.