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.
  673 Hits

Ubuntu Remotely Connect to MySQL Database

In order to remotely access a MySQL database in Ubuntu it's necessary to edit the following file;  /etc/mysql/my.cnf  Find the following line;  bind-address = 127.0.0.1  Comment it out, and change it to the following;  #bind-address = 127.0.0.1  bind-address = 0.0.0.0  You then need to restart the MySQL service us...
Continue reading
  1376 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
  17448 Hits

Server Side Events with MySQL and PHP

​I wanted to build an application that would display a 'real time' feed of data on my web page. I had access to a MySQL database that contained a 'transactions' table, this table received numerous events every second. I needed to display the transactions in real time (or close enough).  Not only did I need to display the live data, but I also ...
Continue reading
  4277 Hits

Omeka Install & Setup LAMP

Having worked with Omeka the past few days I'll explain how to set it up on a LAMP stack. Firstly, what is Omeka? Well, taken from their website; Omeka.net is web-publishing platform that allows anyone with an account to create or collaborate on a website to display collections and build digital exhibitions. No technical skills or special server re...
Continue reading
  3036 Hits

MySQL Replication Resync

Instructions on how to resync a MySQL slave/master replication.

 

Continue reading
  1327 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...