Home » Archive

Articles tagged with: mysql

Tutorial, Windows »

[15 Oct 2022 | No Comment | ]

Previously I have created bash script to backup MySQL database using bash script Linux. New incident happen in the Windows server which is where the normal backup cannot be used, so I have to plan a second backup for MySQL database using batch file.
This script is useful if you have many databases in the server and automation can give a …

Tutorial »

[17 Aug 2021 | No Comment | ]

I wrote the simple script loop for cpanel backup with –skiphomedir option. This is useful for my own note.
The script is very simple. It just does loop cpanel backup with –skiphomedir option. It is very useful to back up cpanel account configuration with MySQL databases. If you want to just back up databases, head over to this link here.

#!/bin/bash
# Shell …

Articles »

[5 Sep 2020 | 2 Comments | ]

MySQL cluster topology
MySQL cluster is the type of database technology that using a cluster of MySQL server to achieved high availability and high throughput but still maintaining a very low latency. MySQL cluster using different database engine which is NDBCLUSTER.
In order to deploy MySQL cluster we test using 5 servers with 3 types of node. The management node, the Data …

Cpanel »

[23 Oct 2019 | No Comment | ]
Restore database from *.frm for corrupted database

Recently on of my client have problem with the database corruption in Cpanel. The website trowing error related with database. We check our daily MySQL backup and found there is no data in the client MySQL database. To make thing worst our weekly and monthly backup also doesn’t have the database. According to client the last access to the website is in March.

Linux tips »

[14 Mar 2019 | No Comment | ]
Silly me

One of the server have problem with MySQL. The MySQL table cannot edit at all. Restart the MySQL does not resolve the issue.

It turn out that the problem come from tmp folder.

So stop the MySQL first.

Uncategorized »

[27 Feb 2008 | No Comment | ]

Introduces Immediate Worldwide Availability of Enterprise Services and Complete Open Source Portfolio of MySQL Database Products
SANTA CLARA, CA February 26, 2008 Sun Microsystems, Inc. (NASDAQ: JAVA) today announced it has completed the acquisition of MySQL AB, developer of the world’s most popular open source database, for approximately $1 billion in total consideration. Sun also unveiled the immediate availability …