Create A Data Script In MYSQL

Create A Data Script In MYSQL 

• First Of all Check If mysqldump works :-

Open command prompt and type mysqldump

 if you get some thing like this -

C:\Users\SANJU>mysqldump

Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

then its fine and if its not the result

•  Goto bin directory of Mysql installation folder. It is 

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin    for me.

• Set The Path To Environment Variaable .(See the previous post if you dont know).

• Now Open command prompt and type as :-

C:\Users\SANJU> mysqldump -u username -p  user> "D:\sa.sql" 

it will promt for password .

D:\sa.sql is the location for script sa.sql

Thats All You Are Done ..........................Click here For Video