Two simple commands to export and import (backup and restore) mysql database

phpMyAdmin is a great web based tool. However, I ran into issues with it when you try to export and import but the database is growing too big. You will likely run into error similar to the following:
Allowed memory size of 67108864 bytes exhausted (tried to allocate 32231548 bytes) in ... zip.lib.php
If you are lucky enough that your hosting provides you with SSH access, you can use the following two commands to export and import your database