Dev {Tricks}

You are here: Home / Archives for Server and Hosting / Providers / HostGator

by

Migrate aaPanel to New Server using One-Click Migration Tools

  • How to migrate aaPanel account(s) from server A to server B
  • aaPanel settings migration.
  • Cloning aapanel accounts
  • Moving from old error aapanel to new aapanel server
  • How To Migrate Data On aaPanel With 3 Steps
  • How Migrate aaPanel using One-Click Migration API version 3.0
  • ERROR After Migration to AAPANEL

Follow the following steps to migrate aaPanel account(s) easily.

On new Server:

  1. Install aaPanel
  2. Set server configuration same as old server
  3. Update aaPanel to latest version
  4. Click API (Panel Setting) and allow API
  5. Reset API to get new api key and enter whitelist IP (ip address of old server)

On old server:

  1. Update aaPanel to latest version
  2. Install “One-Click Migration”
  3. Open “One-Click Migration” and enter required data
    1. Target panel Addr: Panel address. For example, https://103.81.224.71:7800
    2. Target panel API: API from new server
    3. Select website(s) and database(s)
  4. Just follow the steps and choose which website you want to migrate, then wait for the process, then you’re done

 

 

 

 

by

How to Install cPanel/WHM on Ubuntu 20.04

  • How to Install cPanel/WHM on Ubuntu 20.04
  • How to Install cPanel/WHM on Ubuntu 20.04
  • System Requirements for Ubuntu | cPanel & WHM
  • How to install WHM & CPanel on Ubuntu 20.04 LTS Linux

Step 1

Login as root user to SSH of freshly installed Ubuntu 20.04

Step 2

Disable firewall, while installing cpanel & whm on linux ubuntu system

iptables-save > ~/firewall.rules
systemctl stop firewalld.service
systemctl disable firewalld.service

Step 3

Update Ubuntu System Packages

apt update
apt upgrade

Step 5

Set your hostname for example my.hostname.com

set hostname my.hostname.com
edit hostname

vi /etc/hosts
vi /etc/hostname

Reboot the server.

Step 6

Create a shell session of Linux Screen utility. It helps to remain active even after the network disruption.

screen

If the screen is not installed, install it.

apt install screen

Step 7 – Install Cpanel/WHM

cd /home && curl -o latest -L https://securedownloads.cpanel.net/latest && sh latest

Step 5 – Login to WHM Web interface

https://SERVER_IP:2087

Use your root login credentials.

That’s All!

by

MySQL: Error Code: 1118

  • #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • Change limit for “Mysql Row size too large”
  • Row size too large 8126 Changing some columns
  • 1118 Row size too large

The error was: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

  • Solution
  • Login to phpMyAdmin with root previllege
  • Go to Variables
  • Then edit Innodb Strict Mode as follows 
    innodb_strict_mode = 0