Author Archives: Nilesh

How to save a MySQL Database quickly with MySQLDump in Linux?



In a previous tutorial, we have seen how to save a MySQL Database with MySQLDump in Windows (WAMP). Today, we will see the quickest way to save a MySQL Database in Linux. For information database, the backup can also be done through a script which allows saving a database or set of databases. But the script can be a little too complex for easy to use tool for backup, natively available in MySQL. So here, we are going to see how to save a MySQL database by using Linux command line.

So we will use the command line for mysqldump that can save a database to store it in a .sql file that can be back later as well. In short, the sql file will contain a set of commands that, when it will be read by MySQL and will present the data to its original state (when it was backed up). MySQLDump is directly included in the installation of a MySQL Server. Suppose I want to save the database “bod007″ 🙂 in the file “bod007_nil84aug.sql”, I will use the following command: read more

4 Steps to Get IP Address of all VMs in Hyper-V

4-Steps-to-Get-IP-Address-of-all-VMs-in-Hyper-VIn this short & sweet tutorial we will try to make our system admins job easier to manage Hyper-V platform, at least I hope. Whether for export, to find who own an IP address or to find an available IP address, etc… You may need to know quickly what are the IP addresses used by your VM on a Hyper-V host.

For this, we will rely on the Hyper-V module for PowerShell and specifically the Get-VM cmdlets.

So let’s see how to get VM IP with PowerShell

1. Open a PowerShell console (run as administrator) and enter the following command:

2. The widespread property of “NetworkAdapters” benefits us, so we will select:

3. Again if we remade a Get-Member about this command, you will get a number of important sub-properties, we will select a few:

read more

How to Save a Database with MySQLDump in WAMP?


Today, we will learn how to save a MySQL database on Windows environment, after installing a web server WAMP. We will use a native tool that comes with MySQL i.e. MySQLDump.

In this tutorial, we are going to use WAMP 2.5 and will name the backup as “mydb”.

Database Saving

We will have to open a Windows command prompt. Building on the executable “mysqldump” then can quickly backup a database.

We jump by assigning the directory where the executable file is located and then mysqldump.exe with the –u option to the user name, –p option to be asked the password and following your options as it is necessary to indicate the name of the database. Then the end of the line to record the output to a file named “mabase.sql” and located the directory “C:\Backup”. read more

Linux Server Security: SELinux or Systemd?

bodHOST Linux Server Security

The security of a Linux server is being always a sensitive issue. Here is what Greg Kroah-Hartman thinks about SELinux (he is one of project developers of systemd).

The recent convention of CoreOS Fest Berlin (9 and 10 May 2016) was particularly rich in action and followed by several specialized portals. During the event, Greg Kroah-Hartman had given some interesting statements on ‘the Linux kernel development process and the security of the operating system’.

The important issue was also touched by Lennart Poettering (currently employed by Red Hat and known for Avahi, PulseAudio, and systemd), he is one of the developers of the project systemd init (process during startup is called into question by the kernel to initialize the user space), which he explained with essential parameters that act on the safety of a Linux server. read more

Intel Xeon E5-2600 Expands its v4 with 22 Core

E5-2600 v4With 22 Core, 14 nm engraving, security and telemetry functions strengthened, Intel Xeon E5-2600 v4 meet the performance requirements of servers.

With metronomic pace, Intel respects its timing for processors renewal for servers. Thus, unveils the successor of Xeon E5-2600 v3 that worked on the micro-architecture Haswell. For v4, Intel preferred micro-architecture Broadwell instead of Haswell. The latter is known in the world of mainstream processors and has been adapted to the world of data centers and especially Cloud. read more

Did you know Raspberry Pi 3 can be used as Web Server?

Raspberry Pi 3 Web Server

Well, you read rightly – the Raspberry Pi 3 can be used as a Web Server. Even for relatively high loads. The only difficulty is the lagging storage.

The Raspberry Pi Foundation is very confident in the effectiveness of its ARM solutions. More than an educational tool for Geeks, the organization sees the Raspberry Pi as a new form of a system, able to hunt on the lands of traditional desktops machinery or servers.

“Can you replace your $10,000 server for $35 or $40 machine? The answer was no until now”, said by the Foundation. With the Pi 2 and 3 things, however, seem to be able to change. Thus, during the launch campaign of Pi 3, it was added as reinforcement of the existing server infrastructure. 5% of queries were redirected to a Pi 3 and 3% to a Pi 2. Redirect tests – 25% of traffic to the Pi 3 was conducted successfully and without any noticeable slowdowns. read more