Database Restore

Problems with installing LogicalDOC? No problems, the solution is closer than you think.

Moderator: car031

Locked
Jayhson
Posts: 1
Joined: Thu May 19, 2016 7:27 am

Database Restore

Post by Jayhson » Thu May 19, 2016 7:47 am

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

agaspa
Posts: 521
Joined: Tue Apr 20, 2010 8:24 am

Re: Database Restore

Post by agaspa » Mon May 23, 2016 8:37 am

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.

hamiltonrenata
Posts: 1
Joined: Mon May 11, 2015 2:19 pm

Re: Database Restore

Post by hamiltonrenata » Tue Aug 09, 2016 10:14 am

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.
Last edited by hamiltonrenata on Tue Aug 30, 2016 1:52 pm, edited 1 time in total.

ms_nadhir
Posts: 2
Joined: Mon May 23, 2016 2:09 am

Re: Database Restore

Post by ms_nadhir » Fri Aug 26, 2016 3:32 am

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.

agaspa
Posts: 521
Joined: Tue Apr 20, 2010 8:24 am

Re: Database Restore

Post by agaspa » Tue Aug 30, 2016 10:18 am

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)

ms_nadhir
Posts: 2
Joined: Mon May 23, 2016 2:09 am

Re: Database Restore

Post by ms_nadhir » Thu Sep 01, 2016 1:54 am

Thanks for your assist. I will try to backup and migrate then update to you when done

Locked

Who is online

Users browsing this forum: No registered users and 2 guests