Instruction for backup

LogicalDOC has many interesting features, but requires some configuration process to show its full potential.

Moderator: car031

Nat_Kantanon
Posts: 4
Joined: Mon Mar 19, 2018 6:04 am

Instruction for backup

Tue Mar 20, 2018 3:54 am

Hi
I am running Logicaldoc on Windows 2008 server. It is running without any problem. Today, I want to test backup (from local server) with Logicaldoc Backup v1.4. Is there any instruction on how to do it step-by-step on Windows?

By guessing: I have modified "context.properties" but it cannot run.

Code: Select all

# Where LogicalDOC is installed
logicaldoc.home=F:\Logicaldoc

# Database connection parameters
db.username=logical_user
db.password=My_password
db.host=localhost
db.port=3306
db.name=logicaldoc

# Folder that will receive the backup
backup.targetdir=F:\backup

backup.remotelocaldir=remotelocal

# The stores to process when backing up the documents
backup.stores=1,2,3,4,5,6,7,8,9

# If you want to backup the plugins dir
backup.pluginsdir=true

# What template to use when backing up the plugins dir
backup.pluginsdir.template=incremental

# Data in a single transaction (KB)
backup.pluginsdir.transactionsize=1000

# The medium type: zip or directory
backup.pluginsdir.medium=zip
backup.pluginsdir.medium.ziplevel=4
backup.pluginsdir.medium.compress=true

# If you want to backup the users dir
backup.usersdir=true

# What template to use when backing up the users dir
backup.usersdir.template=incremental

# Data in a single transaction (KB)
backup.usersdir.transactionsize=1000

# The medium type: zip or directory
backup.usersdir.medium=zip
backup.usersdir.medium.ziplevel=4
backup.usersdir.medium.compress=true

# If you want to backup the documents
backup.documents=true

# What template to use when backing up the documents
backup.documents.template=incremental-transactions

# Data in a single transaction (KB)
backup.documents.transactionsize=1000

# The medium type: zip or directory
backup.documents.medium=directory
backup.documents.medium.ziplevel=4
backup.documents.medium.compress=true

# If you want to backup the configurations
backup.conf=true

# What template to use when backing up the configurations
backup.conf.template=incremental

# Data in a single transaction (KB)
backup.conf.transactionsize=1000

# The medium type: zip or directory
backup.conf.medium=zip
backup.conf.medium.ziplevel=4
backup.conf.medium.compress=true

# If you want to backup the database
backup.database=true

# What template to use when backing up the database
backup.database.template=incremental

# Data in a single transaction (KB)
backup.database.transactionsize=1000

# The medium type: zip or directory
backup.database.medium=zip
backup.database.medium.ziplevel=4
backup.database.medium.compress=true

# If you want to backup full-text indexes, it is not mandatory
backup.indexes=true

# What template to use when backing up the indexes
backup.indexes.template=image

# Data in a single transaction (KB)
backup.indexes.transactionsize=1000

# The medium type: zip or directory
backup.indexes.medium=zip
backup.indexes.medium.ziplevel=4
backup.indexes.medium.compress=true

# If the backup must generate config files for the backup targets
backup.buildtargets=true

# Type of backup: fs=File System, ftp=File Transfer Protocol, sftp=Secure FTP 
backup.type=fs

backup.ftp.host=
backup.ftp.port=21
backup.ftp.username=
backup.ftp.password=
backup.ftp.passive=true

# The folder that will receive the dump of the database
backup.db.dir=dump

# The command to use for backing up the database
backup.db.command="c:\Program Files\MariaDB 10.2\bin\mysqldump.exe"
backup.db.arguments=-h ${db.host} -P ${db.port} -u ${db.username} -p${db.password} ${db.name} 
backup.db.ouptut=${backup.db.dir}/database.sql

# If you want to restore the configuration files
restore.conf=true

# If you want to restore the plugins dir
restore.pluginsdir=true

# If you want to restore the users dir
restore.usersdir=true

# If you want to restore the indexes
restore.indexes=true

