Note: in this section, the, and variables that appear below have to be replaced with the values that are contained in the DATABASE_URL setting of your installation.
Sudo tar xzf /var/db/openproject/backup/ -C /var/db/openproject/svn Untar the repositories to their destination: sudo tar xzf /var/db/openproject/backup/ -C /var/db/openproject/git See the configuration guide for more information. To go through all configured wizards steps, use the openproject reconfigure option. If you want to change anything in the configuration, you can also inspect the /etc/openproject folder afterwards and change them accordingly. Untar the configuration files to their destination: sudo tar xzf /var/db/openproject/backup/ -C /etc/openproject Untar the attachments to their destination: sudo tar xzf /var/db/openproject/backup/ -C /var/db/openproject/files rw-r- 1 openproject openproject 112 Nov 19 21:00 įirst, it is a good idea to stop the OpenProject instance: sudo service openproject stop rw-r- 1 openproject openproject 126 Nov 19 21:00 rw-r- 1 openproject openproject 1060 Nov 19 21:00 ĭrwxr-xr-x 6 openproject openproject 4096 Nov 19 21:00. This can be done docker-compose -f /mnt/qnap/downloads/db_dumps/bruno/docker-compose.yml exec db mysqldump -user=root -password=elexisTest -single-transaction -add-drop-table my_elexis >my_new_dump.Restoring an OpenProject backup Package-based installation (DEB/RPM)Īssuming you have a backup of all the OpenProject files at hand (see the Backing up guide), here is how you would restore your OpenProject installation from that backup.Īs a reference, we will assume you have the following dumps on your server, located in /var/db/openproject/backup: sudo ls -al /var/db/openproject/backup/ĭrwxr-xr-x 2 openproject openproject 4096 Nov 19 21:00. Now I am able to connect normally using mysql -host=localhost -user=elexis -password=elexisTest -protocol=tcp -port=1400 my_elexis Start Elexis using the new databaseĮlexis3 -consoleLog -vmargs =elexis =elexisTest =mysql =jdbc:mysql://localhost:1400/my_elexis Dumping the new database MySQL > GRANT ALL PRIVILEGES ON `my_elexis`.* TO MySQL > create user elexis identified by 'elexisTest' Type '\c' to clear the current input statement. Server version: 5.7.19 MySQL Community Server (GPL)Ĭopyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Mysql -host=localhost -user=root -password=elexisTest -protocol=tcp -port=1400 I don't know why the specified mysql user elexis is not created correctly and does not have the permissions to acess via localhost.
Use docker-compose -f /path/to/docker-compose.yml start to start it without logging to the standard output. Once you see in the output the line mysqld: ready for connections. This will take some time, because loading the dump takes some time. Now you should be able to start the database by running docker-compose -f /path/to/docker-compose.yml up path/to/dump:/docker-entrypoint-initdb.d We assume use hier /path/to as base directory any place the following files there
created using mysqldump -single-transaction -add-drop-table -user root elexis >my_elexis_dump.sql. A dump of your existing mySQL-Database, eg.
Docker mysql drop database install#
Install docker for your operating system.You need a working installation of docker and docker-compose The database may be accessed via port 1400 and is called my_elexis. Here we show you howto create a MySQL docker container running MySQL Version 5.7 using the dump my_elexis_dump.sql. Howto create a MySQL Docker container for Elexis 1.4 Start Elexis using the new database.
0 kommentar(er)
