topic how to do backups while using HSQL in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-do-backups-while-using-hsql/m-p/123543#M86981 <HTML><HEAD></HEAD><BODY><SPAN>I using alfresco 2.1 wth preconfigured HSQL.</SPAN><BR /><SPAN>now I need to do backups according to the doc</SPAN><BR /><A href="http://wiki.alfresco.com/wiki/Backup_and_Restore" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Backup_and_Restore</A><BR /><BR /><SPAN>I don't know how to perform this step: </SPAN><BR /><SPAN>Export the database to Alfresco dir.root (same location as content and indexes)</SPAN><BR /><BR /><SPAN>because I am using HSQL, please indicate,thanks.</SPAN></BODY></HTML> Mon, 17 Dec 2007 09:31:45 GMT yahoon 2007-12-17T09:31:45Z how to do backups while using HSQL https://connect.hyland.com/t5/alfresco-archive/how-to-do-backups-while-using-hsql/m-p/123543#M86981 I using alfresco 2.1 wth preconfigured HSQL.now I need to do backups according to the dochttp://wiki.alfresco.com/wiki/Backup_and_RestoreI don't know how to perform this step: Export the database to Alfresco dir.root (same location as content and indexes)because I am using HSQL, please indicate,than Mon, 17 Dec 2007 09:31:45 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-do-backups-while-using-hsql/m-p/123543#M86981 yahoon 2007-12-17T09:31:45Z Re: how to do backups while using HSQL https://connect.hyland.com/t5/alfresco-archive/how-to-do-backups-while-using-hsql/m-p/123544#M86982 <HTML><HEAD></HEAD><BODY><SPAN>The HSQLDB database is stored in a subdirectory of the alf_data directory (the directory pointed to by the dir.root property) by default, so you shouldn't need to do anything special to back it up - simply back up the entire alf_data directory and you're done.</SPAN><BR /><BR /><SPAN>Obviously backup and restore is something you want to test carefully - nothing worse than assuming that your backups have worked only to find out that they haven't!&nbsp; :wink: </SPAN><BR /><BR /><SPAN>Also please note that HSQLDB is not designed for production use - if your repository contains content that is important enough that it requires backing up, I would strongly encourage you to move to a "real" database.</SPAN></BODY></HTML> Sat, 19 Jan 2008 06:18:49 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-do-backups-while-using-hsql/m-p/123544#M86982 pmonks 2008-01-19T06:18:49Z