nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Howto Backup Alfresco with HSQLDB ?

peter_neu

Hello,

how do I back up alfresco with the HSQLDB and what is the procedure to import the data back in if the system crashes?

cheers,
Pete

Find more posts tagged with

Comments

peter_neu

hello,

is there no way to back up the db? Can somebody please help?

derek

Use and get familiar with the MySQL database.
Also, you can use the full repository export and bootstrap import to backup and restore in a database-independent way.
http://wiki.alfresco.com/wiki/Export_and_Import

bsawler

Hi,

The contractor is going to upgrade my server this weekend and will need to backup and restore my Alfresco. I have installed 2.0 with the HSQLDB. I have not read the wiki article yet but if you have any input from your experience with the backup (pointers, tips, what to avoid etc.) would be great.

Thanks,
Bradley

derek

Hi,

You don't say which version you are running (1.4, 2.0, Open, Enterprise) and it is relevant. Post the line from the logs that gives these details as there have been bug fixes in various stages of release.

If you're an enterprise customer then you'll probably want to wait for the 1.4.3 release before doing the migration. In particular, large data sets during full repo export and import and a workaround for a data flush issue during large transactions are going into the 1.4.3, which will be released for Enterprise customers soon.

If you're not an Enterprise customer, then you'll have to wait a bit longer before the bug fixes are available. If your data size is not too large, then you'll probably be fine, either way. Give your system loads of memory and apply the workaround for bug 1280.

Regards

bsawler

Hi Derek,

I am running Community

Installed Version   2.0.0 (build-185)‍

and took some sizes from the properties which I'm not to sure what they are:

heap.free   62.453MB (65487272 bytes)
heap.maxsize   506.313MB (530907136 bytes)
heap.size   126.750MB (132907008 bytes)‍‍‍

I have only had Alfresco running for about a month, so I do not think it is too big (I hope) and I'll get the IT staff to do some export/imports on a developers machine before he does it to the server.

Thanks,
Bradley

derek

Just apply the bug workaround, give the machine a bit more memory (if required) and it should work.

Regards