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