Tag Archives: windows

How to solve disk usage 100%

You need to increase the virtual memory.

Set the setting as below

  • initial size – set equal to RAM size
  • maximum size – set double the RAM size

To do this, follow the following steps:
1. Go to Control Panel> All control panel items > System
2. Click on Advanced system settings
3. Under performance, click on settings
4. Go to Advanced tab
5. Under Virtual memory, click on Change
6. UN-check “Automatically manage paging file size for all drives” check box
7. Select your windows drive (where OS is installed)
8. Click on Custom size radio button
9. Set Initial size equivalent to your RAM size in MB
10. Set Maximum size to twice of your RAM size in MB
11. Click on Set
12. Click on OK thrice
13. Restart your system

This should resolve this issue,

Lost windows password. This tools can help to reset

I faced a problem with a lost of password for a windows PC. Here what I did

  1. Download ISO for bootable Offline Windows Password here. Scroll down to download section and download cd140201.zip regardless you want to build CD or USB boot
  2. Crete a bootable USB with rufus
  3. Boot using the USB thumb drive and just go through the questions. You can reset and enable any user account.

Credit to about.com for the info

Some uncommon Windows Shortcut

  • Windows+S – open search box (for Windows 10)
  • Windows+E – open Windows explorer
  • Windows +R – open Run box – then can run command, control panel etc
  • Windows+I – open Settings
  • Windows+Pause/Break – show System Information (windows ver, system hardware, computer name etc)
  • Ctrl+Shift+Esc – open Task Manager

Tips to speed up Windows

Some tips to speed up Windows operating system

  1. check which program use the most resources (especially memory) and remove or disable if possible
  2. disable some unused startup programs
  3. remove unused programs in the PC
  4. remove unused plugins or extensions in web browser
  5. defragment hard disk
  6. reinstall windows (please backup all important files – e.g. on my document, desktop, emails). With Windows 8 onwards, you have option to “reset” the PC
  7. upgrade RAM (memory). limit for 32-bit OS is 4GB only
  8. use SSD (solid state drive)

MySQL database auto backup on windows

To backup mysql database (all databases) can use this batch file

Then you can compile the .bat file to become .exe file so that the password is hidden.

Download bat to exe converter from CNET download

Lastly, you can include the exe file to run in task scheduler

You can have option to upload the file via FTP to other server

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
:: Start FTP files to remote server
:: Create the temporary FTP script file
> script.ftp ECHO ftpusername
>>script.ftp ECHO ftppassword
>>script.ftp ECHO lcd /
>>script.ftp ECHO lcd /MySQLBackups/backupfiles
>>script.ftp ECHO binary
>>script.ftp ECHO prompt n
>>script.ftp ECHO put FullBackup.%backupdate%.zip
>>script.ftp ECHO bye
:: Use the temporary script for unattended FTP
:: Note: depending on your OS version you may have to add a '-n' switch
FTP -v -s:script.ftp ftphostcom.com
:: Overwrite the temporary file before deleting it
TYPE NUL >script.ftp
DEL script.ftp
:: DONE FTP backup file to remote server