How to copy Mysql database from one Computer to another / backup database using mysqldump

1.   Creating a dumpfile from database/ Taking      backup of MySQL database:

-     Open command prompt.

-     Execute following commands to change directory

>c:  “press enter”

>cd  program files/MySQL/MySQL Server 5.1/ bin “press enter”

>mysqldump -u root  -p databse_name > database_name.sql 

   “press enter”

  Enter password: password of MySQL

Copy sql file and paste it in PC where you want to transfer database.

         2. Dumping sql file into database:-

          - Open MySQL  command line client command prompt.

          - Execute following command to create database.

                 >create database database_name;  “press enter”

   Database name is must as that of your database _name.

 Copy that sql file into location “c:/program files/MySQL/MySQL Server 5.1/bin”

          - Now open command prompt and execute following commands.

                >C: “press enter”

                >cd program files/MySQL/MySQL Server5.1/bin “press enter”

                >mysql –u root –p database_name < database_name.sql    “press enter”

           Your database is created on PC.

           Now in MySQL command prompt check your database.  

Guess You Got the Answer...