by ds | Jun 13, 2012 | MySQL
'MySQL Backup Script 'run with "cscript mysql_backup.vbs" 'Configuration server = "www" user = "backup" pw = "BackupPW" mysql = "mysql.exe" mysqldump = "mysqldump.exe" backupdir = "e:mysqlbackupwww"...
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...
Comments