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.
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.
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.
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.
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?
You are most welcome
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.
Perfect. That's what I was thinking, but I'm not clear on whether tables are stored in the site's "database" or "files".
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.