Archive for April, 2012
VirtualBox – Disable Date and Time synchronization for a VirtualBox Guest system
Thursday, April 26, 2012 16:24 No CommentsThe following command will disable the date/time synchronization for a Guest operating system. Assuming the host is running Windows OS. Open the command prompt. (Run -> cmd) Enter command: C:\Users\User>”c:\Program Files\Oracle\VirtualBox\VBoxManage.exe” setextradata ENTER_MACHINE_NAME_HERE “VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled” “1″ * Replace ENTER_MACHINE_NAME_HERE with Guest system name * This command will add an extra line to the “C:\Users\User\VirtualBox VMs\MACHINE_NAME\MACHINE_NAME.vbox” file. [...]
MySQL InnoDB table truncate fails because of foreign keys
Thursday, April 12, 2012 8:51 No CommentsIf trying to truncate MySQL InnoDB tables and you are getting an error because of foreign keys constraints try disabling the foreign keys checks. SET FOREIGN_KEY_CHECKS = 0; .. TRUNCATE tableName; TRUNCATE tableName2; .. SET FOREIGN_KEY_CHECKS = 1;