ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    mysqldump: Got error: 1044

    Scheduled Pinned Locked Moved IT Discussion
    14 Posts 5 Posters 2.4k Views
    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.
    • scottalanmillerS
      scottalanmiller
      last edited by

      The easiest way to do it is to pop the code into Notepad++ and under Edit select the Indent option and it will do it automatically for you. Then you can just paste it here.

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

        @scottalanmiller said:

        The easiest way to do it is to pop the code into Notepad++ and under Edit select the Indent option and it will do it automatically for you. Then you can just paste it here.

        That's a lot of work.. Maybe we can get a GUI option for that.

        steveS 1 Reply Last reply Reply Quote 0
        • steveS
          steve
          last edited by

          There we go. Edited it for you.

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

            @thecreativeone91 said:

            That's a lot of work.. Maybe we can get a GUI option for that.

            Feature requests can be posted directly to the developers over at community.nodebb.org. Posting there directly gets a lot of attention.

            1 Reply Last reply Reply Quote 0
            • T
              technobabble
              last edited by

              Thank you @steve for the rewrite. Thanks to @scottalanmiller for the how to!

              1 Reply Last reply Reply Quote 0
              • T
                technobabble
                last edited by

                @technobabble said:

                Hopefully someone can tell me where I can exclude the "information_schema" database.

                1 Reply Last reply Reply Quote 0
                • T
                  technobabble
                  last edited by

                  Does anyone know how I can edit this script to exclude a backup of the "information_schema" database?

                  1 Reply Last reply Reply Quote 0
                  • T
                    technobabble
                    last edited by technobabble

                    According to the mysql website "do not dump the table code" is:

                    --ignore-table=db_name.tbl_name
                    

                    Does anyone know if I just add that line after the /usr/bin/mysqldump line below?:

                    for i in $DBNAMES; do
                    /usr/bin/mysqldump
                    

                    Interesting...I made a red area in the code area.

                    JaredBuschJ 1 Reply Last reply Reply Quote 0
                    • JaredBuschJ
                      JaredBusch @technobabble
                      last edited by

                      @technobabble said:

                      Interesting...I made a red area in the code area.

                      automagic syntax highlighting. it knows that -- is a comment generally when starting a line of text.

                      1 Reply Last reply Reply Quote 0
                      • JaredBuschJ
                        JaredBusch
                        last edited by

                        Also, your credentials are in the post.

                        T 1 Reply Last reply Reply Quote 0
                        • T
                          technobabble @JaredBusch
                          last edited by

                          @JaredBusch Thanks man..fixed that.

                          Do you know where to add the code snippet?

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