How to get sql dump from mysql

How to get sql dump from mysql
Please follow these steps in order to take sql dump from mysql

You must have MySQL version more 5.6 (Chances of working with MySQL 5.5 is very low)


  1. Start–>Run–>cmd (Run as Administrator)
  2. Copy your mysql path  (C:\……\mysql\bin)
  3. In command prompt, set path (cd  C:\……\mysql\bin )
  4. After setting path enter
    mysqldump -u (username) -p (databasename)>sqldump.sql
  5. When you run it, it will ask for password, enter your database password
  6. your sqldump will be created inside bin folder.