How To Dump and Restore MySQL Databases using Windows Command Prompt

Hello Friend's,
Today, We learn how to Dump & Restore Mysql Database using command prompt.
Now Follow the step by step
Step 1:-Press win key + R and type cmd then press Enter key
Step 2:-Open the Command Propmt
Step 3:-Set temporary mysql path to the windows variables
           set path=C:\wamp\bin\mysql\mysql5.6.17\bin
         Press Enter Key

Step 4:-After set the location of mysql to the windows variables.You should to check mysql                            command type mysql on command propmt then press Enter key
Step 5:-After That go the path where you want save mysql dump database file
             Example : D:\database\

Step 5:-After That Export/Dump mysql database type the command
           mysqldump -u  username -p dbname > filename.sql
           Example: D:\databas>mysqldump -u root -p drive > drivenew.sql
           Then press Enter Key

Step 6:-Now you will notice in D:\database a sql file created of name drivenew.sql
Step 7:-After that you need to first connect mysql to the cmd using syntax
            mysql -u root -p
          Then press Enter key
Step 8:-After that you need to restore into new database then you need to first create new database
            Syntax:
            create database filebloom;
Step 9:-Now You can restore your database using syntax
             mysql -u username -p dbname < filename.sql;
            Example:D:\database>mysql -u root -p filebloom < drivenew.sql;

           
Thanks For visit my blog, I hope this post is useful many people.

Java Program based on layout manager

Hello Friends,Today we learn advance java program.Today I am taking an example of how to create container and create components like label,textbox and button and set their layout.

Java program based on layout manager example
import java.awt.*;
import javax.swing.*;
public class example extends JFrame
{
JTextField t1;
    JButton b1;
JLabel l1;
  
public example() throws Exception
    {
//creating container
      Container c=this.getContentPane();
c.setLayout(null);

                //creating textfield and set their layout
t1=new JTextField();
t1.setBounds(200,100,130,20);

                 //creating label and set their layout
l1= new JLabel("what is your name");
l1.setBounds(50,100,250,30);

                 //creating button and set their layout
    b1=new JButton("Save");
b1.setBounds(70,200,120,42);

c.add(t1);
c.add(l1);
c.add(b1);
    }
      
public  static void main(String args[]) throws Exception
{
example obj=new example();
obj.setTitle("Layout example");
obj.setSize(500,300);
obj.setLocationRelativeTo(null);
obj.setVisible(true);
obj.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}//End of main
}

OUTPUT

JAVA PROGRAM TO FIND SUMMATION OF TWO COMPLEX NUMBER USING STATIC FUNCTION AND MEMBER DATA

Hello Friends,Welcome back to Technology learning Raj Roushan after such a long time.

Today I am telling about java program by requesting by my friends.Today i am going to tell you how to write java program to find summation of two complex number Using static method and member data.And why static function can not access the non-static member variable of class.

Java Program

import java.io.*;
class complex
{
int r,i;

int relno,imgno; //this is not accessible by accessible by static class this will generate an error
static int relno,imgno;//this is accessible because static function can access static data
complex()
{
r =0;
i=0;
}
public static void sum(complex c,complex d)
{
relno=c.r+d.r;
imgno=c.i+d.i;
System.out.println("The sum is "+relno+"+"+imgno+"i");
}
public void read()throws IOException
{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
System.out.println("\nEnter the real part");
r=Integer.parseInt(br.readLine());
System.out.println("\nEnter the imaginary part");
i=Integer.parseInt(br.readLine());
System.out.println("\nYou have entered : "+r+"+"+i+"i");
}
public static void main(String s[])throws IOException
{
complex c=new complex();
complex d=new complex();
System.out.println("First number");
c.read();
System.out.println("\nSecond number");
d.read();

/*complex add=new complex();

add.sum(c,d);    this is wrong because object is not required for calling static function i will explain in below*/
sum(c,d);
}
}

The output

non-static member variables of a class always belong to an object – meaning that every object has it’s own personal copy of non-static member variables (also known as instance variables). And, static functions have no object to work with since they belong to the class as a whole. Remember that you can call a static function without an object – and for that exact reason a static function can not call instance variables. 

shoping diwali offer

HOW TO INCREASE BATTERY LIFE OF YOUR LAPTOP

