by ds | Jun 13, 2012 | MySQL
MySQLDump doesn’t create a full backup of a whole database by default. If you use MySQL triggers, views, events etc., they are not dumped. Use these parameters for including everything: mysqldump –routines=true –triggers=true –events=true -u...
by ds | Jun 13, 2012 | Software
Windows Notepad is not the most usefule text editor when working with files over 1 MB. TextPad works fine with files up to about 2 GB, but opening larger files, e.g. huge SQL dumps of databases, ends up in an error message saying the HDD is full. A useful free Windows...
by ds | Jun 11, 2012 | Administration
By default, moving files does not include their previous NTFS permissions. To include these, create or update this registry key before copying: HKEY_CURRENT_USERSOFTWAREMicrosoftWindowsCurrentVersionPoliciesExplorerForceCopyAclwithFile -> DWORD 1 For details, see...
by ds | Jun 11, 2012 | Administration
I had to add 2 hard disks to 4 extisting ones of a RAID5 which contained sensitive data. First thing to say, it definately works on the fly without losing data (the drive doesn’t get formatted) – but to be sure, backup the whole content. Then, open Dell...
by ds | Jun 11, 2012 | Virtualization
By default, it is only possible to export a Hyper-V virtual machine on a local hard drive. If you want to be able to export to a network share which is created on another machine, you have to add the computer name of the Hyper-V host to the security settings of the...
