Renaming Database Tables with PhpMyAdmin

Reading Time: 2 minutes

Renaming a table within a database is a task that may need to be done occasionally. You might just need to rename it for clarification purposes, to archive old data, to make a copy when a restore is being done, or any number of other reasons. PhpMyAdmin helps you rename a database quickly with just a few clicks.

Continue reading “Renaming Database Tables with PhpMyAdmin”

Searching Through a Database with PhpMyAdmin

Reading Time: 3 minutes

Using PhpMyAdmin to search for records and information in your database can quickly help you get the information you need without having to run advanced search queries. This tutorial assumes you have already logged in to PhpMyAdmin, and shows how to search by keyword and for a range of records.

Continue reading “Searching Through a Database with PhpMyAdmin”

Running SQL Queries on a Database with PhpMyAdmin

Reading Time: 2 minutes

In this tutorial, we will explore how to run SQL queries on a database within PhpMyAdmin. SQL stands for Structured Query Language. SQL statements or queries are used to perform database tasks such as searching, updating, or retrieving data from a database.

Continue reading “Running SQL Queries on a Database with PhpMyAdmin”

What is Machine Learning?

Reading Time: 3 minutesIt was 2017 when American businessman Mark Cuban said that if you don’t understand artificial intelligence, deep learning and machine learning “you’ll be a dinosaur within three years.” Time will tell as to whether he is right, but if his theory has substance, some companies are well into the 12-month countdown of becoming extinct.

What is Machine Learning?

In its purest form, machine learning teaches computers to learn in the same way that humans do. It collects and interprets data from the world around us and makes decisions on what to do with that information. Machine learning is one of the first applications of artificial intelligence. Just think about every time you start a search using Google. How can it find all the relevant matches to your terms? Considering there are 30 trillion unique web pages that search engines trawl to retrieve what you need, it is even more impressive. It’s impossible for a human to explore that many pages in a lifetime. This is the essence of machine learning, without intervention computers learn to use data to accomplish human tasks in a fraction of the time.   Machine Learning and Data It is almost impossible to stress just how vital data is to machine learning; in fact, they are just about synonymous with each other. This is probably best summarised within the Data Science Hierarchy of Needs penned by Rogati, 2017. At the top of the hierarchy is the AI or Deep Learning algorithm. This might be the algorithm that recommenders which Netflix show to watch or Amazon Alexa responding to your voice command. However, at the very start of the journey is data collection and the quality of what feeds the algorithm. As an example, marketing teams use machine learning applications to hyper-personalize communications. This is why we tend to get emails or notifications that are highly relevant and tailored to our needs. The machine has studied our data and knows exactly what we need and when we want it. Had the initial data been incorrect or “dirty” in any way, customers would receive communications that are not relevant. What if somebody had accidentally entered a customer location as the U.K. on an order form instead of the U.S. and all pricing is calculated pounds instead of dollars? The customer would soon unsubscribe to an email list because it doesn’t pertain to them. A company can have the best algorithms in the industry, but without quality data, they are effectively useless and possibly detrimental. To counter these problems, companies deploying machine learning technology will usually start by designing a data quality or governance strategy which negates the risk. Adopting AI is a journey and must begin with getting the simple things right.   Machine Learning Framework Hiring a team to design and deploy machine learning applications can be costly. While Data Scientists are usually specialists in statistical methods and incredibly adept with coding languages like Python and R; they often find it hard to present findings to Data Analysts or Insight Managers. However, the algorithms also need to be deployed onto platforms requiring a Data Engineer or Developer. There also needs to be duplicate roles to avoid single points of failure, and of course, everybody needs powerful processors that can analyze vast amounts of data. Suddenly, one Data Scientist has become a team of 8 people with expensive hardware and costs have escalated! The role of machine learning has been growing exponentially in the last few years, and it looks set to continue with recent developments in cloud, edge and quantum computing which will only increase the potential processing power. Companies who fail to realize the capability of AI will fall behind the competition. Our Cloud Sites service is a fine example of how machine learning works in a hosting environment. This PaaS allows your websites to scale as your site grows, without having to worry about scheduling downtime to resize and upgrade your server! Our one-click install of popular CMS’s makes working on your sites that much easier.

What is ModDeflate?

Reading Time: 3 minutes

How mod_deflate works

When a visitor accesses a website, a request is made to the web server for a specific kind of data. An example might be a home page of a site. Next, the web server locates that data and delivers it to the client who is requesting that data – basically back to the web browser. In this example, the speed at which the home page loads can depend on a variety of factors. One of them could be how long it takes to find and deliver the data for that page. This is just one example. Some of that data – such as javascript files, css files, and php files – can actually be compressed into smaller sizes before they are delivered back to the visiting client or browser at the smaller size. The visitor can now have a more optimized browsing experience. This is where mod_deflate comes in. Continue reading “What is ModDeflate?”

Copying a Database Table with PhpMyAdmin

Reading Time: 2 minutes

Copying a table is quick and easy to do within PhpMyAdmin. Whether you are trying to make a backup copy before changes are made, archiving data, moving data to a new site or application, or even just working on restructuring your database, PhpMyAdmin can help you get the job done in just a few clicks.

This guide assumes that you have already logged in to PhpMyAdmin.We will go over how to copy a table and go over a few of the options PhpMyAdmin gives us.

Continue reading “Copying a Database Table with PhpMyAdmin”

How To Repair a MySQL Database in cPanel

Reading Time: < 1 minute This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to repair a database.
  1. Click the “MySQL Databases” icon.cpanel-pl-mysql-10-repair-02
  2. Under “Modify Databases”, and in the “Repair Database” drop down box, select the database you want to repair.cpanel-pl-mysql-10-repair-03
  3. Then click “Repair Database”.cpanel-pl-mysql-10-repair-04
  4. That’s it! The database has been repaired.cpanel-pl-mysql-10-repair-05

MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison

Reading Time: < 1 minute
General Results
  • MySQL 5.5 and 5.6 both performed significantly better than MySQL 5.1.
  • Read/Write and Read Only workloads testing requests per second show a marked improvement for both MySQL 5.5 and 5.6 over MySQL 5.1.
  • The 95th percentile response times (explained below) for both Read/Write and Read Only workloads on MySQL 5.5 and 5.6 were much lower (thus faster) than MySQL 5.1.
Requests per Second
MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison - Requests per Second - Read and Write Operations Continue reading “MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison”