MySQL Check All Tables in Database

If you need to check (not repair) all your tables at once , run the following command in your shell;You will be prompted to enter the password.-A means check all databases -c means Click here to view how to repair all tables.
Rate this blog entry:
Continue reading
19 Hits
0 Comments

MySQL Repair All Tables in Database

Open a shell and run the following command;​You will be prompted to enter your password.
Rate this blog entry:
Continue reading
29 Hits
0 Comments

PHP 7.1 with Win 10, XAMPP & SQLSRV Driver

​If you're trying to use XAMPP on Windows and connect to a SQL server using PHP, hopefully the following will help.Firstly download XAMPP for Windows (32 bit). Follower the installer, default options.Then download the Microsoft Drivers 4.3 for PHP for SQL Server.  Extract the contents of this download to your PHP extensions directory...
Rate this blog entry:
Continue reading
5619 Hits
0 Comments

Ubuntu 14 Install and Configure SSH

Ensure the OS is up to date.Install OpenSSH server on the OS.It's also a good idea to make a copy of the default SSH configuration, so that if you ever mess up your SSH settings you can revert to the original.That's all you need in order to get SSH working. You should now be able to use a program like Putty in order to connect to the remote OS...
Rate this blog entry:
Continue reading
594 Hits
0 Comments

SSL Certs & Apache Tomcat

​Some tips on dealing with SSL Certificates and Apache Tomcat. If you have to renew your SSL cert or install a new one hopefully these instructions will help.I'll be using Apache Tomcat 7, so the steps may differ with other servers.Firstly you have to generate a CSR on the server (basically a single file), and then send this to whoever you are plan...
Rate this blog entry:
Continue reading
990 Hits
0 Comments

Server Performance With perfmon

How to monitor server performance with perform.

Rate this blog entry:
Continue reading
718 Hits
0 Comments