2 trivial matters often were lost from my memory when I needed, dumping & restore database MySQL. I was very rare used this syntax, because quite very rare did business with MySQL.
Dumping MySQL Database for Backup Purpose
# mysqldump -u root -p namaDatabase > /home/capung/namaDatabase.sql
Restore MySQL Database
Before restoring the database, first create a database using root account.
$ mysql -u root -p
mysql> create database DatabaseName;
mysql> exit;$ mysql -u root -p DatabaseName < /home/capung/DatabaseName.sql
