Page 1 of 1

Database Restore

Posted: Thu May 19, 2016 7:47 am
by Jayhson
Hi Im Jay newbie here, i want to know how we can restore the database, accidentally remove, and also does the logicaldoc has an archive in database?
second thing can we install also phpmyadmin inside logicaldoc
Thanks

Re: Database Restore

Posted: Mon May 23, 2016 8:37 am
by agaspa
Hi Jayhson,
LogicalDOC needs an RDBMS in order to work,
but you can choose between an embedded Java Database (HSQLDB) or a traditional database like MySQL, PostgreSQL, Oracle or MS SQL Server.
(We suggest MySQL 5.6)
So you can easily backup and restore the database schema using the command utilities provided by MySQL: mysqldump and mysql (to import data)
Note: only metadata and security information are recorded on the DB, the document files are stored on the filesystem, so you will need also to backup the filesystem directory that contains the files
Regarding phpmyadmin, of course you can install it, to inspect the schema of LogicalDOC and query the data, but you can't install it in LogicalDOC, because LD is a Java web-application, while phpMyAdmin is a PHP application. You will need to install also Apache and PHP in order to run it.

Re: Database Restore

Posted: Tue Aug 09, 2016 10:14 am
by hamiltonrenata
Hi Jay,

You may also want to have a look at HeidiSQL (http://www.heidisql.com) as a tool to examine the db and to also perform db dumps. Really easy to use.

Re: Database Restore

Posted: Fri Aug 26, 2016 3:32 am
by ms_nadhir
Can you help me for this matter, I want to migrate LogicalDoc community from 32bit server to 64bit server ( Windows). Usually, I need to install new fresh logicaldoc Community for 64bit . The question is how can I move all the existing database and file into new LogicalDoc Community ? FYI I use MYSQL5.7 for the database. Kindly please assist.

Re: Database Restore

Posted: Tue Aug 30, 2016 10:18 am
by agaspa
Hi ms_nadhir,
basically you need to copy 3 things:
1) configuration file settings
(file in conf/context.properties)
2) documents
(directory repository/docs)
3) database
(make a backup and restore of logicaldoc DB schema from MySQL using the commmands: mysqldump, mysql)

Note: You must install a LogicalDOC of the same version that runs in the old server, using the same installation path.

Once installation is complete test that everything works, then turn off LogicalDOC, replace the configuration file, copy the documents and perform the restore of the database.
And that's all.

Note: possibly you could copy and restore the search index (it is in folder repository/index)

Re: Database Restore

Posted: Thu Sep 01, 2016 1:54 am
by ms_nadhir
Thanks for your assist. I will try to backup and migrate then update to you when done