MySQL

Whether you are running some MySQL driven website, use MySQL database for various applications or experimenting with MySQL, it is EXTREMELY important to backup your data. Recently my development machine crashed, I am using version control system (Subversion aka SVN) to protect the source code and try to backup local databases regulary... I was developing new custom components and plug-ins for Joomla CMS and have done some changes to database, some inserts/updates. I did not backup database for several days, after the crash it took me almost full day to fully restore the database.

I will briefly describe how to backup and restore MySQL database(s) with command line. This will work for Windows and Unix/Linux environments. Hope someone will find this information useful.