Alfresco system data copying and Restoration

 

AlfrescoSystem data copying and Restoration

 Data Copying and Restoration:

AlfrescoUseMySQLStorage Data, which only needs to be used for copying and restoring data.MySQLAnd restore. Description:(The color part indicates the numeric value, and the content in the picture indicates the selected value.):

 

Data copies

UseMysqldumpCopying data(Login requiredMySQLServer)

Run the doscommand in c: \ alfresco \ mysql \ bin \ mysqldump.exe.

Mysqldump -- opt-u root [-PPassword] alfresco> Backup. SQL

For example:Mysqldump -- opt-u root-P0414 kmdb> Backup. SQL

 

If you use the program parameters, you need to add additional data.

Mysqldump -- Opt -- Host =Remote-host-u username [-ppassword] alfresco> Backup. SQL

For example:Mysqldump -- Opt -- Host =3306-u root [-p0414] kmdb> Backup. SQL

 

Data restoration

The exported data is complete.SQLStatement, used for restorationMySQLCustomerProgramIt is easy to import data:

Mysqladmin-u root [-PPassword] Create alfresco

Mysql-u root [-PPassword] <backup. SQL

 

Document Copy and Restoration:

File copy and restore are simpler. You only need to findAlfrescoMemoryRepositoryThe object category is as follows:D: \ alfresco \ alf_data, Set the entireAlf_dataContentsCopyWhen it comes out, the preparation is completed; when it is restored, the deletedAlf_dataContents, and thenCopyPartialAlf_dataThe restore is completed.