[opencms-dev] locate template in database

[Christoph P. Kukulies]

On Tue, Sep 15, 2009 at 10:50:43AM +0200, Lammersdorf, Lorenz wrote:
> Hi all,
>  
> I have to restore an accidentially deleted template from the databases backup. Does anyone know in which table the template contents are stored?
>  
> Thanks in advance!
> Lorenz

I'm not deeply in opencms but I played a bit. Probably you know the path of
the template? 

Try 

mysql -u root -p

mysql> use opencms;
mysql> show tables;
mysql> show columns from cms_history_structure;
mysql> select resource_id from cms_history_structure where
resource_path="/system/modules/org.your.frontend/templates/test.jsp";
mysql> show columns from cms_offline_resources;
mysql> select * from cms_content where
resource_id="0d758ed0-8bd0-11de-ad6a-0015c53f6df2";
mysql> select file_content from cms_contents where
resource_id="0d758ed0-8bd0-11de-ad6a-0015c53f6df2";


Maybe, don't know. Maybe I'm totally wronf, but sth. in this vein
perhaps?


--
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de