One way to create a backup of a MySQL database on the shell is to use the mysqldump command. Mysqldump creates a dump of the database in form of sql commands, which can be easily restored using the mysql command or PHPMyAdmin. Backup a MySQL Database mysqldump -u root -p mydatabase > /tmp/backup_mydatabase.sql This command ... Read more
This short guide shows you how to add a newline into a file by using the echo command on the Linux shell. Add a Newline Character using echo command in Bash In this example, I'll assume that we have a file example.txt with the following content: Line 1 Line 2 Now we want to use ... Read more
When a server has more than one IP address, then postfix will use all IP addresses randomly to send out emails. This can cause your emails to be listed as SPAM on other servers because the sending IP does not match the reverse IP of the server hostname. The solution is to bind postfix to ... Read more
The winmail.dat file is a container file format used by Microsoft Outlook to send attachments in rich-text formatted emails. To open winmail.dat on Linux, use the tnef utility. Installation sudo apt-get install tnef Usage Open a shell window, navigate to the directory where the winmail.dat file is saved, then execute the command: tnef winmail.dat to ... Read more
The majority of graphical environments let you choose to remember the passwords you enter somewhere to ease access to something but they usually don't tell you how to delete them again. Most Linux desktop distributions have a tool installed where all your saved passwords for network drives are stored in that is called Passwords and ... Read more
FFmpeg has been removed from Ubuntu 14.04 and was replaced by Libav. This decision has been reversed so that FFmpeg is available now in Ubuntu 15.04 again, but there is still no official package for 14.04. In this tutorial, I will show you how to install FFmpeg from mc3man ppa. Add the mc3man ppa: sudo ... Read more
High page speed and short page load times of your website are essential for good search engine rankings today. In this FAQ, I will show you how to enable caching of graphic and CSS files in apache on Ubuntu and Debian. The first step is to enable the expires module in apache: a2enmod headers expires ... Read more
The SCP command line is commonly used to copy files over SSH, and between popular Operating systems like Linux, Mac and Windows in a secure fashion. SCP is used to copy files to/from a remote server. It also allows you to copy files from one remote server to another remote server, without passing traffic through your PC.
Here is a list of ports that are used commonly on ISPConfig 3 servers. If you don't have all services installed or if you e.g. don't want to connect to MySQL from external servers, then close the unused or unwanted ports. TCP ports 20 - FTP Data 21 - FTP Command 22 - SSH 25 ... Read more
The following guide shows how to disable and remove mysql replication from two or more mysql servers. These steps can be used for master/slave and master/master mysql setups. The following SQL commands have to be be executed in phpmyadmin or with the mysql commandline program. It is just important that you are logged in as ... Read more