From: David McInnis <[EMAIL PROTECTED]>

> Could you share your script for doing the date thing with the rest of
> us?  That sounds useful.

> > From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] 
> > mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar -cf
> > MySQL-Backup-DATE.tar.gz -z tmp.sql && rm -f tmp.sql
> > I use a script (to determine DATE)...


How about:

  mysqldump -uUsername -pPassword --all-databases > tmp.sql && \
  tar -cf MySQL-Backup-`date +%Y-%m-%d`.tar.gz -z tmp.sql && \
  rm -f tmp.sql

Try this for an example that doesn't change anything:

  echo MySQL-Backup-`date +%Y-%m-%d`.tar.gz

---
Rodney Broom
Programmer: Desert.Net

sql



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to