Recovering alf_data in case db is lost???

[furtado]

We just completed a pilot of alfresco and are ready to go production with it. But the main sticking question I get is, How will you recover the repository if the database is lost???

Is there any way of converting or recovering the documents from the bin files or any documents discussing disaster recovery situations???

[kevinr]

You can recover the indexes, but not the database if you lose it. Obviously the issue is the same with any system - Back up your database machine reguarly.

The document bin files contain the content, but you need the database to work out what the GUID in the filenames means.

Full repo export is being added for 1.3.

Thanks,

Kevin

[ganesh]

Hi

I have got backup from another machine, iam doing this as testing process and i deleted my alfresco database in my machine. I got that backup using Mysql administrator after that i have seen alfresco database created in my machine and all the data remained same before the backup was taken. So i started alf_start. Then i have given admin/admin to login but it is showing username/password is wrong. How to get the correct backup and recovery.please help me
Thanks in advance!

[derek]

Hi,

Did you configure your server to point to a permanent (non-relative) alf_data location?  The default is ./alf_data, which is clearly not a production-standard setting.
Do you have the alf_data folder or was that also "lost"?

Typically, the login issue is caused by the server starting up, finding a populated database, but not finding the Lucene indexes.  These need to be recreated if they were lost before the system can be used.  Our Enterprise version contains components to rebuild the indexes.  Otherwise make sure that you back the alf_data folder up as well.  http://wiki.alfresco.com/wiki/Backup_and_Restore.

Regards