Posted By

dawjdh on 03/30/09

Tagged

mysql php phpmyadmin strftime

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

philrae

phpMyAdmin strftime Dump Format

/ Published in: PHP

In phpMyAdmin you can define strftime formats for your dumped database sql files. Here you are with two formats, one for sigle table export, one for multi-table export.

Expand | Embed | Plain Text

Single Table Format:
 
__DB__.%d_%m_%Y_%H_%M_%S
 
Multi Table Format:
 
__DB__.__TABLE__.%d_%m_%Y_%H_%M_%S

Report this snippet Tweet

Comments

Subscribe to comments

Posted By: philrae on October 28, 2010

I prefer it like this as it means that when listed alphabetically in a folder, it will chronologically be correct:

__DB____%Y%m%d_%H%M

Posted By: philrae on October 28, 2010

Edit, trying to insert as code...

__DB____%Y%m%d_%H%M

Comment:

You need to login to post a comment.