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:
@DATABASE@-%Y-%m-%d-%H-%M-%S
More info on format parameters you can find in strftime function reference.
By Aleksandar Jakovljević
My name is Aleksandar Jakovljević and I am a web developer from Belgrade, Serbia.
I was born in Smederevo, in 1980. I started focusing on web development since late 2003. I am mostly focused on open source web technologies.
I specialised in PHP, focusing on Symfony framework, with skills in Drupal and WordPress, too.
I worked more than 7 years for art_net studio and 10 years for Computer Rock (former Spoiled Milk). Now I am working on developing industry leading subscription management system as a part of Plenigo team since August 2021.
I love the web and everything related to it. The possibility to publish your ideas quickly and make them available to the entire world is what made me decide to pursue a career in web development.
Follow on:
Twitter | GitHub | LinkedIn | Facebook | Instagram
Hire me on Upwork