WordPress.org

Ready to get started?Download WordPress

Forums

UpdraftPlus - WordPress Backup and Restoration
[resolved] UpdraftPlus not backing up non-WordPress database table? (5 posts)

  1. martey
    Member
    Posted 5 months ago #

    I have a site (WordPress version 3.7.1) with the UpdraftPlus plugin (version 1.7.35) installed. Its database contains the WordPress core tables, as well as a table named "program" containing additional data used by the website. UpdraftPlus' logs claim that all tables (including this non-WordPress table) in the database are being backed up, but the log does not show any rows being added to the backup and the table do not appear in the completed backup.

    Partial log file:

    ...
    0051.836 (0) Table wp_terms: Total expected rows (approximate): 8
    0051.848 (0) Table wp_terms: Total rows added: 8 in 0.01 seconds
    0051.850 (0) Table wp_terms: finishing file (backup_2013-11-04-2202_[redacted]-db-table-wp_terms.table.gz)
    0051.855 (0) Table program: finishing file (backup_2013-11-04-2202_[redacted]-db-table-program.table.gz)
    0051.861 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_options.table.gz: adding to final database dump
    0051.882 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_users.table.gz: adding to final database dump
    0051.884 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_usermeta.table.gz: adding to final database dump
    0051.887 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_commentmeta.table.gz: adding to final database dump
    0051.888 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_comments.table.gz: adding to final database dump
    0051.890 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_links.table.gz: adding to final database dump
    0051.892 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_postmeta.table.gz: adding to final database dump
    0051.908 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_posts.table.gz: adding to final database dump
    0052.394 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_term_relationships.table.gz: adding to final database dump
    0052.398 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_term_taxonomy.table.gz: adding to final database dump
    0052.401 (0) backup_2013-11-04-2202_[redacted]-db-table-wp_terms.table.gz: adding to final database dump
    0052.403 (0) backup_2013-11-04-2202_[redacted]-db-table-program.table.gz: adding to final database dump
    0052.420 (0) backup_2013-11-04-2202_[redacted]-db.gz: finished writing out complete database file (1216 Kb)
    0052.457 (0) Total database tables backed up: 12 (backup_2013-11-04-2202_[redacted]-db.gz: checksum (SHA1): 23a6101e0f41253b117bcddd684f2f0f9ff9c79b)

    http://wordpress.org/plugins/updraftplus/

  2. David Anderson
    Member
    Plugin Author

    Posted 5 months ago #

    Hi Martey,

    Please can you email me the whole log file, and the database backup file? Send them to: contact@updraftplus.com.

    Many thanks,
    David

  3. David Anderson
    Member
    Plugin Author

    Posted 5 months ago #

    Hi Martey,

    This won't be what you wanted to hear, but it's actually the log messages which are a red herring. UD is meant to back up only the WordPress tables... there is a slight difference in what's logged; here's a WP table:

    0051.836 (0) Table wp_terms: Total expected rows (approximate): 8
    0051.848 (0) Table wp_terms: Total rows added: 8 in 0.01 seconds
    0051.850 (0) Table wp_terms: finishing file (backup_2013-11-04-2202_Council_on_Education_for_Public__(redacted)-db-table-wp_terms.table.gz)

    Whereas the one not being backed up only gets this:

    0051.855 (0) Table program: finishing file (backup_2013-11-04-2202_Council_on_Education_for_Public__fe9e1a6c072b-db-table-program.table.gz)

    If you look in the actual database backup file itself, then there should be a message that says that the non-WP table was skipped.

    I've changed that now, so that in the next release the log will explicitly indicate that the non-WP table wasn't backed up.

    However, having said that... the ability to add other, non-WP tables has been a feature that's been requested, and we plan to add it to UpdraftPlus Premium. Presently, we've got working code that can do this in a very simple way - it can do what you want (i.e. add all tables found in the MySQL database). If you buy UpdraftPlus Premium and then give me a shout, then I can email the new version over to you.

    Best wishes,
    David

  4. martey
    Member
    Posted 5 months ago #

    I looked at the code and it seems that the plugin backups all tables starting with the database table prefix. I changed the name of my table (from "program" to "wp_program") and it is now backing up properly.

  5. David Anderson
    Member
    Plugin Author

    Posted 5 months ago #

    Hi Martey,

    Yes, that's right. When I said "WordPress tables", I meant "those with the prefix of the WordPress install".

    Glad you got it fixed!

    Best wishes,
    David

Reply

You must log in to post.

About this Plugin

About this Topic