mysql

A Cool Script To Backup Your MySQL / MariaDB Databases Using FTP

In this script an automatic FTP backup will pickup up your sql.tar.gz and upload the file to a remote FTP server running CentOS. So, you may wonder how all this works and how to automate entire procedure to be able to upload file /tmp/backup/sql.tar.gz? In the most simple scenario you can use a standard FTP client to transfer the backup file on the remote server.  Here is a quick script to upload file: #!/bin/sh USERNAME=”your-ftp-user-name” PASSWORD=”your-ftp-password” SERVER=”your-ftp.server.com” # local directory to pickup *.tar.gz file FILE=”/tmp/backup” # remote server directory to upload backup BACKUPDIR=”/pro/backup/sql” # login to remote server ftp -n -i $SERVER […]

Read more

How to install SOGo and use it with LDAP on a CentOS 7 Linux VPS

How to install SOGo and use it with LDAP on a CentOS 7 Linux VPS

In the following article we’ll show you how to install SOGo and use it with LDAP on a CentOS 7 Linux VPS. If you’re looking on how to set it up on an Ubuntu Linux VPS, please refer to our guide on how to install SOGo on Ubuntu 14.04 VPS. What is SOGo? SOGo is a fully supported and trusted groupware server with a focus on scalability and open standards. SOGo is released under the GNU GPL/LGPL v2 and above. SOGo provides a rich AJAX-based Web interface and supports multiple native clients through the use of standard protocols such as CalDAV, […]

Read more

How to install and configure MySQL Master-Slave replication on a CentOS 7 VPS

how-to-install-and-configure-mysql-master-slave-replication-on-a-centos-7-vps

In this tutorial we’ll explain how to install and configure MySQL Master-Slave replication on a CentOS 7 VPS. The following MySQL replication is based on binary log position, which means it is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database.

Read more

How to install SOGo on Ubuntu 14.04 VPS

Sogo Diagram

In the following article we’ll explain how to install SOGo on Ubuntu 14.04 VPS. SOGo is a fully supported and trusted groupware server with a focus on scalability and open standards. SOGo is released under the GNU GPL/LGPL v2 and above. SOGo provides a rich AJAX-based Web interface and supports multiple native clients through the use of standard protocols such as CalDAV, CardDAV and GroupDAV, as well as Microsoft ActiveSync. SOGo is the missing component of your infrastructure; it sits in the middle of your servers to offer your users a uniform and complete interface to access their information. It […]

Read more

How to install EHCP – Easy Hosting Control Panel on Linux/Ubuntu

How to install EHCP - Easy Hosting Control Panel on Linux/Ubuntu

In this tutorial we will show you how to install EHCP – Easy Hosting Control Panel on Linux/Ubuntu. WHAT IS EHCP? EHCP – Easy Hosting Control Panel is a multilingual web-based server administration panel. It is a tool for your server which helps you to facilitate the process of hosting domains, emails, adding domains, ftp users and so on… as well as modify and control open source apps, Apache, PHP, cron and others…

Read more