How to set sleep timer on YouTube Music in iPhone 13 pro(iOS)

YouTube Music app doesn't have a sleep timer setting by default. In iPhone or iOS devices, it can be done by using the clock app. Open clock and start timer. You can set the timer in hours, minutes and seconds. Then select 'Stop Playing' option from 'when timer ends'. Then start the timer. After the timer stops, the music playing in the youtube music app stops automatically.
youtube music in iphone 13 pro

Even if YouTube Music app doesn't have the sleep timer option, you don't have to install any new app for it. With the inbuilt Clock app sleep timer can be activated. For the detailed video click below.

Click here to see the video.


How To Block Ads In Android Smartphones Using Private DNS

In android smartphones, most of the apps show unwanted ads and pop-ups. It may be irritating to the user. There are a lot of methods to block these ads from showing up. Most used method is by using third party ad-blocking apps. You can download apps such as Adblock Plus, AdGuard and AdLock to block ads on your smartphone. Most of these apps need root permission for blocking ads effectively. But there is an another method for blocking the ads which uses the private dns.

Smartphones with Android 9 or later comes with Private DNS feature. This feature can be used for blocking the ads. The biggest advantage of this feature is that you don't need to download any app on your smartphone and you get system-wide ad-blocking without root access. Adguard dns is used for blocking malicious ads and pop-ups.

Steps to set up Adguard DNS

  • Make sure your device runs on Android 9 or later.
  • Go to Settings>Network&Internet Settings>Private DNS
  • In Oneplus devices, Settings>Wifi&Internet>Private DNS
  • For Samsung Galaxy devices Settings>Connections>More Connection Settings>Private DNS
  • If you cannot find the Private DNS option, then simply search Private DNS in Settings search bar.

Private DNS

  • Then select Private DNS provider hostname and enter the hostname of DNS provider as 'dns.adguard.com'.
  • For family protection mode(for blocking adult content) enter the hostname of DNS provider as 'dns-family.adguard.com'.
  • Hit Save and exit from the Private DNS menu. That's it. Now your device will block most of the ads and pop-ups.

Taking screenshot of whole webpage using a telegram bot

There may be an  occasion in which you want to take a screenshot of a long webpage rather than a small portion (we all have that screenshot option in our smartphones). Now imagine a situation where you are having an argument with a friend of applying for a job by seeing a website.  Now you have two options, one in which you have to send the URL of the website and explain each detail on by one. The other option you have is just sent the screenshot of the webpage. There are several websites to save you from this screenshot misery. But today I have to discuss the same situation if occurred in a telegram chat.
Of course, there is a saviour bot to save from this tricky situation called URL2IMGBot. Now let's look at how to use it.

1. Open Telegram and search for @URL2IMGBot in the search bar

Select the bot and press START button. information about bot will be like this.

 

Bot chat screen

 

2. Type or paste the webpage address (URL) in the chat and send it

 

You will get an image as reply with other download option (like PNG).

If you are not satisfied with the quality of the image select the PNG option.

3. Check the file you got as a reply from bot

 

 

 Download the file.

Hope you enjoy the tutorial and check other Telegram tutorials here.

 

Comment your reaction below


Want to increase the download speed of Telegram files? Check this out

Slow speed is always annoying especially when you want to download some 700 Mb file via Telegram. There is a bot out there to save us from this misery called @GetPublicLinkBot.Thanks to developer Ajeesh Nair.

NB: You can use this bot to download any type of Telegram file (mkv,3gp,pdf,jpg,epub etc.)


How to use this bot? Nothing complex just follow these steps. This method is valid for both mobile and desktop users

1. Open Telegram and search for Getpubliclinkbot

 






 2.  Just press START button

 

 

  3. Send the file you want to download faster


Wait for the reply. Normally reply will be like this.

T

There are 3 options available.

a) Instant Download - Simply gives you a link to download the file via external browser but not resumable. That means once you created that link it can be used only once (Not recommended)

b) Resumable link -  Here you get an external link which can be download via external browser and is resumable (Recommended)

c) Save to G-Drive/Dropbox - Here you get an option to save the file in your personal Google drive. Then simply download the file at any time (Most recommended). There is another option to save the file in your Dropbox account.


4. Click Save to G-Drive/Dropbox


A popup window like this will appear. Just click Open.





