Extract content directly from the database?

[sirsean]

Is it possible to extract content directly from the MySQL database? I'm having a great deal of trouble with Alfresco (it won't even start up any more, and isn't writing logs), but the database is still accessible. I need to get the files out of it.

How is the data actually stored, and how can it be extracted?

Thank you,
Sean

[kevinr]

All the files are stored in the filesystem in a location something like:
tomcat\bin\alf_data
or
jboss\bin\alf_data
depending on your installation.

Sorry to hear you are having problems! Can you give us any more information so we can try to help you?

Thanks,

Kevin

[a5sk4s]

I'm using Tomcat on Windows and had to look a while until finally locating the store under C:\WINDOWS\system32\alf_data.

Andreas

[sirsean]

I know the data are stored in alf_data, but they're in *.bin files with long filenames which don't seem to apply to what they actually are. Is there a way to interpret those filenames so I can retrieve the individual files?

What happened was that I ran into the heap space bug in version 1.0, and attempted to upgrade to 1.2. The upgrade did not work, and Alfresco would not even start up. I tried moving to 1.1.2, with the same results. I then tried going back to 1.0, but am having the same problems. Nothing in my setup had changed, but it simply won't start up. And it's not even writing its logs, so I can't figure out where it's going wrong. I'm running on OS X, so there's something of a dearth of documentation that might help.

Thanks,
Sean