by ds | Jun 13, 2012 | MySQL
Last Updated on 2012-06-13. 'MySQL Backup Script 'run with "cscript mysql_backup.vbs" 'Configuration server = "www" user = "backup" pw = "BackupPW" mysql = "mysql.exe" mysqldump = "mysqldump.exe" backupdir =...
by ds | Jun 13, 2012 | MySQL
Last Updated on 2012-06-13. 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...
by ds | Jun 13, 2012 | Software
Last Updated on 2012-06-13. 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...
by ds | Jun 11, 2012 | Administration
Last Updated on 2012-06-11. 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...
by ds | Jun 11, 2012 | Administration
Last Updated on 2012-06-11. 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...