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. 
  


Subscribe to: Posts (Atom)