Dev {Tricks}

You are here: Home / Archives for Server and Hosting

by

Import export database | Linux

Import database

mysql -u DB_USERNAME -p DB_NAME < /PATH/OF/DB/softsql.sql

Export database

mysqldump -u DB_USERNAME -p DB_NAME > /PATH/TO/DB/softsql.sql

Dump error

  • Error Access denied need PROCESS privilege [MySQL]
  • mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

Solusion

Add ‘–no-tablespaces‘ option to the command as shown below:

mysqldump -u DB_USERNAME -p DB_NAME --no-tablespaces > /PATH/TO/DB/softsql.sql

 

by

MariaDB Upgrade to the new version | CWP

 

    • Check installed MariaDB version on your server 
      rpm -qa|grep -i maria
    • MariaDB Repository Changes
      Modify repo file to the version you want to upgrade

      vi /etc/yum.repos.d/mariadb.repo
    • Output 
      [mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1
    • Modify 10.2 with the version you want to upgrade
      Example for upgrade to MariaDB 10.5

      [mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1
    • Stop and remove the old version of MariaDB (Databases will not be removed) 
      service mysql stop
service mariadb stop
systemctl disable mariadb
rpm --nodeps -ev MariaDB-server
  • Install the new version of MariaDB 
    yum clean all
yum -y update "MariaDB-*"
yum -y install MariaDB-server
systemctl enable mariadb
service mariadb start
mysql_upgrade
  • Check for the custom configuration 
    diff -Bw /etc/my.cnf.d/server.cnf.rpmsave /etc/my.cnf.d/server.cnf
  • Verify upgraded packages 
    rpm -qa|grep -i maria
  • That’s All

Yum repository list of the available versions
http://yum.mariadb.org/

by

How to Install Zip/Unzip

How to Install Zip/Unzip in Debian/Ubuntu/Mint

apt install zip
apt install unzip

How to Install Zip/Unzip in RedHa/CentOS/Fedora

dnf install zip
dnf install unzip

How to Install Zip/Unzip in Arch/Manjaro Linux

pacman -S zip
pacman -S unzip

How to Install Zip/Unzip in OpenSUSE

zypper install zip
zypper install unzip

 

by

How to change Time Zone in Debian 11 / Debian 10

  • Changing Time Zone in Debian 11 / Debian 10

We can do the change timezone in two ways,

  1. Using /etc/localtime file
  2. Using timedatectl command

1. Using /etc/localtime File

Check current timezone

date

The /etc/localtime is a link to the original timezone file. Check the symbolic link using the following command.

ls -al /etc/localtime

Output

lrwxrwxrwx 1 root root 32 Oct 8 13:58 /etc/localtime -> ../usr/share/zoneinfo/Asia/Dhaka

The /usr/share/zoneinfo/ directory contains all the timezones.

You can check your zone info. For example, America, Chicago, Los_Angeles, Dhaka etc

ls /usr/share/zoneinfo/America/

Now, create a link with the desired timezone file. America/Chicago

ln -sf /usr/share/zoneinfo/America/Chicago /etc/localtime

Verify the timezone using the date command.

date

That’s All.

2. Using timedatectl command

Check current timezone

date

Use the following command to list all time zones.

timedatectl list-timezones

You can filter the output with the city nearer to you.

timedatectl list-timezones | grep -i Los_Angeles

Set the timezone using the following command.

timedatectl set-timezone America/Los_Angeles

Verify the timezone using the date command.

date

That’s All.