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:

cd C:\wamp\bin\mysql\mysql5.5.16\bin

mysqldump -h localhost -u root -p  database_name > c:\backup_name.sql

 

Restore my sql database:

cd C:\wamp\bin\mysql\mysql5.5.16\bin

mysql -h localhost -u root -p  database_name < C:\backup_name.sql

 

Note:-

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