Hello Everyone,Today's I am going to tell you how to increase battery life of your laptop.Every laptop or Netbook user these days have the same headache of limited backup time of batteries. As far as your system is new , you will have a good backup time but when it becomes a few months old you will definitely face problem of limited battery life.

So here I am giving you a solution to Increase battery life of laptop upto a sufficient extent.

There is an inbuilt command in your computer to Increase battery life as well as the performance of the system but not all users are aware of it. Some laptops directly provide an interface with option termed as “ POWER SAVING MODE ” but if your laptop is old or don’t have this feature by default , you need not to worry because you can do the same task manually.

If you have a laptop with Windows 7 installed, you can use the ‘powercfg‘ command . It will display useful information about your laptop’s energy consumption and usage. If you can understand and maintain it correctly then you can extend your Battery life and performance by great amount.

Steps to increase your battery life:-

Step 1:- Click on the Start Menu and type “ CMD ” in the Start Search bar.

Step 2:- The search will start and it will then display an icon of “ CMD ” . simply right click on it and select Run as administrator.

Step 3:- It will open command line, now simply run the command “powercfg -energy” without quotes. (For windows 7 users.)Windows 8 users can Simply run the command “powercfg /energy” without quotes.

Step 4:- Now Press “Enter”.

Once you successfully execute this command , Windows will run a complete scan of your system and it will find some ways to improve performance and power efficiency.

The results of this process will be saved to an HTML file, which is commonly present in the “System32” folder of most of the systems.

To access this file, simply follow the path which will be displayed in command prompt window after completion of the command. Read This file to understand that what program in your system is consuming more power and degrading the performance. Fix the Problem to Increase battery life of laptop.

How to reduce to the number of programs running at startup

Hey guys,Good Morning to all of you.Now i am going to tell you how to reduce to the number of programs running at startup.Sometimes your PC is taking too long to boot, it’s probably because you have far too many programs running at startup.And this tricks help you to  Reducing this problems very easily, it will make your PC launch noticeably faster and lighter upon first load. To change the items running at startup, go to Run by pressing Windows key + R, and type "msconfig." A small window will appear (see the screenshot below), 

select the Startup tab. From here you will be able to turn off many startup programs, which can shave several seconds (or minutes) off your boot time. (Note Windows 8 has moved this functionality to the Task Manager). Try to make sure you research what you are turning off as some processes might be needed by third party programs or drivers you have installed.

HOW TO CREATE HOTSPOT OF YOUR SHARED Wi-fi IN YOUR PC

Hello Friends now I am back new tricks for you.Today i am going to tell you how create hotspot on your pc. You can easily create the hotspot of the wifi which your PC is connected using160 WiFi Application. This will allow you to create hotspot and share your computer internet wired or wireless to any other device very easily.

HOW TO CHANGE BACKGROUND COLOR OF GOOGLE ACCOUNT PAGE

Hello Friends,I am back with new tricks.Today i am going to tell you how to change background color of google account.This 100% successful tricks to make your google account or gmail page colorful.The simple steps to follow for changing background color of your gmail accounts.

Step 1:-Open your browser.

Step 2:-Login your gmail account.

Step 3:-In new tab search gmail redesigned or click this link to download gmail 

https://chrome.google.com/webstore/detail/google-redesigned/mkpckdjkmmgflnghjdokniaakigbfofa?hl=en
Step 4:-Now click at add chrome
Step 5:-After successful downloading and as chrome extension.

Step 6:-Now In the browser you will notice in right hand side a         small box will appear like this             

Step 7:-Click on this box and select theme and download                 Step 8:-Now you gmail account background will change.                                                                          

HOW TO OPEN YOUR NOTEPAD THROUGH JAVA PROGRAMS

Hello friends,Now i am back with new java programs.Now you can open your notepad in programmer style.Now i am going to tell you how to open your notepad through java programs.

Notepad is mostly used software.notepad is very useful for programmer because most of the programs run through notepad.like java c, c++ etc.

Steps to create a java programs to open notepad.
Step 1:-Open your notepad
Step 2:-Copy paste this code

     import java.util.*;
    class notepad
   {
           public static void main(String []a) throws Exception
          {
               Runtime r=Runtime.getRuntime();
               r.exec("notepad");
     
          }
  }
