Posted on

Move a mysql – mariadb database from one windows server to another windows server

Install xampp on the new server and If mysql is on, turn it off.

In the folder C: \ xampp \ mysql \ data create a new folder, for example with the name of the database you are moving.

Copy in it all the data files (.frm, .ibd, .myd, .myi) from the relative folder of the old server.

Make a copy in a backup folder of the file ib_logfile0, ib_logfile1, ibdata1 those are in the folder “C: \ xampp \ mysql \ data” in the new server.

Copy the files ib_logfile0, ib_logfile1, ibdata1 from the old server to the same location as the new server, i.e. in the folder C: \ xampp \ mysql \ data

Start mysql. Open a dos prompt, go to the directory

cd C: \ xampp \ mysql \ bin

mysql -u root -p

show databases;

You should see the new database added to the previous ones.

Open another dos prompt and check the tables with the commands

cd C: \ xampp \ mysql \ bin

mysqlcheck -uroot -p YOURDATABASE

Open your browser and connect to phpmyadmin with http: // localhost / phpmyadmin

You should see the database and tables.

Posted on

Opening a csv file in Excel. How to keep all leading zeros in fields

When you open a csv file in Excel, if you have data that contains zero (0) at the beginning, it will be transformed into numbers losing the leading zero. Let’s see how to avoid losing the leading zeros.

Do not open the csv file with Excel. Instead, open Excel with a new sheet. Go to the “Data” tab and press “from text / csv”.

Upload your csv file now. A new window appears which performs a data transformation.

Above you have some important choices.

Excel figured out which the csv file delimiter is. Note: use this procedure also when you are importing data saved in a csv file with a different delimiter from your standard.

Excel tries to figure out the data type for each column “based on the first 200 rows”; I recommend that you select “based on the entire dataset”. This way Excel should understand that the column with zeros contains text and not numbers. Press “Load” to end the procedure or “Transform Data” to force other choices if necessary.

Posted on

Install Proliant Service Pack (spp) using ILO

Scenario

You have downloaded the Service Pack for ProLiant (spp) in iso format and want to install it using ILO.
In ILO open “Remote Console & Media” and load the iso. Restart the server and start installing the service pack. At some point the installation crashes (at a certain percentage of completion).

Solution

The problem is that you used ILO’s HTML5 client to load the ISO; you have to use the Java client.

Hmtl5 remote console unmaps the image after a while

Posted on

Windows server – Active Directory – useful links

Move active directory roles from a domanin controller ti another

VERIFICARE E MODIFICARE I RUOLI FSMO DI UN DOMINIO WINDOWS

Backup Domain Controller

Aggiungere un Backup Domain Controller ad un dominio Active Directory esistente

Installing licenses for Remote Desktop

Licensing Mode for Remote Desktop Session Host is not Configured

Modalità gestione licenze di Desktop remoto non configurata

Posted on

iis error 0x80070021 on web.config

This error occurs when installing a site locally with IIS on a windows 10 or a windows 8.1. It is not excluded that it can also occur on server operating systems.

Error Details

Module :IIS Web Core

Notice: BeginRequest

Handler: Not yet determined

Error: 0x80070021

Configuration error: This configuration section can not be used in this way. This happens when the section is locked at the parent level. Locking is either by default (overrideModeDefault = “Deny”), or installed directly by the tag location with overrideMode = “Deny” or inherited property allowOverride = “false”.

The configuration file
\\?\C:\inetpub\wwwroot\test\web.config

Physical Path
C:\inetpub\wwwroot\test\miofile

Logon Method: Not yet determined

Users who have logged on: yet to be determined

SOLUTION

You also need to install .NET and the IIS development tools

or