Archive for April, 2012

VirtualBox – Disable Date and Time synchronization for a VirtualBox Guest system

Thursday, April 26, 2012 16:24 No Comments

The 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. [...]

This was posted under category: Operating Systems, Unix/Linux, Windows Tags: , , , , , , ,

MySQL InnoDB table truncate fails because of foreign keys

Thursday, April 12, 2012 8:51 No Comments

If 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;

This was posted under category: Database Tags: , , , ,