Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

    Recreate kopano database

    Kopano Groupware Core
    2
    20
    1357
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A Former User
      A Former User last edited by

      Hi all,

      I have a problem with the kopano database. Is there a command to recreate the kopano database?

      fbartels 1 Reply Last reply Reply Quote 0
      • fbartels
        fbartels Kopano @Guest last edited by

        Hi @ckruijntjens,

        if you drop the database (or change the server.cfg to a database name that does not yet exist) kopano-server will at startup create the database and the required tables.

        Newer version also support the populate parameter to kopano-dbadm to create the database without the need of a running kopano-server.

        Regards Felix

        Resources:
        https://kopano.com/blog/how-to-get-kopano/
        https://documentation.kopano.io/
        https://kb.kopano.io/

        Support overview:
        https://kopano.com/support/

        A Former User 1 Reply Last reply Reply Quote 0
        • A Former User
          A Former User @fbartels last edited by

          @fbartels

          Thank you fbartels.

          I created a backup with kopano-backup. Is there any wau to restore a mailbox how it was on a specific date?

          fbartels 1 Reply Last reply Reply Quote 0
          • fbartels
            fbartels Kopano @Guest last edited by

            @ckruijntjens said in Recreate kopano database:

            how it was on a specific date

            No, the backup restores always to the state it was last run.

            Regards Felix

            Resources:
            https://kopano.com/blog/how-to-get-kopano/
            https://documentation.kopano.io/
            https://kb.kopano.io/

            Support overview:
            https://kopano.com/support/

            A Former User 2 Replies Last reply Reply Quote 0
            • A Former User
              A Former User @fbartels last edited by

              @fbartels

              there is one thing i dont understand with the backups. I am running incremental backups. i backup every night. Now if i restore from a backup i get all kind of old mail in my restore that i allredeay deleted. (i use the option --deletes yes) if i dont use this option i miss all kind of mail that was in my mailbox last time i created the backup.

              Am i missing something?

              1 Reply Last reply Reply Quote 0
              • A Former User
                A Former User @fbartels last edited by

                @fbartels sorry i dont use differential.

                fbartels 1 Reply Last reply Reply Quote 0
                • fbartels
                  fbartels Kopano @Guest last edited by

                  @ckruijntjens said in Recreate kopano database:

                  i get all kind of old mail in my restore that i allredeay deleted. (i use the option --deletes yes)

                  yes, that is exactly what this option does, it also restores deleted items.

                  Regards Felix

                  Resources:
                  https://kopano.com/blog/how-to-get-kopano/
                  https://documentation.kopano.io/
                  https://kb.kopano.io/

                  Support overview:
                  https://kopano.com/support/

                  A Former User 1 Reply Last reply Reply Quote 0
                  • A Former User
                    A Former User @fbartels last edited by

                    @fbartels

                    i understand. but is there no option to restore the mailbox as it was on the last backup? because if i leave out the --deletes yes. i am missing a lot of mails in my mailbox?

                    fbartels 1 Reply Last reply Reply Quote 0
                    • fbartels
                      fbartels Kopano @Guest last edited by

                      @ckruijntjens said in Recreate kopano database:

                      is there no option to restore the mailbox as it was on the last backup

                      that is what it does when you run kopano-backup --restore user

                      Regards Felix

                      Resources:
                      https://kopano.com/blog/how-to-get-kopano/
                      https://documentation.kopano.io/
                      https://kb.kopano.io/

                      Support overview:
                      https://kopano.com/support/

                      A Former User 1 Reply Last reply Reply Quote 0
                      • A Former User
                        A Former User @fbartels last edited by

                        @fbartels

                        Hi fbartels when i do that i miss a lot of mail? Any idea why?

                        I am making my backup every night with the following cronjob.

                        0 3 * * * /usr/sbin/kopano-backup --l DEBUG --worker-processes 1 --output-dir /opt/mailbackup > /home/backup.log

                        fbartels 1 Reply Last reply Reply Quote 0
                        • fbartels
                          fbartels Kopano @Guest last edited by

                          @ckruijntjens said in Recreate kopano database:

                          when i do that i miss a lot of mail? Any idea why?

                          the logical explanation would be that the mails you are missing have been deleted and therefore are only restored when you pass --deletes yes.

                          Regards Felix

                          Resources:
                          https://kopano.com/blog/how-to-get-kopano/
                          https://documentation.kopano.io/
                          https://kb.kopano.io/

                          Support overview:
                          https://kopano.com/support/

                          A Former User 3 Replies Last reply Reply Quote 0
                          • A Former User
                            A Former User @fbartels last edited by

                            @fbartels

                            Hi fbartels. Is there some sort of policy that mails in backups are auto deleted? If i restore my mailbox i really mis a lot of emails that where in my mailbox for a long time. Even yust before my sql crash?

                            A Former User 1 Reply Last reply Reply Quote 0
                            • A Former User
                              A Former User @fbartels last edited by

                              @fbartels

                              Yust find out something realy bad happend with the backups. i do this:

                              0 3 * * * /usr/sbin/kopano-backup --l DEBUG --worker-processes 1 --output-dir /opt/mailbackup > /home/backup.log

                              This seems not to backuped everything. still missing things.

                              I also do this:

                              mysqldump -p --single-transaction --routines kopano > /opt/mailbackup/fullbackupdatabase.sql

                              After restoring database tables are missing. Am i using the wright commands to backup?

                              fbartels 1 Reply Last reply Reply Quote 0
                              • A Former User
                                A Former User @Guest last edited by

                                @ckruijntjens

                                when the sql file is restored i can not start kopano-server because its missing kopano.version table inside mariadb database. Can i fix this somehow?

                                1 Reply Last reply Reply Quote 0
                                • A Former User
                                  A Former User @fbartels last edited by

                                  @fbartels

                                  I restored the mysql dump however now i have this error when starting

                                  nection to database ‘kopano’ succeeded 2020-01-16T06:48:57.193848: [error ] Can’t update the database: 2020-01-16T06:48:57.193980: [notice ] Waiting for mysql_server_end 2020-01-16T06:48:57.193989: [notice ] Waiting for mysql_library_end 2020-01-16T06:48:57.193993: [=======] Server shutdown complete.

                                  I allredeay did kopano-dbadm k-1216

                                  Any ideas?

                                  1 Reply Last reply Reply Quote 0
                                  • fbartels
                                    fbartels Kopano @Guest last edited by

                                    @ckruijntjens said in Recreate kopano database:

                                    After restoring database tables are missing. Am i using the wright commands to backup?

                                    Yes, that command should normally backup all your database tables

                                    @ckruijntjens said in Recreate kopano database:

                                    when the sql file is restored i can not start kopano-server because its missing kopano.version table inside mariadb database. Can i fix this somehow?

                                    Afair kopano-server should recreate missing tables on its own

                                    @ckruijntjens said in Recreate kopano database:

                                    Can’t update the database

                                    That could be related to the versions table missing.

                                    Something seems to be seriously wrong with your server, when even a mysqldump is not producing complete backups. For me this looks like you need help way beyond what a forum can provide, so if you do not have a subscription yet this may be the moment to get one and then get in contact with out support: https://kopano.com/support-info/#mauticform_wrapper_contactkopanosupport

                                    I have to add though, even they cannot perform micracles.

                                    Regards Felix

                                    Resources:
                                    https://kopano.com/blog/how-to-get-kopano/
                                    https://documentation.kopano.io/
                                    https://kb.kopano.io/

                                    Support overview:
                                    https://kopano.com/support/

                                    A Former User 1 Reply Last reply Reply Quote 0
                                    • A Former User
                                      A Former User @fbartels last edited by

                                      @fbartels

                                      Hi fbartels thank you for your reply. I will start again. I will restore what can be restored. Is there some way to monitor the backup and see if the backup is ok in the future?

                                      I never saw any errors or something. Not with kopano-backup and not with mysqldump

                                      1 Reply Last reply Reply Quote 0
                                      • fbartels
                                        fbartels Kopano last edited by

                                        the thing is, you should have gotten an error when mysql decided to skip the table at backup/restore.

                                        Regards Felix

                                        Resources:
                                        https://kopano.com/blog/how-to-get-kopano/
                                        https://documentation.kopano.io/
                                        https://kb.kopano.io/

                                        Support overview:
                                        https://kopano.com/support/

                                        A Former User 1 Reply Last reply Reply Quote 0
                                        • A Former User
                                          A Former User @fbartels last edited by

                                          @fbartels

                                          hi felix,

                                          i restored my lxc machine to the last export of 2 months ago. The strange thing is that in the last backup changes are progressed that i made (some of them) could it be that kopano-backup and mysqldump scripts crossed each other causing an inconsistend backup?

                                          1 Reply Last reply Reply Quote 0
                                          • fbartels
                                            fbartels Kopano last edited by

                                            no, I would not think so. both operations should only read data and that should really not cause inconsistencies, Overall it sounds like you either have a faulty disk or maybe faulty ram?

                                            Regards Felix

                                            Resources:
                                            https://kopano.com/blog/how-to-get-kopano/
                                            https://documentation.kopano.io/
                                            https://kb.kopano.io/

                                            Support overview:
                                            https://kopano.com/support/

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post