| |

How can I BACKUP a MySQL database from the command line?

Performing a MySQL Database Dump From your SSH command prompt type … mysqldump -u {username} -p {password} {databasename} > {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql} – the file to…

| |

How can I RESTORE a MySQL database from the command line?

Importing a MySQLDUMP From your SSH command prompt type … mysqladmin -u {username} -p {password} create {databasename} mysql -u {username} -p {password} < {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql}…

|

How To Change Style for File Upload in Contact Form7

Here is the code for How To Change Style for File Upload in Contact Form7 , .your-file { color: transparent; } .your-file::-webkit-file-upload-button { visibility: hidden; } .your-file::before { content: ‘Seleziona un file’; color: white; display: inline-block; background: #ff9800; border: 2px solid #e68d09; border-radius: 3px; padding: 5px 8px; outline: none; white-space: nowrap; -webkit-user-select: none; cursor: pointer;…

Send Emails From Your Web Server With the PHP mail() Function and PHPMailer

Most businesses choose to create a professional email account to boost their credibility and build customer trust. To accomplish this, you just need to buy a domain and set up your business email on an email client or a server. If you build your website or web application with the PHP programming language, you can…

Install Linux Centos 7, Nginx, MySQL, Postgres, PHP 8.0

Update LANG Edit environtment vi /etc/environment add these lines… LANG=en_US.utf-8 LC_ALL=en_US.utf-8 Update and upgrade Core yum -y update yum -y upgrade Install NGINX yum install epel-release yum install nginx Start NGINX and Enable Service systemctl start nginx systemctl enable nginx Install PHP 8.0 Enable Remi Repo yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm Check yum –disablerepo=”*” –enablerepo=”remi-safe” list php[7-9][0-9].x86_64…

How to configure the passive ports range for ProFTPd on a Plesk server behind a firewall

Question How to configure the passive ports range for ProFTPd on a server behind a firewall? Answer Note: When configuring the passive port range, a selected port range must be in the non-privileged range (e.g., greater than or equal to 1024). It is strongly recommended that the chosen range should be large enough to handle…