Login to your server root
Them run
sudo crontab -e
Select an editor.
Set the job
# m h dom mon dow command
0 4 * * * /sbin/shutdown -r +5
m=minute
h=hour
dom=day of month
mon=month
dow=day of week
by dev
Login to your server root
Them run
sudo crontab -e
Select an editor.
Set the job
# m h dom mon dow command
0 4 * * * /sbin/shutdown -r +5
m=minute
h=hour
dom=day of month
mon=month
dow=day of week
by dev
This can be done using the cloud-utils package:
For Debian and Ubuntu
apt install cloud-utils -y
For CentOS
yum install cloud-utils -y
Now the cloud-utils are installed, we need to know the name of the existing partition. use the following command to search for a partition mounted to “/”:
mount | grep ' / '
Example output:
/dev/sda3 on / type ext4 (rw,noatime,data=ordered)
Remember the first part (“/dev/sda3” in the example above). To expand the partition, use the following commands:
growpart /dev/sda 3
resize2fs /dev/sda3
And that’s all it takes to expand your existing partition on Debian and Ubuntu and CentOS.
by dev
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
innodb_strict_mode = 0
by dev
How to change the SSH port
vi /etc/ssh/sshd_config
port 1234
/scripts/restartsrv_sshd
ssh USER@HOSTNAME -p1234
by dev
Access MariaDB Server
mysql -u root -p
Create new database
CREATE DATABASE bdhostidb;
Check whether the database created
SHOW DATABASES;
GRANT ALL PRIVILEGES ON 'sqI_bdhositit_co'.* TO 'sqI_bdhositit_co'@localhost;