Thursday, 26 February 2015

How to get sql dump using command prompt in WAMP 1

To get a mysql dump of a database in wamp, first we need to set our mysql path using set path command. The example is given below.
  

set path=c:\wamp\bin\mysql\mysql5.1.36\bin

Replace c:\wamp\bin\mysql\mysql5.1.36\bin with your mysql bin directory path.

Then use the below command to export our database.
 
mysqldump -u YourUserName -p YourDatabaseName > sqlDumpFileName.sql

YourUserName will be our mysql username. And YourDatabaseName will be our DataBase name. Then command prompt will ask for the mysql password. Your should enter your mysql password to get your sql dump of your database.

Have any doubt, feel free to comment here!

1 comment:

  1. ALL LOAN SERVICES AVAILABLE

    Commercial Loans
    Personal Loans
    Business Loans
    Investments Loans
    Development Loans
    Acquisition Loans
    Construction loans
    Business Loans And many More:

    Contact Us At : royalworldfundings@gmail.com

    LOAN APPLICATION FORM:

    Full Name:................
    Loan Amount Needed:.
    Purpose of loan:.......
    Loan Duration:..
    Gender:.............
    Marital status:....
    Location:..........
    Home Address:..
    City:............
    Country:......
    Phone:..........
    Mobile / Cell:....
    Occupation:......
    Monthly Income:....
    Website You Heard About Us?......

    Contact Us At : abdulasumanumar@gmail.com

    ReplyDelete