As some may have noticed. The server had a melt down yesterday, and it has taken me a day to sort it out after a lot of googling about mysql issues.
I finally found the culprit which was corrupted log file that was stopping mysql from running. So as soon as that was removed I was able to restart it finally. Which was a big relief, as I was concerned that I was going lose a lot of the sites data. But thankfully have gotten everything back to normal, and am going to look into some better backup options. As just backing up on the same server isn't good enough, as I need to have a copy elsewhere incase the server is broken like it was, as you can't then run the backups you have if mysql won't run. So if I keep them elsewhere too, then I could just move servers if it's not an easy fix.
Oh the joys of running servers.
isatrader
Fate does not always let you fix the tuition fee. She delivers the educational wallop and presents her own bill - Reminiscences of a Stock Operator.
RE: Stan Weinstein Stage Analysis and Market Breadth
(2019-12-18, 10:35 PM)isatrader Wrote: As some may have noticed. The server had a melt down yesterday, and it has taken me a day to sort it out after a lot of googling about mysql issues.
I finally found the culprit which was corrupted log file that was stopping mysql from running. So as soon as that was removed I was able to restart it finally. Which was a big relief, as I was concerned that I was going lose a lot of the sites data. But thankfully have gotten everything back to normal, and am going to look into some better backup options. As just backing up on the same server isn't good enough, as I need to have a copy elsewhere incase the server is broken like it was, as you can't then run the backups you have if mysql won't run. So if I keep them elsewhere too, then I could just move servers if it's not an easy fix.
Oh the joys of running servers.
Yes. My home setup is complex, in some ways it is robust and in other ways you can have obscure breakages and burn massive amounts of time.
I presume rather than a hosting solution you now have either a physical or virtual server you have root access to? Suggest, in addition to your backups above you also (not instead of, but as well) backup the directory where mysql holds the data. I've been able to move databases by copying this way, most of the time. When it did fail when there were special characters in a table name once. Also, I've done this when I know I'm not accessing the database, or have halted it. Not sure what happens if you try this on a live one - whether you just lose a small amount of data or it breaks completely. Perhaps better asking someone who does it for a living, not someone who runs it for hobby reasons at home! But anyway, if you can easily back up the directory holding the mysql data suggest you do so.