XS Labs

Archive for February, 2011

How to set UUID of a .vdi file in VirtualBox

by on Feb.11, 2011, under Uncategorized

In other words, remove the conflict message about UUID existing already, when trying to copy a .vdi file to use with some other machine.

The command is (in virtualbox’s folder in command prompt) VBoxManage internalcommands sethduuid C:\path\to\hd.vdi

The command had been renamed, before the “sethduuid” part was “setvdiuuid” so I decided to make this post so perhaps others might benefit from not having to figure out the command’s name change themselves.

1 Comment more...

How to rename a MySQL InnoDB-based database

by on Feb.07, 2011, under Uncategorized

Sadly (at least the current version) MySQL does not support “rename database” clause anymore, because it’s “unsafe”.

Here’s how to do it manually:

Issue

create database “newdatabase”;

Then for every table in your old database

rename table `olddatabase`.`tablename` to `newdatabase`.`tablename`;

Yeah I know it’s manual labor, but “show tables” query and a text editor with macro support makes it a bit easier. :)

Leave a Comment more...

Public service announcement

From the council of desultory bulletins:

The rate, at which feces fly, is simply stunning compared to the ionized gaps between nanoparticles upon impact of the floral microscopic patterns of neutron stars.
You should think about it for a moment. After all, it affects the longevity of random synergized spatulas.