What is the table name in database?
Permalink
Our hosting service provider had a major fail on their server that had a client website of ours. They have tried to restore it on a different server. Most of the website has been restored, but we are missing some page content from the backup they used. My question is this....does anyone know what the database table "name" is that contains the page content of the website? I'm looking for the table that would have contained the client entered (modified) content. Another possible option would be the name of the table that contained the past version content for each page.
Thanks for any help. It could be a major time saver.
Adriana
Thanks for any help. It could be a major time saver.
Adriana
Thanks mesuva,
The mess this provider created for us has been a nightmare. Only one site seems to have missing content but we had 11 client sites with them that were down for nearly five days if you can believe that. Plenty of majorly upset clients. We had to scramble yesterday after the provider moved sites to another server with their backups just to get the sites reasonably working but we are still trouble shooting issues. Ugh!
Adriana
The mess this provider created for us has been a nightmare. Only one site seems to have missing content but we had 11 client sites with them that were down for nearly five days if you can believe that. Plenty of majorly upset clients. We had to scramble yesterday after the provider moved sites to another server with their backups just to get the sites reasonably working but we are still trouble shooting issues. Ugh!
Adriana
However, the btContentLocal table is the one that stores data for the content blocks, so you could look in there for useful HTML snippets. The last entries in that table are going to be the most recent edits (I think). It might be useful to point out that in the database you'll notice a bunch of tables that start with 'bt' - there are for the different block types.
It sounds like the host weren't taking decent backups. Server backups should be performed nightly, so in the event of a complete server loss, the most that should be lost is a days's work.