Posted on Leave a comment

Show battery percentage icon in Windows 10 Taskbar

IF battery icon missing in the taskbar notification area then follow below steps:

  1. Click on Start menu and then settings
    Windows 10 Start Menu
  2. Settings window will appear, then type (Turn System icons on or off) in the search box and click on it
    Turn System icons on or off
  3. Once the window of “Turn System icons on or off” opened, click on the checkbox to turn on any system icon to appear in the taskbar
    Show Power icon Windows 10
Posted on Leave a comment

Automatically Backup MySQL Databases on Windows

MySQL Command for backup all databases:

mysqldump -uUSERNAME -pPASSWORD –all-databases > “D:/File_NAME_%date:~-4,4%-%date:~-10,2%-%date:~-7,2%-%time:~0,2%_%time:~3,2%_%time:~6,2%.sql”

Example:

Consider MySQL username = root and password = 123456

mysqldump -uroot -p123456 –all-databases > “D:/mysql_backup_%date:~-4,4%-%date:~-10,2%-%date:~-7,2%-%time:~0,2%_%time:~3,2%_%time:~6,2%.sql”

The result will be a file name (mysql_backup_2017-10-21-20_29_54.sql) containing all databases.

MySQL Command for one database databases:

mysqldump -uroot -p123456 –databases mydatabasename > “D:/mysql_backup_%date:~-4,4%-%date:~-10,2%-%date:~-7,2%-%time:~0,2%_%time:~3,2%_%time:~6,2%.sql”

We replaced –all-databases with –databases databasename

Note the date format:

  • %date:~-4,4%: year 4 digits
  • %date:~-10,2%: month 2 digits
  • %date:~-7,2%: day 2 digits
  • %time:~0,2%: time in 24 hours format
  • %time:~3,2%: minutes 2 digits
  • %time:~6,2%: seconds 2 digits

Now, after you customized the file name and date format, save your last command in file with (.bat) extension for examle:

mysqk-backup.bat

And put the file in local C: drive inside windows or any where in safe place of which normal user will not delete it, and then

  1. Press windows key + R to open Run windows and then type taskschd.msc
    Windows Run
  2. Once the Task Scheduler opened, Create New Task (located at the right sidebar) or go to Action menu and then Create Task
    Task Scheduler
  3. The task creation menu will open, first in General Tab, Fill name of the task (MySQL Database Backup – Daily)
    Task Scheduler General Tab
  4. Then Click on Triggers tab and Then New.. to create new trigger (This is where you set your schedule plan)
    Task Scheduler Trigger
  5. Then Click Ok, and now go to Actions tab
    Task Scheduler New Action
  6. Then Click on New.. once the window opened, browser to your file that we mentioned above, in our example we used (mysqk-backup.bat)
    Task Scheduler New Action
  7. Then click ok!, and again Click Ok to save everything.
  8. You can now right click on this task and click run to test if everything works fine.
Posted on Leave a comment

Rooting Samsung Galaxy S5 SM-G900H

Very thanks for https://desktop.firmware.mobi/ that helps me to Root my Android Galaxy S5 during 5 minutes, before trying that site, I tried several ways to root my android but I failed.

Once you visited the website, it asks to submit your device model, and the it provides you all required files to root including clean version of Audin.

firmware.mobi sm-g900h root

 

After submitting, the website provides required download files to root your device, just follow the instruction.

Note: Galasxy S5 Download mode, press volume down key + home + power then press volume up key.