Tutorials
SSH client configuration for Jump Host
SSH client configuration for Jump Host is just a simple, fast and efficient way to configure your local SSH client to remote access via SSH other external networks / hosts. In the same time we can say that this solution adds a layer of security as well if your environment is not so secure for whatever reason, we have seen this quite often but let’s not talk about this yet. In this short tutorial we will try explain in a very simple way how you may configure your local SSH client configuration file in order to connect straight to one […]
Category: Security | Published: 10/08/2018 | Updated: 15/11/2018Rename MySQL table, sometimes we need to rename a table during a database update or for any other solid reason. In this short step by step guide we will show you how easy is to rename one or even more MySQL tables in a database using only MySQL client, the answer to “how do I rename a mysql table” question is right here in this short article. Please bear in mind that in our tutorial we have used MySQL 5.7 to rename tables but this solution could be easily applied even for lower or higher MySQL versions. As always, before […]
Category: MySQL | Published: | Updated: 07/11/2018Copy MySQL table, the simple process of copying a MySQL database table will be now explained in this short tutorial. Quite often we need to check some new queries, features or simply we need perform some basic tests that can be very difficult or sometimes impossible to be taken on a live database table. Luckily MySQL can help us to copy a database table with or without indexes and triggers, a full table copy or we can simply take a simple table copy, just the data and nothing else. In this short tutorial we will guide you how to take […]
Category: MySQL | Published: | Updated: 08/11/2018Access MySQL without password locally may be sometimes needed and quite handy for various reasons like for example if you are a very passionate database developer or just occasionally doing DBA stuff and you desperately need to quickly access a specific database or table, can be quite annoying to type in your username and password each time you are using the console. In this very short tutorial we’ll talk about how to access MySQL without using a password locally via terminal window. We have tested this method using MySQL version 5.6 and 5.7 based on CentOS 7 operating system but […]
Category: MySQL | Published: | Updated: 05/11/2018In this tutorial called dump MySQL table and import we will learn how to export a single database table using mysqlpump utility instead of exporting an entire database and also we will guide you how to import a single database table using different methods. Exporting a single table can be very handy when you have to update or replace another database table that is not part of a cluster or maybe you simply need it for your development environment to perform some quick changes or various tests. In this example we will use MySQL 5.7 and MySQL Client (CLI) based […]
Category: MySQL | Published: 08/08/2018 | Updated: 23/04/2019Setup NFS Server and NFS Client on CentOS 7
In this tutorial we will learn how to set up NSF Server and NFS Client on CentOS 7 operating system, setting up or managing a NFS server or a NFS client is not quite a complex task at all, we’ll do our best to explain this entire process in the most simple possible way. We can use the set up from this tutorial for various small network sharing applications like setting up a backup server or maybe a simple file server etc., either way NFS package is always a good candidate to start with. Network File System (NFS) has been […]
Category: General | Published: 17/07/2018 | Updated: 26/08/2019