Articles

How to Backup a Database Using mysqldump in MySQL or MariaDB

MySQL and MariaDB allow the mysqldump service to make easier the process of creating a backup of...
Call to undefined function mb_strlen() error via WHM

The function mb_strlen() is not enabled by default in PHP.  So, in order to make it work let’s...
Create MS Access DSNLess connection string

"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\MYDB\TEST.MDB"  If you want to use the native...
Delete MySQL database through command line

Sometimes we need to delete a MySQL database through the command line. Before deleting a database...
Error mysqld_safe - a mysqld process already exists

During this time, your website won't load because it cannot connect to the database. So before I...
Error: “1045 cannot log in to the MYSQL server”

To solve this error you have to follow some simple steps which are given below...1. Check whether...
How To Create Hot Backups of MySQL Databases with Percona XtraBackup?

Percona XtraBackup is a free, complete on the internet back-up solution for all editions of...
How To Secure MySQL Server On Cpanel?

MySQL is among the most common database servers majorly used on Linux the operating systems. It...
How to Backup or Restore MySQL/MariaDB and PostgreSQL Using ‘Automysqlbackup’ and ‘Autopostgresqlbackup’ Tools?

We will store the backups in a network share mounted in the backup directory so that in the event...
How to Disable XML-RPC?

If you ever want to publish or access your blog remotely then you always need XML-RPC. it’s...
How to Import CSV file into database with SQL?

To import a comma separated file or CSV file using the database, you should first create a table...
How to change mySql max_allowed_packet ?

Steps to increase the packet size:In default, you would have max_allowed_packet = 16MB. To...
How to change the database user password – cPanel?

To change the database user password from cPanel: 1. Log into cPanel. 2. Click on “MySQL...
How to check MySQL query caching status?

1. First of all, you have to log in as root using SSH on the server.2. Now, open MySQL prompt and...
How to check MySQL version ?

We assume that you have the log in details for root user and if you don’t have access to root...
How to check and repair a corrupted MySQL database?

Let's see how to check & repair MySQL database table through SSH. Normally we use PhpMyAdmin...
How to clear eximstatus database entries?

This post is about truncating eximstats database. The scenario is considered when the database...
How to create Ms Access Database DSN for Plesk Control Panel?

How to upload the database?Step 1: Login to control panel of Plesk and select File Manager.Step...
How to create a MySQL user and Grant permissions through command line ?

To create MySQL user you should have root access. First of all, you have to log in to MySQL...
How to enable Redis Database Backup in Memory using BGSAVE and SAVE

There is a possibility that redis-server might crash or memory problems and the user can lose the...
How to fix lveinfo database error?

CloudLinux LVE Manager doesn't show anything on statistics tab, lveinfo utility displays errors....
How to fix “Table ‘./eximstats/sends’ is marked as crashed and should be repaired”?

First, you will need to login to shell as the root user. Run the following: mysqlcheck —repair...
How to get MySql.sock file, if it's missing ?

MySql.sock file is mostly available in folder “/mysql/tmp/”. If you mistakenly deleted the...
How to get a backup of "MySQL" database through PhpMyAdmin ?

Here are the steps to take backup of your MySQL database through PHPMyAdmin:1. First login to...
How to optimize MySQL Database?

Server performance is the basic thing behind the stable application. Performance leads to create...
How to recover or recreate MYI file of a Table in MySQL DB?

MySQL relational database management system prior versions to 5.5 were using MyISAM as a default...
How to separate MySQL Slow Log Using "Logrotate" in Ubuntu?

Logrotate is designed to ease administration of systems that generate large numbers of log files....
How to show a list of all users in MySQL?

All commands will be executed inside the MySQL shell as a root user.   To access the MySQL...
List MySQL databases using command line

First, you have to login into the MySQL server through this command line: # mysql -u root -p...
MySQL Error 1064

What is MySQL Error 1064?This is exactly syntax error and appears because of few specific...
MySQL table "is marked as crashed and should be repaired"

1) Login to your cPanel2) Go to the MySQL section.3) Next, to the database's name, you can find a...
MySQL table repair error "Can't create new tempfile"

The solution to repair your crashed table is very simple. And we assume that you have root login:...
MySQL tweaking – best practices and tips for SysAdmin

Need for MySQL tweaking Everyone needs a high-speed, stable and safe environment for our online...
OpenBSD install MariaDB database server

MariaDB is a drop in replacement for Oracle MySQL servers. MariaDB is a multithreaded SQL...
Reset MySQL root password through SSH

You can reset your MySQL root password if you forget that or you are having any issue related to...
SQL Server Service Is Not Starting - Reasons and Fixes

Here is the common error which you would receive when we try to start SQL Services from various...
Setting up DirectAdmin with an SSL certificate

Method 1:   You can switch DirectAdmin to use SSL instead of plain text. -> https instead of...
Steps to manage MySQL Database Backup

You can easily take Backup of Database by using the following Command Line : For Single Database...
Steps to optimize Mysql database through PhpMyAdmin

Overview of optimisation:There are various factors which run the database under the control of...
Tune MySQL to Improve the Performance of CPU

To Improve the Performance do the following:1. Reduce the Workload:The best way to realize how...
Use PHP to make a MySQL Connection

There are various ways to make a MySQL Connection using PHP and each of them is described in the...
What is unknown collation ‘utf8mb4_unicode-520-ci’ and how to solve it?

An error message describes a problem that stops a user or system from completing a task.1273 -...
What to do if MySQL database displays 0 MB size?

If you are getting 0 MB size for MySQL database in your cPanel account. Then you can resolve it...
Why LVE stats are not collected for some accounts, or they are not visible in LVE Manager?

If you transfer one or more users from another server, please make sure that UID_MIN value in...
Fully automated SQL Server Restore Script

Restoring the latest backups of Production databases on a various test servers is one of the...