How to Backup and Restore MYSQL Database from Commando Line (cmd)

We can backup and restore large my sql database using cmd.

  1. Open cmd
  2. Go to directory where my sql is installed in my cause (C:\wamp\bin\mysql\mysql5.5.16\bin)

Backup my sql database:

 

Restore my sql database:

 

Note:-

You can change server name / host (-h localhost), user name (-u root) and password (-p )