mysql backup and restore database

go to command promt admin

backup database

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqldump -u root -p mvivekweb > c:/vivek.sql
Enter password: *****


restore database

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -u root -p mvivekweb < c:/vivek.sql
Enter password: *****

C:\Program Files\MySQL\MySQL Server 5.7\bin>