Found 35 results
Access 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: 10/08/2018 | 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/2019We all heard in the news about GDPR in 2018, but what is GDPR? In the first place GDPR or also known as EU General Data Protection Regulation is a decisive amendment in data privacy regulation from the last 20 years, it actually basis his provisions on the Data Protection Directive 95/46/EC and was particularly created to reconcile data privacy laws within Europe. The main difference regarding the legislative framework is given by the name itself GDPR – that means it is a regulation (a legally binding act) and not only a directive (an official or authoritative instruction that outlines […]
Category: Regulations | Published: 04/08/2018 | Updated: 05/11/2018Setup 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/2019Create a Backup Server on Linux
How to create a backup server on Linux is just another quick and easy tutorial from Tufora.com that will guide you step by step to create in just a few minutes your own Linux backup server based on CentOS 7 operating system and also system storage manager (ssm) utility. Even if we are living in the age of Cloud technology with so many nice tools available out there like storage buckets, blob stores and many other trendy names some of us may still need to keep the data safe somewhere on premises. This could be due data sensitivity or maybe […]
Category: General | Published: 06/07/2018 | Updated: 05/11/2018In this tutorial called create MySQL slave by cloning we’ll try to guide you through a very detailed but in the same time simple process to create a MySQL slave, also known as MySQL replica, by using a fresh backup taken from an existing MySQL server referred here as MySQL master server. Assuming that our master database is 11TB large we’ll have to copy its data content from US, where the master server is located to another server located in a UK data centre, not quite an easy task with this amount of data or without using a costly commercial […]
Category: MySQL | Published: | Updated: 05/11/2018