In MySQL and MariaDB, the expire_logs_days option specifies the number of days for automatic binary log deletion. Bobcares, as a part of our MySQL Support offers solutions to every query that comes our way. The “expire_logs_days” option in MariaDB The expire_logs_days option in MariaDB specifies the number of days for automatic binary log deletion. Binary logs are used for a variety of tasks, including replication and point-in-time recovery. These logs can waste disk space over time, therefore they must be managed properly. The following steps show the working of the parameter: 1. When this op ..read more

Let us look at how to install the wordpress toolkit on Cpanel with the support of our WordPress support services at Bobcares. Install the WordPress toolkit on Cpanel We can install the WordPress Toolkit plugin using the following methods: The WHM Marketplace Manual installation WHM’s WordPress Toolkit interface (WHM >> Home >> Plugins >> WordPress Toolkit) may be used to confirm WordPress Toolkit installation. If this plugin is activated, cPanel users may also access it using the WordPress Toolkit interface (cPanel >> Home >> Domains >> WordPress Toolkit ..read more

Let us take a closer look at the ERPNext Digitalocean with the support of our Digital ocean-managed services at Bobcares. What is ERPNext and why set it up on Digitalocean? ERPNext is a set of Enterprise Resource Planning (ERP) applications that take use of the power and flexibility of open-source technology. It excels at handling fundamental business activities such as finance, sales, human resources, manufacturing, purchasing, services, and helpdesk requirements, among others. Among the advantages of installing a system such as ERPNext or Digitalocean are: Increased productivity through aut ..read more

Learn how to reset auto increment in MariaDB. Our Server Management Support team is here to help you with your questions and concerns. How to reset auto increment MariaDB The auto-increment feature in MariaDB automatically generates unique values for a specific column each time a new row is inserted into a table. However, in some cases, we may have to reset the auto-increment value for a table in MariaDB. This is where the ALTER TABLE statement comes in handy. Let’s take a look at how to reset the auto-increment value for a table in MariaDB: First, we have to connect to our MariaDB server wit ..read more

Let us learn more on how to migrate zabbix to new server. With the support of our Server management support services at Bobcares we can go through the whole backup setup process. Moving the Zabbix database to a new database server. Former server: Debian Linux 9 with MariaDB 10.1.48 installed. Debian Linux 11 with MariaDB 10.5.12 is the new server (from Debian packaging) The front end of Zabbix (5.0.19 LTS) is running on Apache. Step 1: Dumping the current database # mysqldump --single-transaction zabbix | gzip > /mnt/zbx-dump.sql.gz There is no need to halt Zabbix for this. If the user is ..read more

Are you stuck with the NOKEY Importing GPG key 0xC74CD1D8 error? Our Plesk Support team is here to lend a hand with your queries and issues.   NOKEY Importing GPG key 0xC74CD1D8 – How to resolve Recently, some of our customers have been having trouble with Plesk updates. They come across the following error message in these scenarios:     According to our experts, this error is caused due to the recently updated GPG key by MariaDB as seen here.   Hence, unless we update our RedHat-based OS, we will likely run into the NOKEY Importing GPG key 0xC74CD1D8 error.   Fortun ..read more

Wondering how to configure AWS mariadb columnstore? At Bobcares, with our Server Management Services, we can handle your server issues. How to configure AWS mariadb columnstore? MariaDB ColumnStore can use a Single Node or a Multi-Node system. And it supports using both local storage and EBS storage’s. These are the support configuration options: 1. Firstly, single-Node install with or without EBS Storages 2. Secondly, Multi-Node Install with or without EBS Storages Setup with User Module and Performance Module functionality on the same Instance(s) Setup with User Module and Performance Modul ..read more

Wondering how to Optimize table in mariaDB? Our MySQL Support team is here to lend a hand with your queries and issues. How to Optimize table in mariaDB? Today, let us see the steps followed by our support techs to optimize table Syntax: OPTIMIZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name [, tbl_name] … [WAIT n | NOWAIT] OPTIMIZE TABLE has two main functions. First and foremost, it can either used to defragment tables, or to update the InnoDB fulltext index. Defragmenting OPTIMIZE TABLE works for InnoDB , Aria, MyISAM and ARCHIVE tables. And should use if you have delete a large part of a tab ..read more

Let’s have a look at the Auto Increment in MariaDB. At Bobcares, with our Server Management Services, we can handle your server issues. Auto Increment In MariaDB This feature provides new rows with a distinct identity. When we insert a new record into the table and the auto-increment field is NULL or DEFAULT, the value is automatically incremented. It is also applicable to 0. If we enable the NO_AUTO_VALUE_ON_ZERO SQL_MODE, then it will not get applied to 0. By default, the value for the attribute starts from 1.   There can only be one column for this attribute in each table. It must be s ..read more

let us take a closer look at how to set up and set up the Remote MySQL CyberPanel. With the support of our Server support services at Bobcares, we can give you a step by step guidance on the configurations. 1. Setting up a remote MariaDB server for CyberPanel 1.1 Using Remotely-hosted database service Just consider that we are using Amazon RDS, Google Cloud SQL, or Azure SQL. So in this case, we have to ensure the SQL user has the right to create new databases. We must ensure that we have hostName, Port, username, password, and Schema Table Name. 1.2 Setting up remote MariaDB for CyberPa ..read more