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

    MySQL/Wordpress issue

    IT Discussion
    mysql wordpress
    9
    119
    9.1k
    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.
    • S
      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
      • S
        scottalanmiller
        last edited by

        Are you just running a single WordPress site here?

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

          @scottalanmiller said in MySQL/Wordpress issue:

          Are you just running a single WordPress site here?

          Yes. Single site.

          S 1 Reply Last reply Reply Quote 0
          • J
            jmoore
            last edited by

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

            W 1 Reply Last reply Reply Quote 0
            • S
              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.)

              W 1 Reply Last reply Reply Quote 0
              • W
                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
                • J
                  jmoore
                  last edited by

                  Did you run [service mysql start] from terminal?

                  W 1 Reply Last reply Reply Quote 0
                  • W
                    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.

                    D S 2 Replies Last reply Reply Quote 0
                    • W
                      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
                      • J
                        jmoore
                        last edited by

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

                        W 1 Reply Last reply Reply Quote 0
                        • D
                          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.

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

                            @jmoore restart

                            1 Reply Last reply Reply Quote 0
                            • J
                              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]

                              W 1 Reply Last reply Reply Quote 0
                              • W
                                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.

                                S 1 Reply Last reply Reply Quote 0
                                • W
                                  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
                                  • J
                                    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
                                    • W
                                      WLS-ITGuy
                                      last edited by

                                      I have daily snapshots and full backups.

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

                                        Have you changed any permissions or config files recently?

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

                                          @jmoore said in MySQL/Wordpress issue:

                                          Have you changed any permissions or config files recently?

                                          I had some issues with wordpress updating and had done some permission changes to wordpress files

                                          J S 2 Replies Last reply Reply Quote 0
                                          • J
                                            jmoore @WLS-ITGuy
                                            last edited by

                                            @wls-itguy said in MySQL/Wordpress issue:

                                            I have daily snapshots and full backups.

                                            Well it can be hard to diagnose things at times so in the interest of your time you might consider uninstalling mysql, reinstalling mysql, then importing your database back into mysql. Just consider it for now. Let others chime in for a bit in case someone else gets something to work for you.

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