The previous owner of the server where our matrix system was installed suddenly closed their account on the hosting company, thus forcing us to download all files that was in the server.
now that we want to put the site online not using the matrix system on the mean time, we are not sure on how to get the site's contents. the whole matrix folder has too many folders wwith same file names.
is there any way we can find the sites contents in these folders? just the contents of the standard pages would do. thanks you very much.
Contents is in the databse, attachments and cached content will al be in the data folder.
thats what im afraid of.. since we have no postgre installed servers at the moment is there anyway we can just view the backed up db?
Postgres backups are SQL text but this is getting a bit painful...
im looking for all the contents of the standard pages, does anyone knew or familiar what field on the db are all standard page contents being saved?
thanks a lot for the replies. sorry for my bad english
They're not stored in a field. The contents are of the html attribute for the asset type page_standard. You'll need to look in sq_ast_attr to find the attr_id that corresponds to this, then find the relevant entries in the sq_ast_attr_val table.