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)

Steps:

  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.

By Sri

Leave a Reply

Your email address will not be published. Required fields are marked *