Of course dumping and restore mysql database can be done easily with phpmyadmin. But what if phpmyadmin is in error state and you need to backup your database on server A immedietly and move it to server B?
The answer is use command console, if you backup database od your virtual private server or dedicated server, login first as root from SSH access