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.
  517 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 using the...
Continue reading
  858 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 directory...
Continue reading
  15562 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 wa...
Continue reading
  3324 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 req...
Continue reading
  2799 Hits

MySQL Replication Resync

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

 

Continue reading
  1222 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 contents ...
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 col...