Recently, I’ve been working with some kind of GIS application. The main purpose is to automate a very cumbersome repetitive task. I have been developing…
Knowledge from writing codes and a bit of managing linux servers.
Codebase Knowledge Posts
Recently, I hit the maximum volume size in my server and needed to expand more. It was fairly easy to expand with AWS console, you…
The Challenge: You have to recover table data and you only have .frm and .ibd file from your mySQL data directory. Copying the directory directly…
Just recently, I’ve been using a 3rd party service name ngrok to allow me to expose my web server to the internet or simply allow…
Do you ever wonder where does your database lives? MySQL is just like any other programs, it runs and listens to specified port, accepts connections,…
Have you been on hair pulling because of this error? SMTP ERROR: Password command failed: 535 Incorrect authentication data We recently encountered this error while…
Have you come up to a situation that you need FTP on your server? Well, its easy. First thing we have to do is install…
Have you encounter the problem when you are hosting on GoDaddy, and your domain is using GoDaddy’s workspaces as its email server? If so, then…
Have you ever encounter failing to start your MySQL server that throws this kind of error:
|
1 |
[ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. |
This occurs when your server suddenly shutsdown or…