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

    MySQL/Wordpress issue

    Scheduled Pinned Locked Moved IT Discussion
    mysqlwordpress
    119 Posts 9 Posters 9.3k 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

      Okay, let's get this one...

      cat /var/log/mysql/error.log
      
      WLS-ITGuyW 1 Reply Last reply Reply Quote 0
      • scottalanmillerS
        scottalanmiller
        last edited by

        For those wondering, I just jumped onto a Debian machine to see where the files are 🙂

        1 Reply Last reply Reply Quote 0
        • WLS-ITGuyW
          WLS-ITGuy @scottalanmiller
          last edited by

          @scottalanmiller said in MySQL/Wordpress issue:

          Okay, let's get this one...

          cat /var/log/mysql/error.log
          

          root@www:~# cat /var/log/mysql/error.log
          cat: /var/log/mysql/error.log: No such file or directory

          This server is FUBAR'd

          scottalanmillerS 1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller @WLS-ITGuy
            last edited by

            @wls-itguy said in MySQL/Wordpress issue:

            @scottalanmiller said in MySQL/Wordpress issue:

            Okay, let's get this one...

            cat /var/log/mysql/error.log
            

            root@www:~# cat /var/log/mysql/error.log
            cat: /var/log/mysql/error.log: No such file or directory

            This server is FUBAR'd

            It's old, too. Debian 9 is current, and those releases are very far apart.

            1 Reply Last reply Reply Quote 0
            • scottalanmillerS
              scottalanmiller
              last edited by

              Are you just running a single WordPress site here?

              WLS-ITGuyW 1 Reply Last reply Reply Quote 0
              • WLS-ITGuyW
                WLS-ITGuy @scottalanmiller
                last edited by

                @scottalanmiller said in MySQL/Wordpress issue:

                Are you just running a single WordPress site here?

                Yes. Single site.

                scottalanmillerS 1 Reply Last reply Reply Quote 0
                • jmooreJ
                  jmoore
                  last edited by

                  That is indeed strange. When you did a ps aux was there more than 1 mysql process or just 1?

                  WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                  • scottalanmillerS
                    scottalanmiller @WLS-ITGuy
                    last edited by

                    @wls-itguy said in MySQL/Wordpress issue:

                    @scottalanmiller said in MySQL/Wordpress issue:

                    Are you just running a single WordPress site here?

                    Yes. Single site.

                    Given that the site is now down... is there a good reason that you are running a WP site on your own instead of through a server (asks the guy who runs a service for that.)

                    WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                    • WLS-ITGuyW
                      WLS-ITGuy @jmoore
                      last edited by

                      @jmoore said in MySQL/Wordpress issue:

                      That is indeed strange. When you did a ps aux was there more than 1 mysql process or just 1?

                      Just the one but I also had to run the restart service command before it would display any info.

                      1 Reply Last reply Reply Quote 0
                      • jmooreJ
                        jmoore
                        last edited by

                        Did you run [service mysql start] from terminal?

                        WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                        • WLS-ITGuyW
                          WLS-ITGuy @scottalanmiller
                          last edited by

                          @scottalanmiller said in MySQL/Wordpress issue:

                          @wls-itguy said in MySQL/Wordpress issue:

                          @scottalanmiller said in MySQL/Wordpress issue:

                          Are you just running a single WordPress site here?

                          Yes. Single site.

                          Given that the site is now down... is there a good reason that you are running a WP site on your own instead of through a server (asks the guy who runs a service for that.)

                          It has been 2+ years since it has been set up this way. Wasn't broken, why fix it.

                          DustinB3403D scottalanmillerS 2 Replies Last reply Reply Quote 0
                          • WLS-ITGuyW
                            WLS-ITGuy @jmoore
                            last edited by

                            @jmoore said in MySQL/Wordpress issue:

                            Did you run [service mysql start] from terminal?

                            everything has been from CLI terminal

                            1 Reply Last reply Reply Quote 0
                            • jmooreJ
                              jmoore
                              last edited by

                              To be more clear, did you use the start or restart command?

                              WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                              • DustinB3403D
                                DustinB3403 @WLS-ITGuy
                                last edited by

                                @wls-itguy said in MySQL/Wordpress issue:

                                @scottalanmiller said in MySQL/Wordpress issue:

                                @wls-itguy said in MySQL/Wordpress issue:

                                @scottalanmiller said in MySQL/Wordpress issue:

                                Are you just running a single WordPress site here?

                                Yes. Single site.

                                Given that the site is now down... is there a good reason that you are running a WP site on your own instead of through a server (asks the guy who runs a service for that.)

                                It has been 2+ years since it has been set up this way. Wasn't broken, why fix it.

                                Wrong. . . . .

                                You patch and update to ensure things remain functional.

                                WLS-ITGuyW 1 Reply Last reply Reply Quote 1
                                • WLS-ITGuyW
                                  WLS-ITGuy @jmoore
                                  last edited by

                                  @jmoore restart

                                  1 Reply Last reply Reply Quote 0
                                  • jmooreJ
                                    jmoore
                                    last edited by

                                    In most cases it should not matter but in a few I think it does. run the same command but use [start]. So:
                                    [service mysql start]

                                    WLS-ITGuyW 1 Reply Last reply Reply Quote 0
                                    • WLS-ITGuyW
                                      WLS-ITGuy @DustinB3403
                                      last edited by

                                      @dustinb3403 said in MySQL/Wordpress issue:

                                      @wls-itguy said in MySQL/Wordpress issue:

                                      @scottalanmiller said in MySQL/Wordpress issue:

                                      @wls-itguy said in MySQL/Wordpress issue:

                                      @scottalanmiller said in MySQL/Wordpress issue:

                                      Are you just running a single WordPress site here?

                                      Yes. Single site.

                                      Given that the site is now down... is there a good reason that you are running a WP site on your own instead of through a server (asks the guy who runs a service for that.)

                                      It has been 2+ years since it has been set up this way. Wasn't broken, why fix it.

                                      Wrong. . . . .

                                      You patch and update to ensure things remain functional.

                                      Not what I was asked. It has been patched to the version I have. Just not upgraded to Debian 9.

                                      scottalanmillerS 1 Reply Last reply Reply Quote 0
                                      • WLS-ITGuyW
                                        WLS-ITGuy @jmoore
                                        last edited by

                                        @jmoore

                                        @jmoore said in MySQL/Wordpress issue:

                                        In most cases it should not matter but in a few I think it does. run the same command but use [start]. So:
                                        [service mysql start]

                                        That brought the page up and then it crashed midway through the load.

                                        1 Reply Last reply Reply Quote 0
                                        • jmooreJ
                                          jmoore
                                          last edited by

                                          Wow, tough problem. Let me think about it some more. Have you taken any backups recently in case you have to reinstall?

                                          1 Reply Last reply Reply Quote 0
                                          • WLS-ITGuyW
                                            WLS-ITGuy
                                            last edited by

                                            I have daily snapshots and full backups.

                                            jmooreJ 1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 5
                                            • 6
                                            • 4 / 6
                                            • First post
                                              Last post