topic Backup script? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/backup-script/m-p/30184#M15481 <HTML><HEAD></HEAD><BODY><SPAN>Hello, i am willing to setup a cronjob to daily backup my alfresco repository.</SPAN><BR /><BR /><SPAN>I think it could be interesting to integrate this shell script with the default install, so that anyone can do the same easily.</SPAN><BR /><BR /><SPAN>It seems (after reading th backup page in the wiki) that just one mysql dump operation is needed, and then a simple file copy operation. All mysql binaries are included in alfresco distribution, so it should be easy.</SPAN><BR /><BR /><SPAN>What cammand line should do the job to :</SPAN><BR /><SPAN>* dump all of the alfresco database </SPAN><BR /><SPAN>* restore from that file to the database</SPAN><BR /><SPAN>?</SPAN><BR /><SPAN>(sorry, i am not very good at command line mysql operations <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> )</SPAN><BR /><BR /><BR /><SPAN>The dir.root mentioned in the wiki is the /alf_data/ directory?</SPAN><BR /><BR /><SPAN>Thank you</SPAN></BODY></HTML> Mon, 12 Jun 2006 10:53:35 GMT unknown-user 2006-06-12T10:53:35Z Backup script? https://connect.hyland.com/t5/alfresco-archive/backup-script/m-p/30184#M15481 Hello, i am willing to setup a cronjob to daily backup my alfresco repository.I think it could be interesting to integrate this shell script with the default install, so that anyone can do the same easily.It seems (after reading th backup page in the wiki) that just one mysql dump operation is neede Mon, 12 Jun 2006 10:53:35 GMT https://connect.hyland.com/t5/alfresco-archive/backup-script/m-p/30184#M15481 unknown-user 2006-06-12T10:53:35Z Re: Backup script? https://connect.hyland.com/t5/alfresco-archive/backup-script/m-p/30185#M15482 <HTML><HEAD></HEAD><BODY><SPAN>does anybody know how to do that? </SPAN><BR /><BR /><SPAN>please <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </SPAN><BR /><BR /><SPAN>backuping and restoring to/from a sql file in the alf_data directory with included binaries?</SPAN></BODY></HTML> Mon, 19 Jun 2006 09:55:10 GMT https://connect.hyland.com/t5/alfresco-archive/backup-script/m-p/30185#M15482 unknown-user 2006-06-19T09:55:10Z Re: Backup script? https://connect.hyland.com/t5/alfresco-archive/backup-script/m-p/30186#M15483 <HTML><HEAD></HEAD><BODY><SPAN>MySQL dump and load can be performed in its simplest form as follows:</SPAN><BR /><BR /><SPAN>dump: mysqldump -u alfresco –password=alfresco alfresco &gt; alfresco.dmp</SPAN><BR /><BR /><SPAN>load: mysql -u root –password=root alfresco &lt;alfresco.dmp</SPAN></BODY></HTML> Mon, 19 Jun 2006 10:06:00 GMT https://connect.hyland.com/t5/alfresco-archive/backup-script/m-p/30186#M15483 davidc 2006-06-19T10:06:00Z