Okay
  Public Ticket #2880148
Backing up tables
Closed

Comments

  • Lucas started the conversation

    I'm using WPDataTables to collect information from event speakers about their sessions. Thus they table is front-end editable by logged-in users. However, I'm concerned about maintaining data integrity. What is the recommended way to retain backups of the table should something go wrong?

    I'm running regular backups to remote storage with a plugin, but since these files are compressed there's no obvious way to download just the file from WPDataTables. I assume this is a SQL database, though I'm not familiar with manipulating those outside of the plugin.

  • [deleted] replied

    Hi Lucas

    Thank you for reaching out to us.

    I'm afraid, other than cloning the website, the only available option is to copy all database tables.

    Not sure if that's what you're looking for, but it can't be achieved without copying the database tables.


  • Lucas replied

    Thanks for confirming.

    Specifically, if I perform a backup with UpdraftPlus of the database, not files, of the site, will that include the WPDataTables databases?

  • [deleted] replied

    You are most welcomesmile.png

    I haven't tested UpdraftPlus, so I don't know if there are any issues with it. Basically, if it copies the entire database, it should copy everything.

  • Lucas replied

    Perfect. That's what I was thinking, but I'm not clear on whether tables are stored in the site's "database" or "files".

  • [deleted] replied

    Hi Lucas

    The data is stored in the site's database so when you copy the website the data will be copied over as well. But feel free to reach out to us in case you come across any issues or difficulties we will do our best to assist you.