September 2019 - W3Space Blog

Export/import a MySQL database via SSH

When dealing with large databases over 50Mb it is recommended to manage them via SSH. SiteGround customers can find more information on how to connect to and use SSH in our SSH Tutorial. In this article, we will cover exporting and importing a database via SSH. Make sure that you replace the following variables in the… read more »

 1,162 total views,  3 views today

How-to: cPanel to Directadmin migration

To increase it in DA to 16, for example, you can simply run:Code: /usr/local/directadmin/directadmin set max_username_length 16 restart * To make sure your MySQL username/database name is fine, I’d suggest upgrading your MySQL/MariaDB on the server (https://www.directadmin.com/features.php?id=2294), MySQL 5.7+ or MariaDB 10.x is recommended.* I’d suggest trying it with 1 account first, most preferably – the one… read more »

 1,155 total views

Installing an SSL certificate for your hostname using LetsEncrypt in directadmin

cd /usr/local/directadmin/scripts./letsencrypt.sh request_single your.hostname.com 4096which will also install the new cert/key/ca files in all respective global places for apache, dovecot, exim, ftp, and DirectAdmin.NOTE The hostname value, eg: your.hostname.com must match the “servername” value set in the directadmin.conf, or it will not be in hostname mode, but User domain mode instead. You must then turn on SSL in DA and… read more »

 1,281 total views

Automatically setup LetsEncrypt SSL for *all* domains that do not currently have a certificate in directadmin

The new LetsEncrypt feature is a great way to easily secure your website connections at no cost.  If you already have many website that you want to secure all at once, you can use the autoletsencrypt.sh script to do this. Make sure you’ve already enabled LetsEncrypt on the system: Then you can install certificate for all domains:cd… read more »

 1,402 total views,  6 views today

How to enable LetsEncrypt in directadmin

LetsEncrypt is a free SSL tool that lets you install a very basic free SSL Certificate with 1 click.  It supports multiple domains and sub-domains, and will auto-renew automatically before it expires after it’s ~90 day lifespan. To enable this feature in DirectAdmin, ensure you have DirectAdmin 1.50.1 or newer. If you’re running CentOS 6… read more »

 1,287 total views

How to upgrade mariadb or mysql in directadmin

To upgrade  MariaDB using the custombuild script, do the following: cd /usr/local/directadmin/custombuild./build set mariadb 10.3./build set mysql_inst mariadb./build set mysql_backup yes./build update./build mariadb ./build php n Where mariadb can be 5.5, 10.0, 10.1, 10.2 or 10.3 A full raw sql backup will be run prior to the upgrade if you have mysql_backup=yes set.  It goes without saying, always make backups, either… read more »

 1,251 total views

How To Set Or Change A Hostname In CentOS 7

A hostname is simply the name a server goes by on the network. Setting a unique hostname is an excellent way to quickly find and identified different servers on your network. There are three 3 types of hostnames. The static hostname is the most important one, and it’s stored in the /etc/hostname file. This hostname is used among machines to identify… read more »

 763 total views

Sidebar