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
Database Restore
Moderator: car031
Post
Re: Database Restore
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.
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.
Post
Re: Database Restore
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.
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.
Post
Re: Database Restore
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.
Post
Re: Database Restore
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)
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)
Post
Re: Database Restore
Thanks for your assist. I will try to backup and migrate then update to you when done
Who is online
Users browsing this forum: No registered users and 38 guests