Step 3:-Now Save this with extension .java for example notepad.java
Step 4:-Again open new notepad file.
Step 5:-Copy paste this code
            javac notepad.java
           java notepad
          pause
Step 6:-Save this file with extension .bat for example notepad.bat
Step 7:-Now click at this file.

HOW TO CREATE A BATCH FILE FOR JAVA

Hello frinds, I am back with  new things to learning.Today i am going to tell you how to create a batch file for java.As we know that java is very famous language.Android operating system is built in java language.many people want to learn this language.most of the people compile their java program through command line.but problem of this you have to write every time command to execute your program.But now you can create a batch file to execute java program from anywhere in your computer or any other computer.

Steps to create batch file to execute java program.

Step 1:-Open the notepad

Step 2:-Type the following command.

     

     javac filename.java

     java classname

     pause

Step 3:-Save the file with extension .bat

example program1.bat

Step 3:-Now double click on this file whenever you need to execute your program.

koolpad note 3 lite

How to lock your any software with password

How to change folder icon style

How to make your any file or folder inaccessible

PHOTOSHOP ERROR 16 SOLUTION

Hello friends,I am back with new tricks.Now a days millions of photoshop user available in world. photoshop  is the best software for photo editing.Its provides many tools for editing your images. And make your images  more creative and attractive.But sometime it will generate error message while opening your photoshop software.Error 16 in photoshop is very common error.In this error os instructs you reinstall or install again this software.Then you want to know that what is the solution of this error without uninstalling  photoshop.

The steps for solution of error 16.
Step 1:-Right click on photoshop software.
Step 2:-Click at Run as adminstrator

TOP 5 TIPS FOR SEO

SEO is the process of developing  site to appear at the top of search results. When users search for something in search engines like Google, yahoo etc., then these search engines will search your webpages, videos and other stuff which are relevant to the search query and place them on search results.
1. Quality content
Always try to provide quality content in your blog. If you write quality posts then people will like your articles and share them so that that you can increase your blog traffic. On the other hand, if you copy stuff from other sources than people may get the wrong impression on you and will effect your blog traffic in a bad way. So try to provide genuine content in your blog articles.
Read: Get Godaddy $1/month hosting with a free domain
2. Social Media
Social media is the best source to increase blog traffic. As you are beginner, you cannot get huge traffic in over night. So all you need to do is to get traffic from social media.
Just follow these simple steps to increase blog traffic from social media
3. Link Building
Link Building is the process of getting back links to your site from other sites. To get quality back links to your site write Guest posts for trusted and high page ranked sites and ask them for a Do Follow back link. Search engine bots follow these Do Follow back links so you can get more traffic to your site. Also Commenting on CommentLuv blogs will helps you to get traffic.
4. Responsive Template
Use responsive and well SEO optimized template for your blog. Responsive template makes your users comfortable while reading and is an extra benefit for your success in blogging. So use good looking responsive template for your blog and try to have less loading time for your blog by removing unwanted widgets. Have a look at GENESIS WordPress Themes
5. Image Optimization
Use proper images for your blog articles and try to have at least one image for every blog post. After adding image to your post, just click on properties and give Title text and Alt text. Search engine bots will read thisAlt text from your article so use image optimization for better results.
Godaddy .COM domain at RS 99 [Get the deal]

TOP 3 SITES WHICH PROVIDE YOU UNLIMITED FREE SMS ON ANY NUMBER

Hello friends,Now i am going to tell you Top 3 sites which provide you free unlimited sms on any mobile number.And you can also trace of location of any mobile number.And you can also make a call and earn money by inviting to your friends.

These sites are:-

1. Site2sms
2. way2sms
3. 160by2

HOW TO MAKE A FREE CALL FROM WINDOWS PHONE.

Hello friends,Today you will learn with Raj Roushan How to make a free call from windows phone.

I had already previously many post related to Windows phone.Now i am tell another tricks of windows phone.By this you able to make a free call from your windows mobile phone.There are many application in the windows store which provide you make a call.

some simple steps to get this application.

Step 1:-Open  your windows phone store.

Step 2:-Search the "royalmobile" from windows phone store.

Step 3:-Now download and install this application.

Step 4:-After successfully installation this application then start                   this application

Step 5:-Now sign up your account.

            Now enjoy it free call.