Here is a memo for the mysqldump command:

  • Making a dump file (b.sql is the file name you want to have for the dump file):
...>mysqldump -hHostAddress -uUserName -pUserPsswd dbName > b.sql;
  • To restore the data go to the directory where b.sql is stored and:
...>mysqldump -hHostAddress -uUserName -pUserPsswd dbName < b.sql;