Arif
-
11:31:47 am on July 19, 2012 | # |
Restoring a production database into VM and change date to make it looks like some point of time inside the production server i.e. in this case May 4, 2010
$ /etc/init.d/mysqld stop $ /etc/init.d/httpd stop $ date +%D -s 2010-05-04 $ date +%T -s 23:00:00 -u
Check date
$ date Tue May 4 19:00:01 EDT 2010
Import database
/etc/init.d/mysqld start /etc/init.d/httpd start mysql -u some-username -p < some-db.sql
Note: Hardware clock option in the VirtualBox VM setting is disabled