Easiest way to export your database is through phpMyAdmin. With few clicks you can get database export and then use it as a backup or to import at another location. It is useful to have different file names on each export, so you don’t end up overwriting your backups accidentally.

In the Output section of your phpMyAdmin export page, you can define File name template.


Using this notation, you can get time-dependent file name on every export:


More info on format parameters you can find in strftime function reference.