Swordgeo π
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
Certainly. Lay it on me and Iβll happily respond tomorrow morning
24 replies
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
Gotcha. As far as "important" data, sure, it will be a pain, but I can recover all of it in due time.
I've partially set up the means to do so. If something can be recovered, awesome; if there's nothing that can be done it is what it is.
Thank you for the help; now I don't have to wonder and spin my wheels.
If you could let me know when I can begin rebuilding I'd greatly appreciate that.
24 replies
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
Not as far as I know.
I had just released my site to production, and was encountering a problem of connections timing out naturally after a few minutes.
So I set up a ping to kinda keep it open like so:
setInterval(() => {
connection.query('SELECT 1', (err) => {
if (err) {
console.error('Error pinging database:', err);
} else {
console.log('Pinged database successfully.');
}
});
}, 2.5 * 60 * 1000); // Ping every 2.5 minutes
In hindsight something about this is probably where the stupidity happened.
After a day or two that's when I stopped being able to connect entirely.
24 replies
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
Thank you, I appreciate that.
24 replies
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
24 replies
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
"Unable to connect to localhost"
It seems to not be sure even what the problem could be.
24 replies
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
24 replies
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
Yes sir, just a sec
24 replies
RRailway
β’Created by Swordgeo π on 8/24/2023 in #βο½help
I can no longer connect to my MySQL database, even after restarting the database
90% sure I'd suppose. I'm trying to connect in the same ways using the same saved values that have always worked before this issue. I checked to see that the database should be using the same port as it's always been using, etc.
24 replies