Choosing Your Cloud Sites Technology Setup

Reading Time: < 1 minute

Behind Cloud Sites, racks full of both Linux and Windows servers power over 100,000 sites and applications. Every Windows-based page is served from clusters built and optimized especially for Windows, and every Linux-based page is served from clusters built and optimized especially for Linux. We use advanced load balancing technologies to automatically detect the type of technology you are running and route each request to the proper pool of servers.

This is a great example of the power of cloud computing, since you no longer have to make a hosting choice between Linux and Windows. Both PHP and .NET are included, allowing you to choose the technology you need site by site.
Continue reading “Choosing Your Cloud Sites Technology Setup”

How to Disable MySQL Strict Mode

Reading Time: 3 minutes

MySQL’s, and MariaDB’s, strict mode controls how invalid or missing values in data changing queries are handled; this includes INSERT, UPDATE, and CREATE TABLE statements. With MySQL strict mode enabled, which is the default state, invalid or missing data may cause warnings or errors when attempting to process the query.

When strict mode is disabled the same query would have its invalid, or missing, values adjusted and would produce a simple warning. This may seem like the preferred result, however with strict mode disabled certain actions may cause unexpected results; for instance, when the value being inserted exceeds the maximum character limit it will be truncated to fit the limit. Continue reading “How to Disable MySQL Strict Mode”

Importing Databases and Tables with phpMyAdmin

Reading Time: < 1 minute

 

  1. This tutorial assumes you’ve already logged in to phpMyAdmin.
  2. Now let’s learn how to import a database.
  3. Click the database you wish to import here.phpma-import-frame03_1
  4. Let’s assume the data in our details table is corrupt, and we want to import a saved (exported) copy of the data.
  5. Therefore, let’s first delete the existing details table from our database.phpma-import-frame05_1
  6. Now let’s import the saved copy of our database, which includes the details table.phpma-import-frame07_1

    phpma-import-frame09_1

    phpma-import-frame14_1

  7. That’s it! The demo1234_members database has been successfully imported, as indicated here.