How to restore/import dump file in MySQL workbench ?

The following steps can be applied to import dump file :

1. Open MySQL workbench and connect to database using your password. You can see the window as given below:

2. You will be provided two ways to import the dump files.
First, you can import the dump files by selecting the option "import from dump project folder". Here you can select the folder where all your dump files are stored. It will automatically import the files in database from which it was created if the database with the same name exists. So, it is better to create database with the same name and then start the importing process.
Second, you can select the option "import from self-contained file" which will allow you to add dump files one by one. In this option before starting import process, choose the default target schema as your database in which you want to import the dump files, from the drop down list.
 Then click on "start import" button. This will import your single dump files in the selected database. Similarly, you can repeat the process to import other files as well.

3. You are done with it. If you don't see the imported table in your selected schema then close and re-open the MySQL workbench.

Read More

How to backup data in MySQL workbench ?

The following steps can be applied to backup data in MySQL using workbench :

1. Open workbench and connect to your database using your username and password.
2. Click on "Data Export" option under "Management" at the left side of the screen.

3. You will find a list of schema from where you can select which of the schema's table do you want to backup. If you want to backup all the tables of particular table then simply click on that schema but if you want to backup only few tables of a particular schema then double click on that schema and you can see the list of tables present in the selected schema on the right side of the screen where you can unselect the table you don't want to backup.

4. Select the folder where you want the backup file to be created.

5. Finally, click on the button "start export" and wait for the operations to complete.

6. You are done. Check your specified folder to get the backup file. You can again import/restore the data whenever needed.

The above process will backup each tables separately. If you desire to backup all the tables in a single file then after step 3 in above process, click on "Export to self-contained file" radio button and also tick the option "create dump in a single transaction" and select the folder where you want to save the file. Then click on export button.

Read More

How to watch IPL 2018 for free ?

There are many ways you can go through to watch IPL 2018 for free. I will be discussing few methods here.

First of all if you are in India you can watch IPL through Jio TV app or airtel TV app which you can download from playstore. 

There are few other methods which might not be official to watch IPL on internet from broadcaster.

1. You can download an app named "Live NetTV" by clicking here and you can run on your android mobile. You can get tons of channel here. When installed on your android phone, click on "sports" option and scroll down to find "sky sports cricket" channel in international category. You can stream from there. You will get various links over there. You can choose whichever works for you. 

You can also stream it on "willow cricket" channel available in the same category.

How to run in PC?

If you desire to run this app in PC,  download bluestacks or any other android emulator and then you can install this app over there.

2. You can also use alternative android app like "Mobdro" to watch IPL live on moblie. Here also you can find various channels for live streaming of IPL may be you can find star sports 1 as well here along with the channels mentioned above.

3. If you don't want to use apps or watch on mobile, here are few links which can help you for live streaming on your PC.

www.crictime.com

www.ipl.mylivecricket.cc

4. You can also watch IPL live on "Hotstar" but the problem is you will get it free for only ten minutes. After that you will have to subscribe to any one of their plan to watch it. You can actually watch free on hotstar as well but it a is tedious job you will do i.e. you will have to clear the cookies of your browser in every 10 minutes.

Except above all you can watch the highlights of every match, press conference, presentations, amazing moments of the matches of IPL anytime on its official website "iplt20.com".

Also you can watch some matches on DD sports but an hour delay, probably only one match in a week.

Read More