GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

backup script using sqldump and table files

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • backup script using sqldump and table files

    Hi,

    I'm looking for a bash backup script that will do the following:

    1. Use mysqldump to dump the data into individual files, one for each table.

    2. Tar and compress the dump, removing the individual files.

    3. Store the tar file using a date format, something like "backup-yyyymmdd".

    4. Remove files that are 7 days or older

    I'm familiar with mysqldump, less familiar with using bash.

  • #2
    Found this article which is pretty close to what I'm looking for.



    http://forum.slicehost.com/comments....cussionID=2758

    Comment

    Working...
    X