Backup Specific Posts from Database – Plugin or programmatically

  • Resolved son0fhobs

    (@son0fhobs)


    13 years, 2 months ago

    Greetings!

    Is there way to backup the database, but only specific posts, not entire tables or the entire database?

    I have a site which is more of a ginormous app. The data gets modified by users frequently, but a majority of it is only a single post. I don’t really want to be frequently be backing up a 20Mb database when I only need those specific posts backed up.

    I’ve sifted through a bunch of plugins, and many allow you to export by table, but I haven’t seen any that can export specific posts.

    Is there a plugin to do that? If not, is there a chunk of code/tutorial on how to programmatically do backups, so I can write the code myself the backup the specific post? Preferably the less work the better, but I am comfortable coding if need be.

    Thank you very much for your time, help and advice!

    (PS, if you read this and are familiar with the issue and have not leads, please let me know, as that will point me in the direction of programming it myself – which I’m less then ecstatic about, but will resort to. )

Viewing 1 replies (of 1 total)
  • Thread Starter son0fhobs

    (@son0fhobs)

    13 years, 2 months ago

    Never mind.

    I realized that there was a bit of data in every post that also needed to be backed up. So I’m writing a function connected to a cron job that grabs the metadata, combines it, and either writes it to a file on the server or emails it to me.

Viewing 1 replies (of 1 total)

The topic ‘Backup Specific Posts from Database – Plugin or programmatically’ is closed to new replies.