mysqldump —Database Backup Program

Windows command promt:

To go a drive, just need to write the drive name such as > D:
To access directory D:\>cd directory_name such as  D:\>cd test_directory
To access file D:\>cd directory_name\file_name such as D:\>cd test_directory\test.php

To access upper directory [D:\users\devel2\test>cd..] the output will be  [D:\users\devel2>]

To dump mysql db table: F:\xampp\mysql\bin\mysqldump -h localhost -u root -p dxlogin users > users.sql

F =  is the drive name where xampp is installed,
-h localhost = mysql host name
-u root = mysql user name
-p = mysql password
dxlogin = database name
users = table name
users.sql = the sql file that will be dumpped.

reference site url for mysql dump http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s