How to import and export record from table to another MySQL without import ID

How to import and export record from table to another MySQL without import ID ? Come importare ed esportare record da una tabella mysql a un’altra senza importare l’ID? INSERT INTO databasename.TargetTable (column_list) SELECT column_list FROM databasename.SourceTable Example INSERT INTO newproject.content (desc,author,`fulltext`) SELECT desc,author,`fulltext` FROM oldproject.content Note If you have fulltext field in your column_list, …

How to import and export record from table to another MySQL without import IDLeggi altro »

How to Enable logging on disk on fortigate (fortinet) 5.x?

Problem: Enable logging on disk on fortigate 5.0? Solution: Applied to: fortigate 40c and others. connect on fortigate console (CLI console) launch the following command: fortigate # get sys status Version: FortiGate-VM64 v5.0,build0228,130809 (GA Patch 4) …… License Status: Valid …… Log hard disk: Need format Hostname: fortigate Operation Mode: NAT Current virtual domain: root Max …

How to Enable logging on disk on fortigate (fortinet) 5.x?Leggi altro »

Kill all processes for specific database on Microsoft SQL Server

Problem: How to kill all processes on Microsoft SQL Server database ? Solution: Applied to: Microsoft SQL Server Execute the follow query on master database and change ‘MyDB’ with your DB: DECLARE @kill varchar(8000) = ”; SELECT @kill = @kill + ‘kill ‘ + CONVERT(varchar(5), spid) + ‘;’ FROM master..sysprocesses WHERE dbid = db_id(‘MyDB’) EXEC(@kill); Best Regards, …

Kill all processes for specific database on Microsoft SQL ServerLeggi altro »

vSphere 5.5 – vCenter Server Ports

 http://kb.vmware.com/kb/2051575 Port Protocol Description 80 TCP vCenter Server requires port 80 for direct HTTP connections. Port 80 redirects requests to HTTPS port 443. This redirection is useful if you accidentally use http://server instead of https://server. Note: Microsoft Internet Information Services (IIS) also use port 80. For more information, see theConflict Between vCenter Server and IIS …

vSphere 5.5 – vCenter Server PortsLeggi altro »

Windows 8.1 – How to view the password of a known Wi-Fi network / Visualizza password wifi

Problem: How to view the password of a known Wi-Fi network Solution: Applied to: Microsoft Windows 8.1 Windows 8.1 – How to view the password of a known Wi-Fi network Once you connect to a Wi-Fi network, Windows will automatically save the password, so that you don’t have to enter it at each connection. If you …

Windows 8.1 – How to view the password of a known Wi-Fi network / Visualizza password wifiLeggi altro »

Best Practices – How to calculate page file size (pagefile) on windows server 2008 R2 / 2012

Problem: How to calculate page file size Solution: Applied to: Microsoft Windows Server 2008 R2 and 2012 http://support.microsoft.com/kb/889654 Use one or more of the following methods to help you calculate page file size. Method 1: Use performance logs to understand the paging activity on your computer Click Start, point to Administrative Tools, and then click …

Best Practices – How to calculate page file size (pagefile) on windows server 2008 R2 / 2012Leggi altro »

e.preventDefault Internet Explorer 8 / 9 / 10 – Object doesn’t support property or method ‘preventDefault’

Problem: SCRIPT438: Object doesn’t support property or method ‘preventDefault’ Solution: Applied to: Internet Explorer 9 and Internet Explorer 10 (but it’s similar for the other). Put the following instructions on your javascript code: if (e.preventDefault) { e.preventDefault(); } else { e.returnValue = false; } If you need more information look on microsoft website (http://msdn.microsoft.com/en-us/library/ie/ms534372(v=vs.85).aspx) Best Regards, …

e.preventDefault Internet Explorer 8 / 9 / 10 – Object doesn’t support property or method ‘preventDefault’Leggi altro »