The contents you find here are totally obsolete so do not use this website to obtain a solution for your issues: the indications you get from here will not be accurate and may lead to data loss or other mayor problems

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: 37
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

× Attention! This forum has been dismissed and will be soon removed. The contents you find here are totally obsolete so do not use this website to obtain a solution for your issues: the indications you get from here will not be accurate and may lead to data loss or other mayor problems.