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