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; mysqlcheck -h hostname -u username -p -A -c You will be prompted to enter the password. -A means check all databases  -c means  Click here to view how to repair all tables.
  610 Hits

MySQL Repair All Tables in Database

Open a shell and run the following command; mysqlcheck -h hostname -u username -p -A --auto-repair ​You will be prompted to enter your password.
  636 Hits

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 direct...
Continue reading
  17185 Hits

Ubuntu 14 Install and Configure SSH

Ensure the OS is up to date. sudo apt-get update sudo apt-get Install OpenSSH server on the OS. sudo apt-get install openssh-server 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. sudo cp /etc/ssh/sshd_config /etc/ssh/sshd_config.factory-defaul...
Continue reading
  1256 Hits

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 pl...
Continue reading
  1553 Hits

Server Performance With perfmon

How to monitor server performance with perform.

Continue reading
  1160 Hits

Latest Comments

Guest - Susan Hermiston Virtual Hosts
October 7, 2015
Wow 747 just blew me away. Sorry not a tech person at all!! But I still love you!! Rock on!!?
Guest - Johmny Invisible Mouse Cursor Ubuntu & Synergy
September 2, 2015
Glad I was ble to help!
Guest - Kristian Falk Invisible Mouse Cursor Ubuntu & Synergy
September 1, 2015
Thank you for this! Had the exact same problem. I almost went crazy.

Popular Blogs

Blog
Development
This is how to get rid of that popup appearing every time you create your own local extension in Chrome. Create a .bat file and name it `DevWarningPatch.bat`. Save this to the desktop. Add the content...
Blog
Development
​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...
Blog
If you are receiving this error while tryng to import a CSV file, make sure that the number of columns in your CSV matches that of your existing database table. I had an existing table with 10 co...