MySQLdump: got error :1049 :unknown database - Fix it Now ?
This article covers the best method to fix the MySQL database error, "MySQLdump: got error :1049 :unknown database".
Generally, this error happens while performing cPanel backups and it simply indicates that the database does not exist in MySQL.
How to fix mysqldump unknown database when selecting the database?
In cases where this error occurs when you specify the password on the command line with -p flag and there is a space between -p and password.
For example, if you want to dump the database named wpdb using the user "root" and password "your-password".
Fix this error, by specifying the password with no space after -p switch as shown below:
mysqldump -u root -pyour-password wpdb > wpdb_backup.sql
Install the Acronis BackUp Plugin on cPanel - Step by Step Process ?
This article covers method to install the Acronis BackUp Plugin on cPanel.
To install the Acronis Backup plugin for WHM and cPanel, run the following command:
sh <(curl -L https://download.acronis.com/ci/cpanel/stable/install_acronis_cpanel.sh || wget -O -https://download.acronis.com/ci/cpanel/stable/install_acronis_cpanel.sh)
This command runs the installation script.
How to Install the backup agent ?
To back up the Virtuozzo container, the backup agent must be installed on its host as described in the Installing the backup agent on Virtuozzo host section.
1.Log into WHM UI.
2.Click Plugins> AcronisBackup.
3. Specify the credentials of the account to which the machine should be assigned. Make sure that you specify the credentials of an account created within the customer group (Customer administrator, Unit administrator, or User). Do not specify partner administrator credentials.
4. Follow the installation wizard. During the installation, the software checks if the ports required for communication with the cloud are open.
If some of the ports are closed, the software shows numbers of these ports and the hostnames for which a port should be open.
Open the ports, close the wizard, and restart the installation.
Completing the installation may take several minutes. You can leave the page during this process.
The backup agent can also be installed by using the command line.
To uninstall the Acronis Backup plugin for WHM and cPanel, run the following command:
$ yum remove acronis-backup-cpanel
Removing the extension will also uninstall the backup agent from the cPanel server.
The backup accounts you created and the backed-up data will be left intact.
Exclude Files from Backups in DirectAdmin - How to do it ?
This article covers how to Exclude Files from Backups in DirectAdmin.
User ability to skip paths from their tar.gz backup files in DirectAdmin.
i. New optional file:
/home/username/.backup_exclude_paths
where User can add paths to this file that they wish to have skipped from their backup.
The format of the file must be relative to /home/user and should not include a "/home/user" prefix.
2. New default internal directadmin.conf setting:
allow_backup_exclude_path=1
can be disabled by setting it to 0 and restarting DA.
A sample line in the .backup_exclude_paths would look like:
domains/domain.com/awstats
so that the path:
/home/username/domains/domain.com/awstats
is skipped from the backup.
This will add:
--exclude-from=/home/username/.backup_exclude_paths
Just after the -C /home/username option in the creation of BOTH the home.tar.gz and the user's backup tar.gz.
So using the feature will truly exclude the path, regardless of if it's in /home/user/domains, or /home/user/*.
As you may have noticed, the option uses tar's exclude-file option.
This supports patterns, eg:
*.gz
So you have skip those types of files, regardless of what path they're under.
Install Ajenti Control Panel on Debian 10 / Debian 9 - Step by Step Process ?
This article covers how to install Ajenti Control Panel on Debian system. Basically, Ajenti is a simple tool to manage your websites, Firewall, DNS, Cron, Logs, Files, Mail hosting services and so on.
Install CloudPanel on Ubuntu 20.04 - Step by Step Process ?
This article covers the Installation procedure of CloudPanel on Ubuntu 20.04. Basically, CloudPanel, an open source, PHP-based host control software built for the cloud helps to manage hosted services.
CloudPanel is a server management control panel designed to be fast, easy to use and customizable. This piece of software supports management of Domains, Linux services, Cron jobs, FTP services, System security through IP and Bots blocking, User management, Cloud platforms support, among many others.
Main features of CloudPanel Includes:
1. Free to use and open source
2. Provides powerful intuitive interface for management
3. Designed for high Performance with minimal resource usage
4. It is secure – provision of free SSL/TLS certificates
5. It supports all major clouds – AWS, Digital Ocean, GCP, e.t.c
6. CloudPanel is available in more than ten languages, making it easy to install in any region
7. One-Click Let's Encrypt Certificates
8. NGINX Support
9. Multiple PHP Versions
To fix failed CloudPanel installation:
$ sudo apt -f install
Interworx vs cPanel - Which is Better
This article covers InterWorx and cPanel and gives an idea of how to choose the best control panel for customers. Basically, many factors depends to choose the right panel like InterWorx and cPanel.
InterWorx includes two main sections:
1. NodeWorx (similar to WHM)
2. SiteWorx (the analog of cPanel)
NodeWorx is a system administrator interface to configuring, managing and monitoring your server.
From the NodeWorx amin, you can securely manage multiple SiteWorx accounts.
SiteWorx is a separate control management account and website owner interface that provides access to the tools for managing your websites, email, and databases.
Differences between InterWorx and cPanel:
1. Unlike cPanel, with InterWorx, you can create multiple administrator accounts and provide them with the desired permissions.
This is especially convenient if your clients have web developers or people who need to manage email only, for example.
cPanel has only one administrative account, and no more additional accounts can be created.
2. InterWorx doesn't have complicated licensing options like cPanel.
cPanel recently implemented an account-based pricing model that may have resulted in a substantial price increase.
Whereas InterWorx lets you host multiple accounts on the server without increasing your license cost as it is licensed per server.
3. cPanel supports PostgreSQL, Mailman mailing lists, NodeJS, server-side Java, Ruby on Rails, and the DNSSEC protocol.
InterWorx does not support those things at this time. Also, InterWorx does not support CloudLinux, only Linux and CentOS are supported.
4. InterWorx supports all of the same languages for NodeWorx as for SiteWorx.
In addition, both NodeWorx and SiteWorx share a wide variety of supported themes. WHM only supports US English and one theme for now. cPanel has two themes.
