phpMyAdmin: Different SQL file name on each export

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.

phpMyAdmin-Output-section-screenshot

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. I work for Computer Rock (former Spoiled Milk) since April 2011. 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

Leave a comment

Your email address will not be published. Required fields are marked *