# If you want to restore the documents
restore.documents=true

# If you want to restore the database
restore.database=true

# The command to use for restoring up the database
restore.db.command="c:\Program Files\MariaDB 10.2\bin\mysql.exe"
restore.db.arguments=-h ${db.host} -P ${db.port} -u ${db.username} -p${db.password} ${db.name}
restore.db.input=${backup.db.dir}/rcv/database.sql

# Connection to a mail server to send reports
smtp.enabled=false
smtp.host=localhost
smtp.username=
smtp.password=
smtp.port=25
smtp.sender=support@acme.com
smtp.recipient=
smtp.ssl=false

Here is the error output.

Code: Select all

    [touch] Creating f:\Logicaldoc_backup\backup.lock

build-targets:
     [echo] Build database target
   [delete] Deleting directory f:\Logicaldoc_backup\dump
    [mkdir] Created dir: f:\Logicaldoc_backup\dump
     [copy] Copying 1 file to f:\Logicaldoc_backup
     [echo] Build conf target
     [copy] Copying 1 file to f:\Logicaldoc_backup
     [echo] Build plugins dir target
     [copy] Copying 1 file to f:\Logicaldoc_backup
     [echo] Build users dir target
     [copy] Copying 1 file to f:\Logicaldoc_backup
     [echo] Build document target/s
     [echo] Checking up store 1
     [echo] Store 1 not defined
     [echo] Checking up store 2
     [echo] Store 2 not defined
     [echo] Checking up store 3
     [echo] Store 3 not defined
     [echo] Checking up store 4
     [echo] Store 4 not defined
     [echo] Checking up store 5
     [echo] Store 5 not defined
     [echo] Checking up store 6
     [echo] Store 6 not defined
     [echo] Checking up store 7
     [echo] Store 7 not defined
     [echo] Checking up store 8
     [echo] Store 8 not defined
     [echo] Checking up store 9
     [echo] Store 9 not defined
     [echo] Build index target
     [copy] Copying 1 file to f:\Logicaldoc_backup
     [move] Moving 5 files to f:\Logicaldoc_backup\conf

backup-db:
     [echo] Database backup

dump-db:
     [echo] Database backup - dumping
   [delete] Deleting directory f:\Logicaldoc_backup\dump
    [mkdir] Created dir: f:\Logicaldoc_backup\dump
     [echo] Error dumping the database: Execute failed: java.io.IOException: Cannot run program ""c:Program FilesMariaDB 10.2binmysqldump.exe"": CreateProcess error=2, The system cannot find the file specified
     [echo] Backup exited in error: The following error occurred while executing this line:
f:\Logicaldoc_backup\build.xml:353: The following error occurred while executing this line:
f:\Logicaldoc_backup\build.xml:338: Execute failed: java.io.IOException: Cannot run program ""c:Program FilesMariaDB 10.2binmysqldump.exe"": CreateProcess error=2, The system cannot find the file specified
   [delete] Deleting: f:\Logicaldoc_backup\backup.lock

Thank you for your help.

Regards
Nat
admin
Site Admin
Posts: 23
Joined: Mon Apr 19, 2010 2:20 pm

Re: Instruction for backup

Wed Apr 04, 2018 10:33 am

Hi Nat,
your problem is due to an error in the configuration of the path for the mysqldump command
# The command to use for backing up the database
backup.db.command="c:\Program Files\MariaDB 10.2\bin\mysqldump.exe"
backup.db.arguments=-h ${db.host} -P ${db.port} -u ${db.username} -p${db.password} ${db.name}
backup.db.ouptut=${backup.db.dir}/database.sql
Should be

Code: Select all

backup.db.command=c:\\Program Files\\MariaDB 10.2\\bin\\mysqldump.exe
Or since you're on Windows you can add the bin directory of MariaDB to the global PATH environment variable and just leave

Code: Select all

backup.db.command=mysqldump.exe

Return to “Configuration”

Who is online

Users browsing this forum: No registered users and 2 guests