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.

  1. Single Table Format:
  2.  
  3. __DB__.%d_%m_%Y_%H_%M_%S
  4.  
  5. Multi Table Format:
  6.  
  7. __DB__.__TABLE__.%d_%m_%Y_%H_%M_%S

Report this snippet  

Comments

RSS Icon 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

You need to login to post a comment.