Your default browser will open a webpage with these options.

 



5. Select Save To Google Drive option

 

Now another page will ask you to Sign in your Google account. Just enter your gmail address and password to log in.

 


After Login, you have to tap the Allow button.



6. Your file will be now available in your Google Drive

Tap download to proceed



 Select Download anyway

7. Choose the path to save this file in case browser asked



Now you can check the downloading speed  and can verify that, this method is almost 2X times than normal downloading method.


Checkout this tutorial video:

 

 

How to download your favourite movies using a Telegram bot?

To follow up this tutorial you must have a telegram account (that's obvious). Moving on, the most important feature that keeps telegram apart from Whatsapp is the inclusion of third party bots. Botfather helps you to make really mind-blowing bots or robots. In fact, these bots made Telegram an all in one destination - Download movies, download Youtube videos, Convert files into other formats, even dedicated Gmail bot is there to serve you.

OK, that's nice, isn't it? Then, How to download your favourite movies using a Telegram bot? It's pretty easy just follow these steps.
  

1. Open Telegram and search for TGMoviesBot.


2. Select TGMoviesBot and Click the START button

3. Then select Find a Telegram file option ( see pic below )


When you click that an important feature called inline mode appears. Inline mode is nothing but you can start a bot simply type @TGMoviesBot within any chat, then the bot will activate.

NB: Add @ symbol before TGMoviesbot


4. Type exact name of movie (eg: TITANIC)



5. Select the required file from the list and click the file to download 



Still confused?

Watch this video...

Have the fun of downloading movies right within a conversation without opening any browser tabs. So you got the file to download. That's great, isn't it?


Want to increase the download speed of Telegram files? 


Comment your thought on this article

Top Telegram movie Channels and Groups.


Everyone now has Telegram installed on their smartphones, tablets or even in Desktop. More than an instant messenger it offers technically an infinite storage space. So one gets literally any films from any language ever released.Still finding a movie in telegram is often a mess. There are many Channels and Supergroups which fills with ads and po*n messages to distract you.


So here we present you a list of genuine movie channels which are heavily focused on content.


1. Cinema Company

Probably best supergroup in the Telegram. You will get any type of cinema, Web series, Documentaries, Netflix stuffs. More than that group is well maintained by a cute bot called, Alia bot 2.0.




2. Cinema kottaka

Another Supergroup with a lot of movies you want. A great community of film lovers.



3.  Dvd Release Dates

 I am not a fan of Camrips. When you get high quality DVD prints then you should go for it. This channel gives all latest dvd updates on South Indian movies.



4. X265 HEVC MOVIES ™️
A prime channel with almost every cinema on earth.


A Telegram channel dedicated for New film release initiated by Cinema Company.




6. RickyChristanto

This channel contains more then 30K movie files which indeed shows the popularity and quality of the channel. If you are a cosmopolitian movie freak then this one is for you.





Korean movies are always fast paced one with extreme action and drama. This is such a cinema community with enormous collection of Korean movies.




Another gem from team cinema company which has an archive of all popular series on the globe. It ranges from GOT to Dark and Sacred Games to West World.


A channel dedicated for tamil dubbed movies and series.

 A channel dedicated for malayalam dubbed movies and series.

Are you a bollywood film lover. Then this is one for you.


After a day long research you may get the name of some dutch or italian movie name, then what? This channel provides rarest of rarest films ever produced.


Many of you may heard that google drive links work much faster than normal telegram file download. This channel is dedicated for collection of Google drive links.
A complete collection of Old and New malayalam movies.



It seems list is never ending. Read " How to download your favourite movies using a Telegram bot? " .

Let us know what you have in your arsenal. Comment below.



Using mysqldump in command line: Tutorial for beginners

mackbook pro mysqldump command line

mysqldump command utility is used to take copy of one or more MySQL databases for backup or transfer to another server. Using this command you take a dump of a database in different formats like SQL, CSV, text and XML.

A simple dump operation can be done using following command:

mysqldump -u username -p databaseName > "filename.sql"

This command will prompt for password and once you enter the password a copy of that entire database will be generated and saved with the given filename.

Now I will go deep into some very usefull mysqldump options and how to use them in real world with examples.

1. Take dump of all databases

To take backup of all databases you can simply use the option name --all-databases .

mysqldump -u username -p --all-databases  > "filename.sql"

2. Take dump of single table

To do this you just need to specify the table names.

mysqldump -u username -p databaseName tableName > "filename.sql"


3. Take dump without create table statement

For this you can use --no-create-info

mysqldump -u username -p --no-create-info databaseName tableName > "filename.sql"

4. Take dump of a table with where condition

--where option is used for this.

mysqldump -u username -p --no-create-info databaseName tableName --where='id <184310'  > "filename.sql"

5. Take dump of table with custom query

Some times we need to apply complex logic when creating dump. We can implement custom query or multiple joins with mysqldump command like below.

eg 1:
mysqldump -u username -p  --lock-all-tables databaseName table1 --where="table1_id in (select table1_id from table2 where table2_column <100000)" > "filename.sql"

eg 2:
mysqldump -u username -p  --lock-all-tables databasename table1 --where="table1_id in (select table1_id from table2 where table2_column<100000) AND table1_id NOT IN (select table1_id from table2 where table2_column>50000)" > "filename.sql"

Change this example according to your need.

For more mysqldump options visit mysql site.

If you don't familiar with command line then you can use phpmyadmin to export database. But command line is way faster than phpmyadmin. If you have a larger database then use mysqldump command line utility. 
  


Everything You Need To Know About Lg Thinq

Lg thinq Everything you need to know






"Thinq" or "Lg Thinq" is a phrase that is already famous in the tech industry. Even though there are people who are still don't know what it means and why the South Korean multinational company LG use add this "thinq" tag with its latest devices.

What is Thinq?

Basically Thinq or LG SmartThinQ is brand launched by LG in 2007. But the specialty is every device that feature Thinq brand name will be equipped with latest Artificial Intelligence (AI) Technology. Thinq brand is originally launched for consumer electronics and home appliances such as air conditioners, TV and refrigerators. Also the first product to have Thinq branding is a smart refrigerator with features such as food management system and smart savings options.

Lg smart refrigerator Thinq
LG Smart Refrigerator

In Feb 2018 the company launched its first smartphone with "Thinq" branding called the LG V30S Thinq. After that company kept on launching several smartphones with this branding like LG G7 Thinq, LG V40 Thinq etc. 

Features

  • Google Assistant and Alexa voice commands support in LG ThinQ-branded TV.
  • Uses sensor data and different features such as product recognition and learning engine technologies to enhance products performances.
  • Can control key features of thinq products by using the LG SmartThinQ® application.

Lg thinq products ranges from mobile phones and televisions to refrigerators, washers, vacuums and more. These smart, connected home appliances let one to get everything done quickly and more efficiently. With SmartThinqApp people can remotely control air conditioner, vacuum and other smart appliances while on-the-go. 

How to connect remote DB from localhost using PhpMyAdmin

Connecting to a remote database from localhost can be done in many ways. Here I am going to explain a very simple way to do so. That is, connecting a remote database using phpmyadmin in the local server.
To do so you need to follow the simple steps given below,
Note: Hope you guys have server installed in your local machine Xampp, Wamp etc. I am using xampp for the tutorial.

1.       Open the XAMPP control panel. You can open it from the Xampp directory. (eg: C:\xampp ->xampp-control)
2.       Click on the Config button on the right side of Apache and select PhpMyAdmin (config.inc) from the dropdown list.
3.       Now you need to add the connection details in the config.inc document just before the php closing tag in the following format.
Eg:
$i++;
$cfg['Servers'][$i]['host'] = ''; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = '';//user name for your remote server
$cfg['Servers'][$i]['password'] = '';//password
$cfg['Servers'][$i]['auth_type'] = 'config';
4.       Now save the document and restart the server.
5.       Open phpmyadmin (localhost/phpmyadmin/) and you can see a section on the left sidebar “Current server:” with a dropdown list. From the list you can select the remote server and do the work.
Hope this tutorial is helpful to somebody. You can give your feedback on the comments below.

How to Restore Accidentally Deleted Google Chrome Data

If you have accidentally deleted Google Chrome user data including bookmarks, saved passwords and search history, then you can restore the chrome data easily by accessing the User Data folder. Google Chrome automatically stores all your browser data including bookmarks, saved passwords, search history and settings in a hidden folder named User Data inside the AppData folder.

First you need access to the User Data folder. In order to view the folder, first enable the hidden files and folders.

For Enabling the Hidden files and folders view

  • Search for "show hidden files and folders" in the start menu.
  • Check to enable the "Show hidden files, folders, and drives" option.
folder options show hidden files and folders

  • Then Click OK


To Restore the Chrome Data

  • Close the Google Chrome
  • In the Windows Explorer, navigate to the location "C:\Users\%USERNAME%\AppData\Local\Google\Chrome\" , where %USERNAME% is your system username
  • Right click on the "User Data" folder and choose "Restore previous versions" option.
chrome user data


  • Choose an older version of “User Data” folder and click Restore.
restore user data


When restore is completed, open Google Chrome. Your deleted data, passwords, bookmarks etc will be back again.

Nubia Z17 Mini with dual-rear camera setup launched in India at Rs. 19,999

ZTE Nubia has launched its Nubia Z17 Mini smartphone with dual rear camera setup in India. The device is priced at Rs.19.999 and will be available via Amazon from June 12.

The Nubia N17 Mini features a 5.2-inch Full HD display with 1920 x 1080pixels resolution. The screen also has a pixel density of 424ppi and it comes with Corning Gorilla Glass protection. The smartphone is powered by a Qualcomm Snapdragon 652 Octa-Core 64 bit processor coupled with 4GB RAM. The device possesses an internal storage of 64GB which can be expanded upto 200GB via microSD card. 

black nubia z17 mini
The Nubia Z17 Mini comes with a dual-rear camera setup consisting of two 13MP Sony IMX258 sensors - Sony full-light MONO sensor and a true color RGB sensor. The dual rear camera setup has a 3D mode that creates interactive 3D pictures. On the front the device has a 16MP sensor with 80° wide angle lens and F2.0 aperture. 

The phone runs on Nubia UI 4.0 based on Android 6.0 Marshmallow. The Connectivity options of this device include Bluetooth 4.2, Wi-Fi 802.11 b/g/n/ac, GPS, GLONASS, and USB Type-C port. The Nubia Z17 Mini is backed by a 2950mAh non-removable battery

Moto C with 4G VoLTE launched in India at Rs. 5,999.

Lenovo owned Motorola has officially launched Moto C in India. The phone was launched in some foreign countries last month. The budget smartphone is priced at 5,999 and will be available through leading retailer stores across India. Moto C will be available in two colour variants - Pearl White and Starry Black. In Indian market the Moto C will go head to head with Xiaomi Redmi 4A which is also priced at Rs. 5,999. 
moto c black smartphone

Key features of the device are
  • 5-inch FWVGA (854×480) display
  • 5MP rear camera with LED Flash
  • 2MP front camera with LED Flash
  • 1.1GHz MediaTek MT6737M quad-core Cortex-A53 SoC 
  • 1GB RAM
  • 16GB internal storage
  • Expandable up to 32GB
  • Dual SIM
  • 4G VoLTE
  • Android 7.0 Nougat Operating system
  • 2350mAh Battery 

Yu Yureka Black launched in India at Rs. 8,999.

Yu Yureka BlackYU Televentures are back with a latest smartphone called Yu Yureka Black. The smartphone is priced at Rs. 8,999 and the phone will be available for online purchase from Flipkart through a Flash sale scheduled at 12AM on June 6. Yu is continuing its online only strategy. The device will be avaiable in two color options- Chrome Black and Matte Black colour variants.

YU Yureka Black features a 5-inch Full HD IPS display (1080×1920 pixels) with a 2.5D curved glass design. The Yu Yureka possesses a metal unibody design. The device is powered by a 1.4GHz octa-core Qualcomm Snapdragon 430 MSM8937 64-bit processor coupled with 4GB DDR3 RAM. It comes with 32GB of internal storage and supports storage expansion up to 64GB via microSD card. 

The Yu Yureka black comes with a 13MP rear camera with dual-LED flash and supports different modes like Night, Panorama, and HDR. The device also possesses an 8MP front facing camera with selfie flash. The smartphone also features a fingerprint scanner embedded on the home button.

The connectivity options of the device include 4G VoLTE, Bluetooth, Wi-Fi, Micro-USB, and GPS. The device runs on the Android 6.0 Marshmallow out of the box. The smartphone is backed by a 3000mAh non-removable battery.