Knowledgebase

.NET Development: Everything That Matters, Briefly The summary.THE PLATFORM IS CROSS-PLATFORM NOWWhich changes hosting entirely — Linux servers and... "Error Establishing a Database Connection" in WordPress, Causes and Solution. In this article we shall look how to resolve the "Error Establishing a Database Connection".... 504 Gateway Timeout The upstream process took too long to respond.WHAT IT MEANSYour application started work and did... A Backup Strategy That Works Beyond a single copy.WHAT TO BACK UPWebsite files and database Email Business records and... A Checklist for Any New Application What to do every time.BEFORE INSTALLINGCheck PHP version and extension requirements against your... A Complete Backup Checklist Everything in one place.THE ARRANGEMENTBackups run automatically on a schedule They include files... A Complete Migration Checklist Every step, in order.BEFORERegistrar access confirmed Current host access confirmed Full backup... A Continuity Checklist for Small Businesses A practical starting point.ACCOUNTSDomain auto-renewal enabled Registrar contact details current... A Database Checklist Everything that matters.SETUPOne database per application One user per database, with all... A Failed Update Broke the Site The most common reason to need a backup.IMMEDIATE ACTIONIf you took a backup before updating,... A Monthly Backup Review Fifteen minutes.WHAT TO CHECKRecent backups present in storage, with correct dates and plausible... A Plugin or Extension Broke Everything Recovering without a full restore.THE SYMPTOMThe site was working, you installed or updated... A Practical Database Task Reference Common jobs and where they are covered.TAKING A BACKUPcPanel > Backup > Partial Backups, or... A Quarterly Restore Test The check that matters most.WHY QUARTERLYFrequently enough to catch a problem before you need the... A Speed Improvement Plan What to do, in order.STEP ONE: MEASURERun a speed test on three pages. Note the page size and the... A Summary: Running Software on Your Hosting Everything that matters, briefly.BEFORE INSTALLINGCheck requirements against your plan Check the... Access denied for user The database refused the credentials.WHAT IT MEANSThe username or password is wrong, or the user... Advanced Practice: Everything That Matters, Briefly The summary.EVERYTHING IN A SERVICE PROVIDER'S BOOT METHOD COSTS EVERY REQUESTNo queries, no... AI and Code Security Specific risks.WHY SECURITY CODE IS DIFFERENTSecurity failures are silent. Code that works and is... AI Tools for Developers Building with AI.WHAT IS AVAILABLEAPIs for text, image, speech and embeddings Frameworks for... Altering Table Structure Adding, changing and removing columns.WHEN YOU WOULDAdding a column for custom data Widening a... Always Use HTTPS and Automatic HTTPS Rewrites Two related SSL settings.ALWAYS USE HTTPSRedirects http requests to https at the edge, before... An Annual Backup and Recovery Review An hour once a year.THE ARRANGEMENTIs the frequency still right for how the site has changed Is... Analytical Versus Transactional Databases Two different purposes.WHAT TRANSACTIONAL SYSTEMS OPTIMISE FORMany small reads and writes Strong... Android Architecture Components The recommended structure.WHAT THE RECOMMENDED LAYERS AREThe interface layer: displaying state... Android Data Storage Where information lives on device.WHAT OPTIONS EXISTKey-value preference storage, for small... Android Testing Verifying an Android application.WHAT LEVELS EXISTUnit tests, running on a development machine... Another update is currently in progress WordPress thinks an update is running.WHAT IT MEANSA lock left behind by an interrupted... Apple Cloud Services for Developers Storage and synchronisation.WHAT THE CLOUD DATABASE PROVIDESStorage synchronised across a user's... Application Requirements Reference What to check before installing anything.PHP VERSIONEach application states a minimum and a... Application Security Checklist What to verify before a site goes live.INPUT AND OUTPUTAll database queries parameterised Output... Application Update Failed An update that did not complete.WHAT USUALLY HAPPENSThe update downloads, begins, and fails... Applied Fields: Everything That Matters, Briefly The summary.IN ROBOTICS, NO SINGLE SENSOR IS ADEQUATESensor fusion exists because each fails... Architecture for Financial Systems Designing for money.WHAT DISTINGUISHES ITCorrectness matters absolutely State must be auditable... Archiving Old Data Reducing a database without losing records.WHYA shop with years of orders, or a site with years... Assessing Blockchain Opportunities for a Business Commercial judgement.WHAT TO ESTABLISH FIRSTWhat problem is being solved.WHAT TO ASK... Auditing Content with Queries Understanding what your site actually contains.USEFUL AUDITSHow many published posts, pages and... Automated Testing: Everything That Matters, Briefly The summary.A SUITE NOBODY TRUSTS PROVIDES NOTHING WHILE CONSUMING EFFORTWhich is why flaky tests... Automating Backups Backups you have to remember do not happen.THE COMPONENTSA script or tool that dumps databases... Automating Backups with a Script Scheduled backups without a plugin.WHAT A SCRIPT DOESDumps each database Archives the files... Automating Business Operations Running the company efficiently.WHAT TO AUTOMATEInvoicing and receipts Payment retries Onboarding... Automating Deployment with Scripts Turning several steps into one command.WHAT A DEPLOYMENT SCRIPT DOESPulls the latest code... Automating Environment Setup Creating environments from nothing.WHY THIS MATTERSIt is your disaster recovery plan, your... Automating Google Sheets Spreadsheet automation.WHAT AUTOMATION SUITSImporting and transforming data Generating reports... Automating Routine Tasks with Cron Scheduling work on a server you control.WHAT TO AUTOMATEBackups Log rotation, if not handled by... Avoiding the Query Multiplication Problem The most common performance fault.WHAT HAPPENSA list of records is retrieved with one query.Then,... Azure Backup and Recovery Protecting against loss.WHAT THE PLATFORM PROVIDESBackup services for virtual machines,... Azure Databases Managed data services.WHAT OPTIONS EXISTManaged relational databases Document and multi-model... Azure Identity and Access for Resources Controlling who can do what.WHAT ROLE-BASED ACCESS CONTROL PROVIDESPermissions assigned at a... Backend and Full-Stack: Everything That Matters, Briefly The summary.THE BROWSER IS UNDER THE USER'S CONTROLAnything requiring trust — authorisation,... Backend Architecture: Everything That Matters, Briefly The summary.KEEP BUSINESS RULES INDEPENDENT OF DELIVERY AND STORAGEThey can then be tested... Backend Development: Where to Start Learning A path into the work.WHAT TO LEARN FIRSTOne language, properlyHow HTTP works: methods, status... Backend Fundamentals: Everything That Matters, Briefly The summary.EVERYTHING IN THE CLIENT IS UNDER THE USER'S CONTROLPrices, permissions, validation... Backend Testing Strategy Verifying server code.WHAT TO TEST AT EACH LEVELUnit: business rules, without... Backing Up a Database Manually The most important single backup.USING PHPMYADMINcPanel > phpMyAdmin.Select the... Backing Up a Database Properly The most important backup you take.WHY IT MATTERS MOSTFiles can usually be reinstalled. The... Backing Up a Server More than backing up sites.WHAT TO BACK UPSite files Databases Mail, if you host it Configuration... Backing Up a Shop More urgent than for other sites.WHY IT MATTERS MOREA shop's database changes constantly: orders,... Backing Up a WooCommerce Shop Higher stakes than an ordinary site.WHAT CHANGES CONSTANTLYOrders Customers Stock levels Coupons... Backing Up a WordPress Site Completely Everything a WordPress site needs.WHAT MUST BE INCLUDEDThe database, which holds posts, pages,... Backing Up an Online Store A shop's database changes constantly, which changes what a backup needs to be.WHY IT IS... Backing Up Application Data Protecting what matters.WHAT TO BACK UPThe database Uploaded files Configuration Anything not... Backing Up Before a Migration The most important backup you will take.WHYA migration touches everything: files, database, DNS,... Backing Up Before AI-Assisted Changes The habit that prevents disasters.WHEN TO BACK UPBefore running any generated code or command... Backing Up Before Any Change The habit that prevents most disasters.WHENBefore updating core, a theme or a plugin Before... Backing Up Before You Change Anything The habit worth building.WHENBefore updating anything Before installing a plugin Before editing a... Backing Up Custom Code Code you or a developer wrote.THE RIGHT TOOLVersion control. A repository records every change... Backing Up Databases Separately from Files Why splitting them makes sense.WHY SPLITDatabases change constantly and are small. Files change... Backing Up Files with FTP or File Manager Simple methods without special tools.USING FILE MANAGERcPanel > File Manager.Select... Backing Up Media and Large Files When the content is large.THE PROBLEMImage libraries, video and document archives make backups... Backing Up Membership and Course Sites What is at risk.WHY IT MATTERSThe database holds members, subscriptions, progress and payment... Backing Up Multiple Sites on One Account Several websites, one hosting plan.THE STRUCTUREEach addon domain has its own directory and... Backing Up with a WordPress Plugin The usual approach for WordPress sites.WHAT TO LOOK FORScheduled automatic backups Remote... Backing Up Your Business Online What you cannot afford to lose.WHAT MATTERS MOSTYour customer records and order history Your... Backing Up Your Files Properly A real backup.WHAT A BACKUP MUST INCLUDEFiles Databases Email, if it mattersFiles alone are not a... Backup and Continuity for Business Systems Surviving failure.WHAT MUST BE PROTECTEDThe database Configuration Customisation and integration... Backup and Disaster Recovery for Windows Environments Protecting infrastructure.WHAT TO BACK UPDomain controller system state File servers and their... Backup and Maintenance Scripts Automating housekeeping.WHAT TO AUTOMATEDatabase dumps File archives Transferring backups off the... Backup and Recovery Terms Protecting your data.BACKUPA copy of your data, kept separately.FULL BACKUPFiles, databases,... Backup Applications and Tools Software specifically for protecting your site.WHAT TO LOOK FORScheduled automatic backupsRemote... Backup Considerations for Membership and Subscription Sites Recurring relationships complicate recovery.WHAT IS AT RISKMember accounts and access levels... Backup Considerations for Online Shops Where data loss costs money directly.WHY SHOPS ARE DIFFERENTThe database changes constantly.... Backup Costs and Storage Planning What it actually costs to be protected.WHAT YOU PAY FORCloud storage, which for a typical website... Backup Files Are Corrupt or Will Not Open The archive exists and does not work.COMMON CAUSESAn incomplete transfer, where the download or... Backup Infrastructure Systems that protect data.WHAT A BACKUP ISA separate copy, from a point in time, that the live... Backup Storage and Disk Quota Backups that cause the problem they prevent.THE ISSUEBackups stored on the hosting account count... Backup Strategy for a VPS On a VPS, backups are entirely your responsibility unless you have bought them.WHAT TO BACK... Backup Terminology Explained The words used in backup tools.FULL BACKUP: a complete copy of everythingINCREMENTAL: only what... Backups and Data Protection Obligations Backups contain personal data.WHAT THIS MEANSA backup of your database contains everything the... Backups and Disaster Recovery for SaaS Surviving the worst case.WHAT MUST BE RECOVERABLEThe database Customer files Configuration... Backups Are Not Version Control Two different tools for two different problems.WHAT BACKUPS DOLet you return to a previous state... Backups Are Too Large or Taking Too Long When the account has outgrown the arrangement.WHY IT MATTERSLarge backups time out, consume... Backups as a Security Control A tested backup turns a compromise from a crisis into an inconvenience. It is the most valuable... Backups as Security The measure that saves you.WHY BACKUPS ARE SECURITYThey are what lets you recover from anything:... Backups for Businesses with Legal Obligations Where records retention is required.WHAT MAY APPLYTax record retention Contractual obligations... Backups for Sites You Have Inherited Taking over something someone else built.FIRST ACTIONTake a full backup before touching anything.... Backups of Infrastructure Not only data.WHAT TO BACK UPApplication data Databases Uploaded files Configuration The... Backups: Everything That Matters, Briefly The whole category in one page.THE PRINCIPLEAlmost every website disaster is recoverable with a... Before You Restore Anything Steps that prevent making things worse.TAKE A COPY OF THE CURRENT STATEWhatever is wrong now, the... Behavioural Patterns How objects interact.WHAT PROBLEM THEY ADDRESSDistributing responsibility and communication... Blockchain and Digital Assets: Everything That Matters, Briefly The whole category in one page.ASK WHETHER THE ABSENCE OF A TRUSTED PARTY IS ACTUALLY REQUIREDIf... Blockchain Fundamentals: Everything That Matters, Briefly The summary.THE TECHNOLOGY PROVIDES A RECORD NO SINGLE PARTY CONTROLSVerifiable history, and... Briefly unavailable for scheduled maintenance The site is stuck in maintenance mode.WHAT IT MEANSWordPress creates a file called .maintenance... Broken Layout or Missing Styles The site loads without its design.THE USUAL CAUSEThe site URL setting is wrong, so stylesheets... Browsing and Searching Data Finding what you need without SQL.BROWSINGSelect a table and click Browse. Rows appear in... Building a Data Platform Incrementally Growing capability sensibly.WHAT TO BUILD FIRSTOne pipeline, from one source, producing one... Building a Testing Career Developing in the field.WHAT ENTRY ROUTES EXISTManual testing roles Support roles, moving across... Building an API on Shared Hosting Practical considerations.WHAT WORKSA PHP API using any framework, or none. This is ordinary web... Building an Online Shop, Part Two: Briefly Shipping, orders, performance and launch.FOR SHIPPINGZones by area, with rates that reflect your... Building and Applying: Everything That Matters, Briefly The summary.PUT THE MINIMUM ON THE LEDGER — A FINGERPRINT, WITH DATA HELD... Building APIs With Flask The minimal framework.WHAT IT PROVIDESRouting Request and response handling Templating Little... Building Data Pipelines Moving and transforming data.WHAT PIPELINES DOMove data from sources, transform it, and load it... Building Search Into Applications Practical search implementation.WHAT OPTIONS EXISTDatabase full-text search, adequate for modest... Building Services in Go Practical development.WHAT THE STANDARD LIBRARY PROVIDESHTTP serving and routing JSON handling... Building Services in Rust Practical development.WHAT THE ECOSYSTEM PROVIDESAsynchronous runtimes Web frameworks of varying... Caching Storing expensive results.WHAT TO CACHEExpensive queries Computed results External API responses... Caching as the First Answer Why it fixes most resource problems.WHAT IT DOESServes a stored copy instead of building the... Caching Explained Caching stores the result of work already done so it does not have to be repeated. It is the... Caching on a VPS Multiple layers, each solving a different problem.OPCODE CACHINGOPcache stores compiled PHP so it... Caching Plugins and Performance Tools Making applications fast.ON OUR SERVERSWe run LiteSpeed, so the LiteSpeed Cache plugin uses... Caching Strategies Avoiding repeated work.WHERE CACHING HAPPENSIn the browser At a delivery network At a reverse... Caching Strategies for Developers Making an application fast.THE LAYERSOpcode caching: OPcache, which removes PHP recompilation.... Caching Systems Beyond the Edge Application and data caching.WHERE CACHING HAPPENSThe browser A delivery network A reverse proxy... Cannot access cPanel The control panel will not load.TRY THE ALTERNATIVESThrough the Client Area: Services > My... Cannot Log In to the Administrator Area Locked out of your own application.FIRST CHECKSIs the password correct? Reset it rather than... Capacity and Resource Planning Having enough.WHAT TO MONITORProcessor use Memory use Disk space Disk activity Network throughput... CDN Versus Server-Side Caching Two different things people confuse.SERVER-SIDE CACHINGStores generated pages on our server. A... Certificate Errors After Changing Hosting A predictable consequence of a migration if a step is missed.WHY IT HAPPENSThe certificate lived... Change Data Capture Reading changes from the source.WHAT IT ISCapturing inserts, updates and deletes by reading the... Changing Credentials After a Compromise What to change.WHAT TO CHANGEHosting account password Site administrator passwords, all of them... Changing Passwords Safely Doing it properly.WHEN TO CHANGE ONEYou suspect it is compromised It was reused elsewhere A... Changing the Database Without Downtime Schema changes on a live system.WHY IT IS DIFFICULTThe application and the schema must both work... Changing Your cPanel Password Your cPanel password protects every file, database and mailbox on your account. Change it... Checking Whether an Application Will Run on Your Plan Before you commit time to something.WHAT TO CHECKPHP version required, against what your plan... Checking Whether Your Cron Job Is Working Verification.WHY VERIFYA cron job that is not running produces no error. Things simply do not... Checklist: Before Deploying Python Code Pre-deployment.CODEChanges tested somewhere that is not production No debug mode enabled No... Checklist: Taking a Laravel Application Live Before launch.CONFIGURATIONEnvironment set to production Debug mode off Application key set... Choosing a Backup Tool What to look for.THE REQUIREMENTSScheduled automatic backups Remote storage, off the server Both... Choosing a Data Warehouse Selecting the analytical store.WHAT THE MAIN CATEGORIES ARECloud warehouses, billed by usage... Choosing a Form Plugin What to use.WHAT MATTERSThat submissions are stored, not only emailed Spam protection Mobile... Choosing a Language for Data Work Analysis and machine learning.WHAT PYTHON PROVIDESThe largest machine learning ecosystem... Choosing a Python Web Framework The main options.WHAT A FRAMEWORK PROVIDESRouting requests to your code Handling requests and... Choosing a Technology Stack Deciding what to build with.WHAT TO CHOOSE ONWhat you and your team can build and maintain... Choosing and Working Across Languages: Everything That Matters, Briefly The summary.WEIGH LIBRARIES AND MAINTENANCE ABOVE EVERYTHING ELSEWriting what a mature library... Choosing Between a VPS and a Dedicated Server When a slice of a machine is not enough.THE DIFFERENCEA VPS is a portion of a physical server,... Choosing Between Low-Code and Development When each is appropriate.WHAT LOW-CODE SUITSForms and data collection Approvals and simple... Choosing VPS Specifications Sizing a server for what you actually run.START FROM THE WORKLOADA single WordPress site with... Choosing What to Sell Designing your offering.KEEP IT SIMPLEThree packages. Small, medium, large.A page with eight... Choosing Where to Optimise The order that gives results.THE HONEST ORDERCompress and resize images. Almost always the... Cleaning a Compromised Application Removing an infection properly.THE ORDEROpen a ticket so we can check the account... Cleaning a Hacked Website Step by Step Work in this order. Cleaning while the site is still being re-infected wastes the effort.1.... Cleaning the Database Compromises that live in data.WHY CHECK ITSome compromises inject content into the database... Cleaning Up a Bloated WordPress Database Over time the database fills with data no visitor ever sees, which slows queries and inflates... Cleaning Up Database Bloat Reclaiming size and speed.WHERE BLOAT ACCUMULATESPost revisions, one per edit, indefinitely... Cleaning Up Your Database Removing accumulated waste.WHAT ACCUMULATESPost revisions, sometimes dozens per page Spam and... Cleaning Up Your Hosting Account Recovering space and reducing clutter.WHAT TO REMOVEBackup archives you have downloaded Old site... Client Documentation Worth Keeping What to record per client.WHAT TO RECORDDomain and where it is registered, with renewal date... Clients, Servers and Connections Who asks and who answers.WHAT A CLIENT ISA device or program making a request.Your browser, your... Cloning a Database for Staging Making a copy to work on.WHYTesting updates, changes or development against real data without... Cloud Data and Integration: Everything That Matters, Briefly The summary.ASSUME MESSAGES ARRIVE TWICE AND OUT OF ORDERRecord what has been processed and check... Cloudflare Pages and Static Hosting Hosting a site at Cloudflare itself.WHAT IT ISHosting for static sites, built from a repository... Coding Safety Rules What to always do.BACK UP FIRSTBefore running anything generated against real data or a live... Common Architectural Mistakes What goes wrong.DISTRIBUTING A SYSTEM THAT DID NOT NEED ITAdding network calls, partial failure... Common Backup Mistakes The ones that leave people with nothing.STORING BACKUPS ON THE SAME SERVERLost in the same event... Common Database Mistakes What goes wrong.RUNNING UPDATE OR DELETE WITHOUT A WHERE CLAUSEChanges or removes every row. No... Common Mistakes Across Google Platforms What repeatedly goes wrong.NO BUDGET ALERTSDiscovering consumption through the bill.UNRESTRICTED... Common Mistakes With Installed Applications The ones that cause real problems.NULLED SOFTWAREThe most common cause of compromised sites we... Common PHP Security Failures What actually goes wrong.OUTDATED PHP OR DEPENDENCIESKnown vulnerabilities, publicly documented... Common Table Expressions and Query Structure Writing readable SQL.WHAT A COMMON TABLE EXPRESSION ISA named subquery defined before the main... Common VPS Mistakes The ones that cause real damage.NOT SECURING IT BEFORE GOING LIVEAutomated attacks find new... Comparing Plans Before You Buy Reading the specifications.WHAT THE NUMBERS MEANDisk space: how much you can store, including... Comparing Plans Before You Order Read plan comparisons for the figures that will actually constrain you.WHAT ACTUALLY... Comparing Two Databases Finding what differs.WHEN YOU NEED ITConfirming a migration copied everything Comparing staging... Compromises That Hide Themselves Why you might not notice.WHAT ATTACKERS DO TO AVOID DETECTIONShow the compromise only to search... Configuring a Firewall Controlling what can reach your server.THE PRINCIPLEDeny everything by default, then permit only... Configuring Database Access Connecting.WHAT TO SETThe connection type, host, database name, username and password.WHEREIn the... Configuring the Environment on Your Hosting Settings in production.WHAT TO CREATEThe environment file, on the server, from your example.WHAT... Connecting a Web Application to a Database Persistence.WHAT TO SET UPDatabase credentials in configuration, not code A connection approach... Connecting to MySQL from the Command Line Direct database access over SSH.CONNECTINGUse the mysql client with your database username and... Connections, Pooling and Resource Limits Managing finite resources.WHAT A CONNECTION POOL ISA set of database connections reused across... Control Panel Infrastructure The management layer.WHAT A CONTROL PANEL PROVIDESAccount provisioning File, database and mail... Control Panels for a VPS Whether to install one, and which.WITH A CONTROL PANELcPanel and WHM, or an alternative, gives... Controllers and Handling Requests Where request handling lives.WHAT A CONTROLLER DOESReceives a request, coordinates a... Creating a Database in cPanel The standard procedure.THE STEPScPanel > MySQL Databases.Under Create New Database, enter a... Creating a MySQL Database and User Most web applications need a database, a user, and that user granted access to it. All three... Creating a Staging Copy of Your WordPress Site A staging site is a private copy where you can test updates, new plugins or design changes... Creating a Staging Site on Your Hosting Testing on the server before production.WITH SOFTACULOUSFor WordPress, Softaculous >... Creating a Table When you need somewhere to put data.WHENA custom feature storing its own data An import needing a... Creating and Managing Database Users Accounts that access databases.WHAT A USER ISAn account permitted to connect to one or more... Creating and Managing Packages in WHM The technical side of your offering.WHAT A PACKAGE ISA template of limits applied when creating... Creating Your First Hosting Package in WHM A package is a template of limits. Create packages before creating accounts.CREATING ONEWHM >... Customising Your Shop Without Breaking It How to make changes that survive updates.USE A CHILD THEMEIf you edit theme files directly, the... Data Access With Entity Framework Core Working with databases.WHAT IT PROVIDESMapping between classes and database tables, with queries... Data Consistency Across Services The hardest problem.WHAT IS LOSTTransactions spanning services.WHYEach service has its own... Data Engineering Skills and Tools What the work requires.WHAT IS ESSENTIALSQL, thoroughly One programming language, usually Python... Data Ingestion Patterns How data arrives.WHAT THE PATTERNS AREFull extraction: reading everything each timeIncremental... Data Languages: Everything That Matters, Briefly The summary.R REMAINS BECAUSE ITS STATISTICAL ECOSYSTEM IS UNMATCHEDMany methods appear there... Data Persistence Frameworks Storing data locally.WHAT OPTIONS EXISTSimple preference storage, for small non-sensitive values... Database and Data Replication Keeping copies consistent.WHAT REPLICATION DOESMaintains copies of data on several systems.WHAT... Database and Eloquent: Everything That Matters, Briefly The summary.ON CPANEL, DATABASE AND USER NAMES ARE PREFIXED WITH YOUR ACCOUNT NAMEConfiguration... Database Backup Is Incomplete or Truncated A dump that stops partway.HOW TO TELLOpen the SQL file in a text editor and look at the end. A... Database Backups for Developers Protecting the data that cannot be regenerated.WHAT MAKES DATABASE BACKUPS DIFFERENTCode can be... Database Backups Versus Full Backups Knowing which you need.A DATABASE BACKUPThe content, settings, users and orders. Small, fast, and... Database Considerations When Changing Hosts What to plan for.BEFORE MOVINGNote the database version at both ends Note the character set and... Database Corruption and How to Handle It Tables in an inconsistent state.THE SYMPTOMSTables marked as crashed Errors when reading specific... Database Design for Backend Applications Structuring data.WHAT TO ESTABLISHWhat entities exist How they relate What must be unique What... Database Errors After an Update When an update leaves things inconsistent.WHAT HAPPENSMany updates change the database structure... Database Errors in Applications Connection and query failures.ERROR ESTABLISHING A DATABASE CONNECTIONThe credentials in the... Database is slow or queries timing out The database is the bottleneck.IDENTIFYING ITA profiling tool shows time spent in database... Database Limits on Your Plan What is allowed.WHAT IS TYPICALLY LIMITEDThe number of databases Total disk space, which... Database Maintenance Routine What to do and how often.MONTHLYCheck the database size in cPanel > MySQL Databases Clear... Database Naming and Organisation Conventions that help later.NAMING DATABASESDescriptive of the site or application: shop, blog,... Database Performance Making queries fast.WHAT TO MEASURE FIRSTWhich queries are slow, and how many run per... Database Terminology Explained The words you will encounter.TABLE: a collection of rows of one kindROW or RECORD: one itemCOLUMN... Database Was Modified by an Attacker Recovering from a compromise affecting data.WHAT IT LOOKS LIKESpam links injected into post... Databases and Storage: Everything That Matters, Briefly The summary.ROW STORAGE SUITS TRANSACTIONS; COLUMN STORAGE SUITS ANALYSISWhich is why a read... Databases for Web Applications Persistent storage.WHAT KINDS EXISTRelational, with structured tables and defined relationships... Databases on Shared Hosting MySQL and MariaDB databases are available on every plan, managed through cPanel.CREATING... Databases: Everything That Matters, Briefly The whole category in one page.WHAT A DATABASE ISThe half of your site holding content, settings,... Deactivating and Deleting Plugins Removing what you do not need.DEACTIVATE VERSUS DELETEDeactivating stops it running. The files... Decommissioning a VPS Safely Shutting down a server properly.BEFORE ANYTHING ELSETake a final full backup and verify it opens... Decommissioning an Old Application Retiring something you no longer use.BEFORE REMOVING ITExport anything you may need: content,... Dedicated IPs and Site Speed: No Effect A dedicated IP does not make a website faster.WHY NOTThe address is how traffic is routed to the... Defining Service Boundaries Where to divide.WHAT DETERMINES A GOOD BOUNDARYData ownership Rate of change Team ownership... Delivery and Caching: Everything That Matters, Briefly The summary.A LOW CACHE HIT RATE MEANS THE DELIVERY NETWORK IS ACHIEVING LITTLEQuery strings... Deploying and Releasing Changes Shipping without breaking things.WHAT TO AUTOMATEBuild Tests DeploymentWHYManual deployment is... Deploying Applications to Your VPS Getting code onto the server reliably.THE APPROACHESManual upload by SFTP. Simple, error-prone,... Deploying Changes Safely Updating a live application.WHAT TO PREPAREA tested change A backup of files and database A way... Deploying on cPanel: Everything That Matters, Briefly The summary.NEVER UPLOAD A LARAVEL PROJECT INTO THE PUBLIC DIRECTORY AS IT STANDSEverything... Deploying Web Applications Getting changes live.WHAT THE STEPS USUALLY AREBack up Deploy the code or artefact Install... Deploying Without Downtime Avoiding a broken site during deployment.THE PROBLEMA deployment that copies files one at a time... Designing a Deployment Process Making releases routine.WHAT A GOOD PROCESS ISRepeatable Automated, or precisely documented... Designing a SaaS Product Interface Usability for recurring work.WHAT DIFFERS FROM OTHER SOFTWAREUsers return repeatedly, so... Designing Data Storage Where information lives.WHAT TO ESTABLISHWhat data exists, and how it relates How it is read, and... Designing for Consistency Agreement across a system.WHAT STRONG CONSISTENCY MEANSEvery read returns the most recent... Designing for Scale Handling more load.WHAT TO ESTABLISH FIRSTWhat the actual load is, and where the limit is.WHYMost... Designing Systems That Scale Handling growth.WHAT VERTICAL SCALING ISA bigger machine.What it provides: simplicity, and no... Designing Your Database Structure Tables and relationships.WHAT TO ESTABLISHWhat things exist What each holds How they relateWHAT... Desktop Database Tools Working from your own machine.WHAT THEY AREApplications that connect to a database and provide a... Destination folder already exists Installing something that is partly there.WHAT IT MEANSWordPress tried to create a plugin or... Development Practices That Prevent Problems Habits that reduce the number of bad afternoons.VERSION CONTROL EVERYTHINGCode, configuration... Diagnosing a Slow Server Finding the actual bottleneck.START BY MEASURINGIs the server slow, or is the application slow?... Diagnosing Database Connection Problems Working through the causes.THE ERRORError establishing a database connection, or access denied,... Diagnosing Issues After a Migration The site worked before the move.THE COMMON CAUSESDatabase credentials not updated, or the cPanel... Directory and Listing Applications Sites where the content is entries.WHAT THEY AREBusiness directories, classified listings,... Disk quota exceeded The account is full.WHAT BREAKSUploads fail Mail stops being delivered Databases may become... Disk Space and Inode Management Disks fill silently and break everything at once.WHAT HAPPENS WHEN A DISK FILLSApplications... Distributed Ledgers and Their Uses Shared records without a central authority.WHAT A DISTRIBUTED LEDGER ISA record replicated across... Document Roots for Framework Projects A common misconfiguration.THE PROBLEMMany frameworks expect the web root to point at a public... Documenting What You Have Installed The record that makes maintenance possible.WHAT TO RECORDApplication name and versionWhere it is... Documenting Your Server Setup The thing nobody does until they wish they had.WHAT TO RECORDOperating system and version... Domain Modelling Representing the business.WHAT A DOMAIN MODEL ISCode representing the concepts and rules of the... Domain Privacy and ID Protection ID protection hides your personal details from the public WHOIS record.WHAT IT DOESReplaces your... Domain Privacy Protection WHOIS records for many extensions are publicly searchable, exposing the registrant's name,... Downloading Your Files Getting a copy.WHYA backup Migrating away Working locally Archiving a site you are retiringTHE... Drupal Database Notes Working with a Drupal installation.THE CONFIGURATIONsettings.php holds the database credentials,... Drupal: Common Problems Frequent issues and their causes.WHITE SCREENEnable error display temporarily in settings.php, or... Duplicate entry for key An insert violated a uniqueness constraint.WHAT IT MEANSThe code tried to insert a row with a... Error establishing a database connection The application could not reach its database.WHAT IT MEANSThe credentials are wrong, the user... Error Handling and Logging Knowing what went wrong.WHAT TO DISTINGUISHExpected failures: invalid input, not found, not... Errors and Testing: Everything That Matters, Briefly The summary.READ TRACEBACKS FROM THE BOTTOMThe last line states the error. Then find the last... Ethics and Governance of Biological Data Handling sensitive information.WHAT MAKES GENOMIC DATA DISTINCTIVEIt is identifying, permanently... Evaluating an Application Before You Commit Questions to ask.MAINTENANCEWhen was the last release? Is there active development? How quickly... Evaluating Blockchain Proposals Assessing whether it is warranted.WHAT TO ASK FIRSTWho are the participants? Do they trust each... Expired Auctions, Last Chance & Closeout Explained (ZillionkingHost Domain Marketplace)  Expired Auctions, Last Chance & Closeout Explained When a domain expires because it hasn't... Exporting a Database Taking a backup.THE PROCEDURESelect the database in the left panel.Export tab.Quick export, SQL... Exporting Only Part of a Database Taking specific tables or rows.WHYRecovering one table from a backup Moving specific data between... Fatal error: Call to undefined function The code called something that does not exist.WHAT IT MEANSA function was called, and PHP could... Fatal error: Maximum execution time exceeded The script ran longer than permitted.WHAT IT MEANSPHP stopped a script that exceeded its time... File Management: Everything That Matters, Briefly The whole category in one page.THE MOST IMPORTANT THING TO UNDERSTANDAnything in public_html is... Finding Backend Performance Problems Diagnosing slowness.WHAT TO ESTABLISH FIRSTWhich operation is slow, specifically Whether it is... Finding Mixed Content on Your Site Locating exactly what is insecure.THE BROWSER CONSOLEOpen the page, press F12, and read the... Finding Slow Queries Identifying what is actually slow.DURING A PAGE LOADA query monitoring plugin lists every query... Finding What Is Using Disk Space or Memory Diagnosing resource consumption.DISK SPACEdf -h shows usage by filesystem, which tells you... Finding Which Database Belongs to Which Site Untangling a multi-site account.THE RELIABLE METHODRead each site's configuration file.WordPress:... Finding Your Way Around the cPanel Interface cPanel groups every tool into sections. If you know the section, you will find the tool... Firebase: Everything That Matters, Briefly The summary.RULES ARE THE ONLY THING BETWEEN A USER AND ALL YOUR DATAClients talk to the database... Firestore Data Modelling Structuring document data.WHAT IT ISA document database, with collections containing documents,... Firestore Security Rules The critical configuration.WHAT THEY DODetermine what each client may read and write, evaluated... Firewall Rules Worth Having A practical baseline.THE DEFAULTDeny all incoming. Permit all outgoing, unless you have a reason... Firewalls and Access Control Controlling what reaches your server.THE PRINCIPLEDeny by default. Allow only what is needed.WHAT... Firewalls and Network Exposure What is reachable.THE PRINCIPLEAllow only what is needed, from where it is needed.WHAT TO... Fixing "Another Update Is Currently in Progress" WordPress sets a database lock while updating core and clears it when finished. An interrupted... Fixing "Error Establishing a Database Connection" WordPress cannot reach or authenticate to its database. There are four realistic causes. 1. Wrong... Fixing 502 and 504 Gateway Timeout Errors The web server waited too long for PHP to respond. The request was too slow, not necessarily... Fixing Mixed Content in Other Applications The principle is the same; the tools differ.THE APPROACHBack up the database.Identify where URLs... Fixing Mixed Content in WordPress The standard procedure.TAKE A BACKUP FIRSTA database search and replace cannot be undone.THE... Fixing Mixed Content Warnings A broken padlock on an HTTPS site means some resources are still being requested over plain... Fixing Mixed Content Warnings After Switching to HTTPS A "Not secure" warning or a broken padlock on an HTTPS site usually means some images, scripts or... Fixing the WordPress Site URL in the Database When you cannot reach the admin.WHEN YOU NEED THISAfter a migration, where the site redirects to... Form Builder Plugins Collecting information from visitors.WHAT TO LOOK FORReliable email delivery Spam protection... Forums and Community Software Running a discussion community.THE OPTIONSphpBB: free, mature, widely used, straightforward to... Foundations: Everything That Matters, Briefly The summary.A PIPELINE THAT RUNS SUCCESSFULLY AND PRODUCES WRONG NUMBERS IS WORSE THAN ONE THAT... Free Website Migration to ZillionKingHost We will move your existing website to us at no charge. For anything business-critical, this is... Freeing Up Disk Space on Your Hosting Account A full account breaks uploads, email delivery and database writes. Here is where the space... Geospatial Data Location in data pipelines.WHAT THE TYPES AREPoints: a single locationLines: routes and... Getting Help with Backups and Recovery What we can do.WHAT WE CAN HELP WITHRestoring a full account backup you have uploaded Restoring... Getting Help with Database Problems What we can do.WHAT WE CAN HELP WITHCreating databases and users Correcting ownership and... Getting SSH Access on Your Hosting Account Command line access to your hosting.AVAILABILITYSSH access is available on many plans. Check your... Getting Started With Laravel: Everything That Matters, Briefly The summary.WHAT THE FRAMEWORK BUYS YOURouting, database access, templating, authentication,... Getting Started with phpMyAdmin The interface explained.OPENING ITcPanel > phpMyAdmin. You are logged in automatically with... Getting Support for a VPS What we help with, and what is yours.WITH AN UNMANAGED VPSWe are responsible for the... Getting Support for Third-Party Applications Who helps with what.WHAT WE COVERServer configuration: PHP versions, extensions, limitsDatabase... Giving a Developer Access Safely Handing over your main cPanel login gives one person total control of every site, mailbox and... Giving Access to Contractors Temporary access.WHAT TO GIVEThe minimum needed for the work Their own account, not yours... Go and Rust: Everything That Matters, Briefly The summary.BOTH COMPILE TO BINARIES WITH NO RUNTIME TO INSTALLDeployment becomes copying one... Google Cloud Databases Managed data services.WHAT CLOUD SQL PROVIDESManaged relational databases, with backups,... Graph and Relationship Data Modelling connections.WHAT IT REPRESENTSEntities and the relationships between them.WHERE IT... Handing Over a VPS to Someone Else Transferring operational responsibility.WHAT THE NEW OWNER NEEDSDocumentation of what runs and... Handling a Client Who Wants to Leave The end of a relationship.FIRST, ASK WHYGenuinely. Sometimes it is a fixable problem nobody told... Handling a Database That Will Not Import When the dump refuses to load.THE COMMON CAUSESThe file exceeds the upload limit The import times... Handling Character Set and Encoding Problems Mangled characters after a move.THE SYMPTOMAccented characters, curly quotes and symbols... Handling Concurrency and Race Conditions Simultaneous requests.WHAT A RACE CONDITION ISTwo requests doing something at the same time,... Handling Database Changes in Version Control Schema as part of the code.THE PROBLEMCode is versioned. Databases are not, unless you make them... Handling Database Credentials Securely The most valuable secret in most applications.WHERE THEY BELONGIn environment configuration: a... Handling Errors Gracefully in Production What visitors see when something fails.THE RULESNever display technical errors to visitors. They... Handling Forms and User Input Safely Accepting submissions.WHAT TO VALIDATEEvery field Type, length, format and range Whether required... Handling High Traffic on Shared Hosting Getting the most from a constrained environment.THE PRINCIPLEServe as many requests as possible... Handling Scale and Performance Growing without degrading.WHAT DEGRADES FIRSTThe database, almost always.WHAT CAUSES ITQueries... Handling Sessions and State Where user state lives.DEFAULT BEHAVIOURPHP stores session data in files on the server by... Handling Too Many Connections Connection limits reached.WHAT IT MEANSThe limit on simultaneous connections was reached, and new... Health Checks Reporting whether a system works.WHAT A HEALTH CHECK ISAn endpoint reporting whether the... Helping Clients with WordPress Problems Most reseller clients run WordPress, and most of their problems are the same few.WHITE... Hiding Configuration and Sensitive Files Files that must never be publicly reachable.WHAT MUST NOT BE PUBLICConfiguration files containing... Hiding Sensitive Files from Public Access Anything inside public_html is reachable by anyone who guesses the URL, whether or not you linked... High server load or Load average warnings Reports of load on the server.WHAT IT MEANSThe server is busier than usual. Brief spikes are... Hosting a Static Site The simplest case.WHAT YOU NEEDHosting that serves files. Any plan.HOW TO PUBLISHUpload the files... Hosting and Infrastructure for SaaS Where the product runs.WHAT THE OPTIONS AREManaged platforms, handling deployment and scaling... Hosting More Than One Website on a Single Account If your plan permits multiple domains, you can run several completely separate websites from one... Hosting Multiple Sites on One Server Managing several.WHAT YOU NEEDWeb server configuration per site A separate database per site... Hosting Terms Explained Shared hosting, resellers, VPS and the rest.SHARED HOSTINGMany accounts on one server, sharing... How a PHP Request Is Handled The request lifecycle.WHAT HAPPENSA request arrives at the web server The server passes it to PHP... How Cloudflare Fits With Your Hosting Where each part does its work.THE PATH OF A REQUESTVisitor asks DNS where your site is Cloudflare... How Domain Offers Work (ZillionkingHost Domain Marketplace) How Domain Offers Work Some domain listings may not display a fixed price. Instead, the seller... How Languages Communicate Interoperability.WHAT OPTIONS EXISTNetwork APIs, over HTTP or another protocol Message queues... How Much Database Does Your Site Need Size, growth and limits.TYPICAL SIZESA small brochure site: a few megabytesA blog with several... How Often to Back Up Matching frequency to what you can afford to lose.THE QUESTION TO ASKIf you lost everything since... How to Back Up Your WordPress Site A WordPress site is two things: the files in public_html and the database. A usable backup... How to bid in a domain auction (ZillionkingHost Domain Marketplace) How Domain Auctions Work An auction runs until a fixed end time. The highest valid bid wins,... How to Buy CodeGuard Website Backup Automated off-site backups.WHAT IT DOESTakes automatic backups of your website files and... How to Buy If You Already Have a Website Elsewhere Moving to us.WHAT YOU NEED TO ESTABLISH FIRSTWhere the domain is registered, and whether you can... How to Buy Site and Server Monitoring Knowing when something is down.WHAT IT DOESChecks your site at intervals and alerts you when it... How to Clean a Compromised Site The proper process.THE PRINCIPLERemove the compromise and close the entry point.Doing only the... How to forward or redirect a domain to another website Domain forwarding sends anyone who visits one domain straight to another. It's the right tool... How to Install WordPress Manually (File Manager and phpMyAdmin) Manual installation is useful when you are restoring a specific WordPress version, installing... How to Install WordPress with Softaculous in cPanel Every ZillionKingHost hosting plan includes the Softaculous auto-installer, which sets up a... How to List a Domain for Sale (ZillionkingHost Domain Marketplace) How to List a Domain for Sale If you own or control an eligible domain, you can list it on the... How to manage DNS records (A, CNAME, MX, TXT) for your domain DNS records tell the internet where to send traffic for your domain. You can edit them from... How to Place a Backorder on a Domain (ZillionkingHost Domain Marketplace)  How to Place a Backorder on a Domain A domain backorder is a standing request asking... How to Tell If a Backup Is Complete Checking an archive before you rely on it.CHECK THE SIZECompare against what you expect. A... How VPS Resources Are Allocated Understanding what you are buying.CPUMeasured in cores or virtual cores. Your allocation is... How Your Hosting File Structure Works Where everything lives.YOUR HOME DIRECTORYThe top level of your account. Everything belongs to... How Your Website Connects to Its Database The configuration that makes it work.THE FOUR VALUESDatabase name Username Password HostAll four... How ZillionKingHost AI Works What happens when you send a message.THE SEQUENCEYour message, plus the conversation so far, is... HTTPS and Security Signals Encryption as a factor.WHY IT MATTERSBrowsers mark sites without HTTPS as not secure.Visitors see... I Deleted Files by Accident Recovering from a mistake.STOP FIRSTDo not continue working. Further changes make recovery harder... I Need Something from a Backup Months Ago Retrieving old content.WHAT PEOPLE NEEDA deleted page or post An old version of a document A... I Overwrote the Live Site with a Staging Copy A common and painful mistake.WHAT HAPPENEDA push-to-live operation, or a manual copy, replaced... Idempotency in Payment Systems Making retries safe.WHY IT MATTERS MORE HERE THAN ANYWHEREA repeated request can charge someone... Identity Verification Technology Establishing who someone actually is.WHAT IT DIFFERS FROMAuthentication, which proves a returning... Images Not Displaying Broken image placeholders.THE COMMON CAUSESURLs in the database still pointing at an old domain,... Implementing Caching in Your Application What to cache and how.THE CANDIDATESExpensive query results Rendered template fragments External... Implementing Search Finding records.WHAT SIMPLE SEARCH LOOKS LIKEMatching against columns with a pattern.WHY THAT IS... Import has exceeded the maximum execution time A database or content import stopped partway.WHAT IT MEANSThe import took longer than PHP permits... Importing a Database Restoring or migrating data.BEFORE IMPORTINGDrop the existing tables. Importing over existing... Importing and Exporting a Database Exporting produces a .sql file containing your entire database. Importing loads one back... Importing and Exporting Databases Efficiently Moving data without timeouts.EXPORTINGmysqldump produces a SQL file containing structure and... Incorrect datetime value or Data too long for column The data does not fit the column.WHAT IT MEANSAn insert or update supplied a value the column... Installing a Third-Party PHP Script Small utilities and custom tools.BEFORE INSTALLING ANYTHINGWhere did it come from? Only install... Installing and Securing a Database Server MySQL or MariaDB on your own machine.INSTALLINGInstall the package, then run the secure... Installing Applications Manually When Softaculous does not have it, or you want control.THE GENERAL PROCEDUREDownload the... Installing Applications with Softaculous Softaculous installs hundreds of web applications in a few clicks, creating the database and... Installing Laravel Getting a project started.WHAT YOU NEEDA supported PHP version Composer The required PHP... Installing PHP and Required Extensions Getting the application runtime in place.CHOOSING A VERSIONUse the newest version your... Integrating Python With Existing Systems Connecting things.WHAT THIS USUALLY MEANSMoving data between systems that do not talk to each... Integration Approaches How systems are connected.WHAT FILE TRANSFER MEANSExporting from one system and importing into... Integration Testing Verifying components together.WHAT IT VERIFIESThat components communicate correctly, with real... Interpreting Performance Results Understanding what you measured.WHAT TO ESTABLISH FIRSTWhether the system or the test was the... iOS Data Persistence Storing data on device.WHAT OPTIONS EXISTSimple preference storage, for small values Files in the... IP Geolocation and What It Means IP addresses are loosely associated with geographic locations in commercial databases.WHAT IT... Isolating Client Sites on a VPS Hosting for other people on a server you manage.WHY ISOLATION MATTERS MORE HEREYou are... Isolating Sites and Applications Preventing one compromise becoming several.THE PROBLEMIf every site on your server runs as the... Joomla Database Notes Working with a Joomla installation.THE CONFIGURATIONconfiguration.php holds the database name,... Joomla: Common Problems What goes wrong and how to fix it.BLANK PAGE OR 500 ERROREnable error reporting in... Joomla: Installation and First Steps A capable alternative to WordPress.INSTALLINGAvailable in Softaculous, or download from the... Keeping Records That Matter What to record and where.WHAT TO RECORDEvery sale: date, item, amount, customer, payment... Keeping Software Patched on a VPS The discipline that prevents most compromises.WHAT NEEDS PATCHINGThe operating system and its... Keeping Staging and Production in Step A staging environment only helps if it resembles production.WHAT MUST MATCHPHP version and... Keeping Track of Multiple Applications Managing several installations.THE PROBLEMThree applications across two domains, installed at... Keeping Your Site Fast Over Time Preventing regression.WHAT MAKES A SITE SLOW AGAINImages uploaded without preparation Plugins... Languages and Careers: Everything That Matters, Briefly The summary.RESEARCH JOB ADVERTISEMENTS IN YOUR OWN MARKETThey show real demand rather than what... Laravel and Framework Database Notes Application databases you or a developer built.MIGRATIONSLaravel and similar frameworks define... Late Fees and Reactivation Charges and timings are set out in our terms; this explains how they work in practice.LATE... Layered and Clean Architecture Separating concerns.WHAT LAYERING PROVIDESEach concern in one place, testable and... Load Balancing and High Availability Basics Keeping a service running when one machine fails.THE CONCEPTSLoad balancing distributes requests... Load Balancing Fundamentals Distributing traffic.WHAT IT DOESDistributes requests across several servers, and stops sending... Load Testing Backend Services Measuring capacity.WHAT IT ESTABLISHESHow much load the service handles before degrading Where... Log Files and What They Tell You Where the answers usually are.THE IMPORTANT LOGSWeb server access log: every request, with status... Logging In to WordPress and Resetting a Lost Admin Password Your WordPress dashboard is separate from cPanel and from your ZillionKingHost billing account.... Logging in Your Application Recording what happened, usefully.WHAT TO LOGErrors and exceptions, with a stack traceSignificant... Mailbox full or Quota exceeded A mailbox cannot accept more mail.IF IT IS YOUR MAILBOXcPanel > Email Accounts shows usage... Malware detected in your account A scanner found something.WHAT IT MEANSEither our server-side scanning or ImunifyAV identified... Managing a Large Product Catalogue Hundreds or thousands of products bring their own problems.WHAT GETS DIFFICULTAdmin pages slow to... Managing Background Workers Across Stacks Running work outside requests.WHAT EVERY STACK NEEDSA queue Worker processes consuming it A... Managing Configuration and Secrets Keeping settings out of code.WHAT COUNTS AS CONFIGURATIONDatabase details API keys File paths... Managing Database Changes Across Environments The hardest part of deployment.THE PROBLEMCode can be replaced wholesale. A database cannot,... Managing Database Changes During Deployment Schema and code together.THE PROBLEMCode and schema change together, but do not deploy... Managing Database Migrations in Deployment Schema changes safely.WHAT A MIGRATION ISA versioned, repeatable schema change, committed with... Managing Database Size and Growth Databases grow, and growth causes problems.WHAT GROWSLog and audit tables Revisions, in content... Managing Dependence on a Single Provider Portability and risk.WHAT CREATES DEPENDENCEProprietary services with no equivalent elsewhere... Managing Email Storage and Archiving Mail accumulates until it causes a problem, then it causes several at once.WHY IT MATTERSMail... Managing Environment Configuration Keeping settings out of your code.THE PRINCIPLECode is the same in every environment.... Managing Environment Variables Configuration for hosted applications.WHAT THEY AREValues available to your application from its... Managing Files Across Multiple Sites When you host several.KEEPING THEM SEPARATEEach site in its own directory Each with its own... Managing Files and Archives Efficiently Command line file work that saves real time.UPLOADING A SITEZip it locally, upload the single... Managing Form Spam You Already Receive Cleaning up.IF YOU ARE RECEIVING A LOTEnable a honeypot and time check first.That removes most of... Managing Game Content at Scale Organising large amounts of data.WHAT GAME DATA INCLUDESItem and character definitions Level and... Managing Keys and Secrets Protecting credentials to move money.WHAT SECRETS EXIST IN PAYMENT SYSTEMSProvider interface keys... Managing Many Domains in One Account Keeping track.WHAT TO DOCUMENTEvery domain on the accountIts type: main, addon, subdomain,... Managing Memory and Swap The resource that most often causes trouble.WHY MEMORY MATTERS MOSTWhen memory is exhausted, the... Managing Network Security in a Facility Protecting connectivity.WHAT TO SEPARATECustomer networks from each other Management networks... Managing Privileged Access Administrative rights.THE PRINCIPLEThe minimum access necessary, for the shortest time... Managing Secrets in Google Cloud Credentials and keys.WHAT THE SECRET MANAGER PROVIDESStorage for secrets, with versioning, access... Managing Secrets Properly Credentials and keys.WHAT COUNTSPasswords API keys Certificates and private keys Database... Managing Server Credentials Safely Who holds what, and how.WHAT EXISTS ON A VPSRoot password SSH private keys Control panel... Managing Server Updates Keeping systems current.WHY IT MATTERS MOSTKnown vulnerabilities are published and scanned for... Matomo and Self-Hosted Analytics Analytics you control.WHY SELF-HOSTData stays on your own hosting rather than with a third party,... Measuring Your Site Speed Properly Speed testing is easy to misread, and people frequently optimise the wrong thing as a result.THE... Merging Data Between Two Databases Combining content from two sites.WHEN THIS ARISESConsolidating two sites into one Recovering... Microservices: Everything That Matters, Briefly The summary.THEY TRADE ONE SIMPLE PROBLEM FOR SEVERAL HARDER ONESNetwork calls where there were... Migrating a Client's Site to Your Hosting The work that wins the client.BEFORE STARTINGGet access to the current hosting, or a full backup... Migrating a Custom Application Moving something you built yourself.WHAT TO MOVEApplication code The database Uploaded files and... Migrating a Database Between Hosts Moving data without losing any.THE PROCEDUREExport the source database with mysqldump, or... Migrating a Database to Another Server Moving between hosts or accounts.THE PROCEDUREExport from the source, using the command line for... Migrating a Website Yourself If you would rather do it yourself, the process is straightforward.1. TAKE A COMPLETE COPYFrom... Migrating a WordPress Site The most common migration.TWO APPROACHESA migration plugin, which handles most of it Manual... Migrating an Application to New Hosting Moving installed software.THE GENERAL PROCEDUREArchive the application files and download... Migrating an Existing WordPress Site to ZillionKingHost You can move an existing site to us yourself in under an hour, or request our free migration... Migrating an Online Store to New Hosting Shops need more care than brochure sites, because the database changes constantly.THE... Migrating Customers Between Servers Moving accounts without disruption.WHY IT HAPPENSHardware replacement Rebalancing load Upgrading... Migrating From a Non-cPanel Host When the control panels differ.WHAT CHANGESNo single backup file carries everything.Each part... Migrating From Another cPanel Host The simplest case.WHY IT IS SIMplerBoth ends use the same control panel and the same backup... Migrating to a New VPS Moving from one server to another.PLANNINGBuild the new server fully before touching the old one... Migrating to HTTPS Without Losing Rankings The procedure that preserves search position.BEFORETake a full backup Note your current rankings... Migrating Without Downtime Downtime during a move is avoidable with sequencing rather than luck.THE PRINCIPLENever take... Migration: Everything That Matters, Briefly The whole category in one page.THE THREE THINGS THAT DETERMINE SUCCESSRegistrar access. Without... Minimising Downtime During a Release Minimising interruption.WHAT CAUSES DOWNTIMEFiles being replaced while requests arrive Database... Mixed Content After a Site Migration A common post-migration symptom.WHY IT HAPPENSThe database was copied from a site running on a... Mixed Content in CSS and JavaScript Files Harder to find because the URL is inside a file rather than in the database.HOW IT HAPPENSA... Mobile Application Security Fundamentals What is different on a device.WHAT TO ASSUMEThe device may be compromised or rooted The... Modifying an Existing Client Account Limits, packages and details can be changed at any time without recreating the account.CHANGING... Money Movement: Everything That Matters, Briefly The summary.NEVER USE FLOATING POINT FOR MONEYUse integers in the smallest unit or a decimal... Monitoring a Hosting Fleet Watching many machines.WHAT TO MONITOR PER MACHINEAvailability, from outside Load, memory,... Monitoring a Shop Knowing when something is wrong.WHAT TO MONITORThat the site responds That the checkout works... Monitoring Application Performance Knowing how the site actually performs.WHAT TO MEASUREServer response time, which reflects your... Monitoring Client Sites Knowing before they tell you.WHAT TO MONITORWhether each site responds Whether it responds... Monitoring Database Growth Over Time Spotting problems before they matter.WHAT TO RECORDTotal database size, monthly The size of the... Monitoring Database Health Noticing problems early.WHAT TO WATCHTotal size, and its growth rate The largest tables Query... Monitoring Scheduled Tasks Knowing when they stop.THE PROBLEMCron failures are silent. Nothing announces that a job stopped... Monitoring Your Server Knowing when something is wrong.WHAT TO MONITORWhether the server responds Whether your sites... Monitoring Your VPS Knowing the state of your server before someone else tells you.WHAT TO MONITORAvailability: is... Moodle: Setup and Requirements The established learning platform.BEFORE INSTALLINGCheck requirements carefully. Moodle needs... Moving a Legacy Application to Laravel Migration strategy.WHAT NOT TO DORewrite everything and switch over in one step.WHYIt takes... Moving a Site Between Domains Updating the database for a new address.THE STEPSBack up the database.Update the site URL... Moving a WordPress Site to a New Domain Name Changing domain means updating the URLs stored throughout the database, not just the files. 1.... Moving From a VPS Back to Shared Hosting Sometimes the right decision.WHEN IT MAKES SENSEThe maintenance burden exceeds the benefit You... Moving WordPress from a Subfolder to the Root Domain If you installed into a folder such as /wp and your site now loads at yourdomain.com/wp, here is... Multi-Tenant Architecture Serving many customers from one system.WHAT MULTI-TENANCY MEANSOne running system serving many... Multilingual Plugins and Tools Serving more than one language.WHAT THEY DOLet you maintain content in several languages, with a... My Database Was Corrupted or Emptied Data loss without file loss.WHAT YOU SEEError establishing a database connection Missing content... My Site Was Hacked Recovering from a compromise.THE ORDEROpen a ticket so we can check the account server-side.Take... MySQL and MariaDB Explained The two names you will see.WHAT THEY AREDatabase server software. Your application connects to it... MySQL server has gone away The connection was lost mid-query.WHAT IT MEANSThe database closed the connection while the... Nameserver Changes and What They Affect Understanding the consequence.WHAT CHANGESWhich servers answer DNS questions for your... Network Attached Storage Storage served over a network.WHAT IT ISStorage presented as file shares over a network.WHAT... NoSQL Stores in Data Engineering Non-relational systems.WHAT THE CATEGORIES AREKey-value: fast lookup by identifierDocument:... Object Caching and Database Caching Advanced caching.WHAT IT DOESStores the results of database queries so they are not repeated.WHEN... Object Caching and Its Effect on Databases Reducing repeated queries.WHAT IT ISStoring the results of database queries in memory, so... Offboarding a Client Properly The process at the end.WHAT TO DOConfirm the leaving date in writingProvide a full backup: files,... Offering Performance Optimisation Selling speed as a service.WHAT IT INVOLVESMeasuring the current state Enabling and configuring... Offering Staging Environments Selling safety.WHAT IT ISA copy of a client's site where changes can be tested before going... Offline Support and Synchronisation Working without a connection.WHAT LEVELS OF SUPPORT EXISTRead-only: previously retrieved data... OpenCart: Setup Notes A lighter shop platform.WHO IT SUITSShops wanting something simpler than PrestaShop or Magento,... Optimising Database Access The usual bottleneck.WHAT TO FIND FIRSTSlow queries, from the database's own reporting.WHAT TO... Optimising Laravel for Production Performance settings.WHAT TO CACHEConfiguration Routes Events Compiled templatesWHYIt removes... Ordering Website Migration Migration from your previous host is free. Request it rather than doing it yourself for anything... Our Backup Policy and What It Covers We take server-side backups of hosting accounts, and you should also take your own. Both matter,... Out of Memory Errors and Process Kills When the kernel starts killing things.WHAT HAPPENSWhen memory is exhausted, the kernel selects a... Out of stock when the item is in stock Availability showing incorrectly.THE COMMON CAUSESStock management enabled with a quantity of... Partial Data Loss After a Restore Some things came back and others did not.WHAT USUALLY HAPPENSFiles restored, database not, or the... Performance and Operations: Everything That Matters, Briefly The summary.MEASURE THE DISTRIBUTION, NOT THE AVERAGEAverages conceal the experience of the... Performance and Resource Constraints Working within limits.WHAT MATTERS MOSTStartup time Responsiveness to touch Memory use Battery... Performance for Membership and Course Sites Speed with logged-in users.THE CACHING PROBLEMLogged-in pages are usually not cached.Members... Performance of Multilingual Sites The added weight.WHY THEY ARE SLOWERMultilingual plugins add queries to every request More... Performance Terms Speed and delivery.PAGE LOAD TIMEHow long a page takes to become usable.CACHINGStoring generated... PHP and Laravel: Everything That Matters, Briefly The whole category in one page.RUN A SUPPORTED PHP VERSION AND A SUPPORTED FRAMEWORK... PHP Extensions Additional functionality.WHAT THEY AREModules adding capability: image processing, encryption,... PHP Security: Everything That Matters, Briefly The summary.PARAMETERISE EVERY QUERYWithout exception. Dynamic column and table names cannot be... phpBB: Setup and Running a Forum The established free forum platform.INSTALLINGAvailable in Softaculous, or manually from the... phpMyAdmin Settings Worth Changing Making the tool more usable.WHEREThe Settings link on the phpMyAdmin home page.WORTH ADJUSTINGThe... Planning an HTTPS Rollout for a Large Site When a site has thousands of pages and real traffic.BEFORETake a full backup and verify it Record... Playbook: I Cannot Log In Access problems.ESTABLISH FIRSTLog in to what: cPanel, their site, email, or your billing... Playbook: Migration Requests Bringing a site in.ESTABLISH FIRSTWhere it is now What it is built on Whether they have access to... Plugins and Site Speed The performance cost.HOW PLUGINS SLOW A SITELoading scripts and styles on every page, including... Plugins Most Sites Actually Need A realistic list.WHAT ALMOST EVERY SITE NEEDSCaching Backups A security or firewall plugin An SEO... Plugins to Be Careful With Where problems come from.STATISTICS PLUGINSRecording every visit to your own database turns every... Port Forwarding and Exposing Services Making something reachable.WHAT IT ISConfiguring your router to send inbound connections on a... Preparing a Laravel Application for Shared Hosting What to establish first.WHAT TO CHECKThe PHP version available, against the framework's... Preparing Your Site for a Traffic Increase Before the traffic arrives.WHY THIS MATTERSSuccessful SEO, a campaign, or media coverage produces... Preparing Your Site for Migration Cleaning up first.WHY BOTHERMoving a bloated site moves the bloat.A migration is a natural point... Preventing Cross-Site Scripting Content interpreted as code.WHAT IT ISSubmitted content displayed in a page and executed by the... Preventing Data Leakage Between Customers The failure that ends businesses.WHY IT IS CATASTROPHICIt is a breach, it is reportable, and... Preventing Injection Attacks Input interpreted as instruction.WHAT INJECTION ISInput interpreted as part of a command rather... Preventing Injection in Server Code Input treated as instruction.WHERE IT OCCURSDatabase queries Operating system commands Template... Preventing Payment Manipulation Stopping tampering with transactions.WHAT ATTACKERS ATTEMPTChanging the amount Changing the... Preventing Problems Before They Happen Habits that avoid trouble.BUILD A STYLE BRIEFPaste it into every writing request.Solves tone,... Preventing Scripting Attacks in the Browser Content executed in the browser.WHAT IT ISSubmitted content rendered into a page and executed by... Preventing SQL Injection The most serious database vulnerability.WHAT IT ISAn attacker supplying input that becomes part... Preventing SQL Injection in PHP The most damaging vulnerability.WHAT IT ISUser input interpreted as part of a database query.WHAT... Previewing Your Site Before the Domain Points Here You do not have to wait for DNS to start building. There are two ways to reach the site... Profiling Slow Code Finding where time is actually spent.MEASURE BEFORE OPTIMISINGAssumptions about what is slow are... Protecting Against Brute-Force Attacks Automated password guessing against every exposed service.WHAT IS TARGETEDSSH, control panel... Protecting Against Common Server Attacks What actually happens.BRUTE FORCE ON REMOTE ACCESSContinuous automated password guessing.Defeated... Protecting Configuration and Credentials Secrets.WHAT COUNTSDatabase credentials API keys Encryption keys Mail credentials Anything... Protecting Configuration Files Files containing credentials.WHAT THEY AREwp-config.php for WordPress Similar files for other... Protecting Customer Data Obligations and practicalities.WHAT YOU HOLDNames, phone numbers, addresses, order history, email... Protecting Customer Data on Your Website If your site collects names, emails, phone numbers or orders, you are responsible for looking... Protocols and Ports: Everything That Matters, Briefly The summary.WHAT A PORT IS FOROne address, many services. The port says which service a... Public, Private and Permissioned Networks Who may participate.WHAT A PUBLIC NETWORK ISOpen to anyone to join, read, transact and... Python: Everything That Matters, Briefly The whole category in one page.SET UP EVERY PROJECT THE SAME WAYPython 3, a virtual environment,... Query and Configuration Languages Declarative tools.WHAT SQL ISA declarative language for querying and manipulating relational... Queues and Background Work Deferring slow operations.WHAT A QUEUE DOESAccepts work now, performs it later, outside the... Ransomware or Destructive Attack When data is deliberately destroyed or encrypted.WHAT IT LOOKS LIKEFiles encrypted or replaced A... Reactivating a Suspended Service Suspension is reversible. Nothing is deleted at suspension.IF IT IS NON-PAYMENTPay the... Reading an EXPLAIN Result Understanding how a query will run.WHAT IT DOESPrefix any SELECT with EXPLAIN and the database... Real Estate and Property Listing Sites A common Nigerian use case.WHAT IT INVOLVESProperty listings with many images Search and... Recovering a Deleted Database When it is gone.FIRSTStop. Do not create a new database with the same name, which complicates... Recovering a Single Deleted Row Getting one record back.THE SITUATIONOne post, one order, one customer deleted in error. The rest... Recovering a Site from Web Archives When there is genuinely no backup.WHAT IS AVAILABLEPublic archive services crawl and store copies... Recovering a Site You Cannot Log Into Regaining access without the admin interface.FOR WORDPRESSWP-CLI creates a user, resets a... Recovering a Store After a Problem When something has gone badly wrong.FIRST, STOP THE DAMAGEIf checkout is broken, say so on the... Recovering After a Failed Server Migration When a move between servers went wrong.THE SITUATIONFiles or data did not transfer completely, or... Recovering an Application from Backup Restoring after something went wrong.BEFORE RESTORINGTake a copy of the current state. It may... Recovering Data Left on the Old Host Before it disappears.WHAT TO CHECK BEFORE CANCELLINGEmail received during propagation Form... Recovering From a Compromised VPS The hardest situation to handle well.IMMEDIATE ACTIONSIsolate the server. Restrict network... Reducing Database Load Fewer and lighter queries.WHAT ADDS QUERIESEach plugin Related posts and recommendations... Reducing Database Queries Per Request The most common performance problem in web applications.THE CLASSIC MISTAKEA loop that queries... Reducing High CPU and Resource Usage on Your Account If your site is throttled, returns 508 errors, or you receive a resource limit notice from us,... Reducing the Number of Applications You Run Consolidation as maintenance.WHY IT HELPSEvery application is updates to apply, backups to... Reducing the Number of Plugins Every addition costs something.THE PROBLEMEach plugin loads code, styles, scripts and database... Reducing the Number of Queries Per Page Fewer requests to the database.WHY IT MATTERSEach query has overhead. A page running four hundred... Redundancy for Hosting Services Removing single points of failure.WHAT TO IDENTIFYEvery component whose failure affects... Reference: Laravel Problems and Where to Look Quick lookup.BLANK PAGEApplication log, then server error log.CHANGES NOT APPEARINGConfiguration... Reference: PHP and Laravel Terms Vocabulary.COMPOSERThe dependency manager for PHP.AUTOLOADINGLoading classes automatically when... Reference: Python Terms Explained Vocabulary.INTERPRETERThe program that runs Python code.MODULEA Python file whose contents can be... Remote Database Access Connecting from outside the server.WHAT IT ISPermitting a connection to your database from an... Removing a Subdomain or Addon Domain Taking one down properly.BEFORE REMOVING ANYTHINGBack up the site and its database.Removing a... Removing an Application Safely Uninstalling properly.WHY IT MATTERSAn abandoned installation is unpatched software sitting on... Renaming or Removing a Database Changing what exists.RENAMINGcPanel offers a rename function under MySQL Databases.It works, and... Reporting and Analytics in ERP Getting information out.WHAT STANDARD REPORTS PROVIDEFinancial statements Ageing of receivables... Reporting and Dashboards for Customers Showing them their own data.WHAT CUSTOMERS WANTAnswers to specific questions they already... Requesting a Free Website Migration We move your existing site to us at no charge. For anything business-critical, use this rather... Researching for Academic Work Finding and using sources.THE CITATION WARNINGAsk for sources and you receive references that... Reseller Account Security Protecting what you are responsible for.WHY IT MATTERS MORE FOR YOUA compromise of your reseller... Resetting a WordPress Password in the Database Regaining access when locked out.WHEN YOU NEED ITThe password reset email does not arrive,... Resource Isolation on Shared Servers Keeping customers apart.WHAT TO LIMIT PER ACCOUNTProcessor time Memory Concurrent processes... Restarting Services Safely Knowing what a restart does before you do it.RELOAD VERSUS RESTARTReload re-reads configuration... Restoring a Client Account from Backup Restores are usually urgent, so know the routes before you need them.FROM JETBACKUPAvailable from... Restoring a Database The restore that matters most.FROM JETBACKUPcPanel > JetBackup > Database Backups. Select... Restoring a Database from Backup Getting data back.BEFORE RESTORINGTake a copy of the current state. It contains everything added... Restoring a Full Account Backup The complete restore.THE RESTRICTIONYou cannot restore a full cPanel account backup yourself... Restoring Files and Databases with JetBackup JetBackup holds scheduled server-side backups of your account and lets you restore them... Restoring Files from a Backup Getting the website files back.FROM JETBACKUPcPanel > JetBackup > File Backups. Select a... Restoring from a Backup The method depends on where the backup came from.JETBACKUPcPanel > JetBackup. Choose File... Restoring From Backup The part people practise least and need most.BEFORE RESTORINGUnderstand what will be lost.... Restoring Is Taking Too Long When recovery is slower than you can afford.WHY IT MATTERSRecovery time is part of your plan. A... Restoring Only Part of a Site Selective recovery.WHY IT IS USUALLY BETTERRestoring everything rolls back everything. If one... Restoring to a Different Server or Host Recovery elsewhere.WHEN THIS APPLIESMoving hosts Recovering after losing access to the original... Restoring Your WordPress Site from a Backup Restoring reverses the backup method you used. Take a fresh copy of the current broken state... Reviewing Your Backup Arrangement Annually An hour once a year.WHAT TO CHECKAre backups actually running, with recent files in the storageDo... Revoking Access When Staff or Contractors Leave Old credentials that were never revoked are a frequent route into hosting accounts, sometimes... Rolling Back a Bad Release Returning to a working state.WHY IT MATTERSFixing forward under pressure produces further... Rolling Back a Deployment Undoing a change that broke something.WITH GITChecking out the previous commit restores the... Ruby as a Language Characteristics and use.WHAT IT ISA dynamically typed, interpreted, object-oriented language... Running Containers in Development Consistent local environments.WHAT IT SOLVESEvery developer running the same versions of... Running Custom PHP Code Safely Code you or a developer wrote.THE ESSENTIALSParameterise every database query. Never concatenate... Running Databases for Multiple Applications Keeping applications separated.THE PRINCIPLEOne database and one database user per application,... Running Dovecot Mail storage and access.WHAT IT ISA server providing mail access, with mailbox storage and... Running Long Tasks Without Losing Them Preventing a dropped connection killing a running job.THE PROBLEMA large database import, a long... Running Multiple Applications on One Account Several pieces of software, one hosting plan.WHAT TO PLANEach application needs its own database... Running Postfix A widely used transfer agent.WHAT IT ISA modular transfer agent, designed for security and... Running PowerDNS A database-backed nameserver.WHAT DISTINGUISHES ITSeparation of the authoritative server, the... Running SQL Queries Safely Using the SQL tab without breaking things.THE DISCIPLINEWrite a SELECT first, with the same WHERE... Running Tests in Parallel Reducing suite duration.WHY IT IS NECESSARYSuites grow, and duration determines how often they... Scaling a Hosting Platform Growing the infrastructure.WHAT CONSTRAINS GROWTH FIRSTStorage performance, usually.WHAT ELSE... Scaling a Laravel Application Handling growth.WHAT TO DO FIRSTMeasure.Establish which pages are slow and why.WHAT USUALLY HELPS... Scaling a Server When one is not enough.THE SIGNSConsistently high resource use Slowness under load rather than... Scaling Your Store as It Grows What breaks first, and in what order.WHAT BREAKS AS TRAFFIC GROWSResource limits at peak times,... Scaling Your VPS Adding capacity when you genuinely need it.BEFORE SCALINGConfirm the constraint. Adding CPU when... Scheduled Database Maintenance with Cron Automating cleanup.WHAT TO AUTOMATEClearing expired transients Removing old revisions Deleting... Search and Detection: Everything That Matters, Briefly The summary.QUERY TERMS MUST BE ANALYSED IDENTICALLY TO INDEXED TERMSOtherwise nothing matches,... Search and Replace in a Database Changing values across many rows.WHEN YOU NEED ITAfter a domain change After moving from http to... Search on a Static Site Finding content without a database.THE PROBLEMSearch normally queries a database.THE OPTIONSA... Search Within a Product Helping users find their own data.WHY IT MATTERS MORE AS ACCOUNTS GROWNavigation works at small... Searching for Academic Sources Finding material.WHERE TO SEARCHAcademic databases and indexes Your institution's library Open... Secure Coding Basics for Custom Websites If your site is custom-built rather than a packaged application, these are the issues that... Securing a Laravel or Custom PHP Application Frameworks are secure by default in most respects, but deployment mistakes undo that.DOCUMENT... Securing an Online Store Shops are a higher-value target than ordinary websites.WHY THEY ARE TARGETEDThey process... Securing Data in Transit and at Rest Protecting information.WHAT TO USE FOR EVERY CONNECTIONEncryption, throughout, without... Securing Your Database Practical protection.THE ESSENTIALSA strong generated password, different for every database user... Securing Your Web Applications on a VPS The server is only as secure as what runs on it.WHY THIS MATTERS MORE ON A VPSOn shared hosting,... Securing Your Website and Hosting Accounts The business presence.WHAT TO PROTECTYour hosting account Your domain registrar account Your site... Security Considerations for AI Tools A newer category of risk.WHAT TO UNDERSTANDInformation you put into a tool leaves your... Security of Static Sites Less to attack.WHY THEY ARE SAFERNo database No application processing input No plugins to become... Seeding and Test Data Populating a database.WHAT SEEDING ISFilling a database with data, programmatically.WHAT IT IS... Selecting a Backend Stack Making the decision.WHAT TO ASSESSWhat the application actually requires What the team knows What... Sending Backups to Cloud Storage Getting copies off the server automatically.THE OPTIONSGoogle Drive, Dropbox, OneDrive, or object... Separating Logic From Presentation Structure that scales.THE PROBLEMPHP allows mixing logic and markup freely.WHAT THAT... Server Migrations: What to Expect Occasionally we move accounts between servers, for hardware replacement, load balancing or... Server Ports and Firewall Rules What is open on a server.WHAT IS TYPICALLY OPENWeb ports Mail ports Control panel ports Secure... Servers and Provisioning: Everything That Matters, Briefly The summary.SECURE ACCESS BEFORE ANYTHING ELSEA new server is scanned within minutes of... Servers and VPS: Everything That Matters, Briefly The whole category in one page.BEFORE BUYING ONEName the specific thing you cannot do on shared... Setting Account Quotas and Limits Limits protect your allocation and, more importantly, protect your clients from each other.WHERE... Setting Up a Development Subdomain Building before launch.WHYBuilding a new site while the old one remains live.HOWA subdomain,... Setting Up a Local Development Environment Working on your own machine.THE OPTIONSA packaged stack such as XAMPP, MAMP or Laragon, which... Setting Up a Staging or Development Site Test changes somewhere other than the live site. This is the cheapest insurance available.THE... Setting Up a Staging Site A copy for testing.WHYTesting changes on a live site is how sites break publicly.HOWCreate a... Setting Up Backups Today: A Practical Start For anyone with nothing in place.THIRTY MINUTES, IN ORDERcPanel > Backup > Download a Full... Setting Up Product Filtering and Search Making a large catalogue navigable.WHY THE DEFAULT IS NOT ENOUGHWordPress search matches titles... Setting Up Remote MySQL Access By default the database only accepts connections from the server itself. Remote MySQL allows a... Setting Up Staging on Your VPS Testing before production.THE OPTIONSA subdomain on the same server, with its own document root,... Settlement, Payouts and Cash Flow When the money actually arrives.HOW IT WORKSA customer pays. The gateway holds the funds, deducts... Shared Hosting Architecture How shared hosting is built.WHAT IT ISMany customers' sites served from one machine, isolated... Shared IP Addresses Explained By default your account uses an IP address shared with other accounts on the same server.HOW IT... Sharing Data Between an Application and Its Extensions Crossing the process boundary.WHAT THE PROBLEM ISEach has its own container, and cannot see the... Site is slow but no error appears Working, and too slowly.MEASURE FIRSTLoad a plain static file. If that is fast while pages are... Site works but images and links point to the old domain URLs still referencing the previous address.WHAT IT MEANSAbsolute URLs stored in the database... Skills for Testing Work What the role requires.WHAT IS FOUNDATIONALAnalytical thinking Clear written communication... Snapshots Versus File Backups Two different tools for different situations.SNAPSHOTSA point-in-time image of the entire server.... Softaculous installation failed The one-click installer did not complete.THE COMMON CAUSESThe target directory already contains... Someone Deleted Content and I Need It Back Recovering individual items rather than the whole site.FIRST, CHECK THE APPLICATIONMany... Sorry, you are not allowed to access this page A permissions error inside WordPress.WHAT IT MEANSYour user account does not have the capability... Splitting a Large Database Export When the file is too big to handle.WHEN THIS ARISESA database too large for phpMyAdmin's upload... SQL Beyond the Basics What separates competent from capable.WHAT MOST PEOPLE KNOWSelecting, filtering, sorting, and... SSL Checklist After a Migration Certificates need attention whenever a site moves.IMMEDIATELY AFTER THE MOVEConfirm the domain... Static Site Generators and Static Hosting Sites with no application at all.WHAT THEY ARETools that build plain HTML files from templates... Static, WordPress or Framework: Which Do You Need? Choosing honestly.CHOOSE STATIC WHENThe content changes rarely You do not need accounts or a... Storage Area Networks Block storage over a network.WHAT IT ISStorage presented as block devices, as though locally... Storage Engines: InnoDB and MyISAM The two you will encounter.WHAT THEY AREThe mechanism a table uses to store and retrieve data.... Storage Systems and Shared Storage Storage beyond the server.WHAT SHARED STORAGE ISStorage accessible by several servers, rather... Store Slow Only at Checkout Browsing is fast, checkout is slow. A specific problem with a specific cause.WHY IT HAPPENSCart... Storing and Deleting Form Data Managing what accumulates.WHAT ACCUMULATESEvery submission, indefinitely, unless you remove... Storing Customer Data Securely Practical protection.THE MEASURESHTTPS across the whole site Strong unique passwords and... Storing Data in the Browser Client-side persistence.WHAT OPTIONS EXISTSimple key and value storage, persisting indefinitely... Storing Data Securely on Device Protecting local information.WHAT TO STORE IN SECURE STORAGEAuthentication tokens Credentials... Storing Form Submissions Not relying on email alone.WHY IT MATTERSEmail fails. Spam filters catch things. Mailboxes... Storing Time-Series Data Where readings live.WHAT MAKES THIS DATA DISTINCTIVEIt is append-only It is queried by time range... Structuring Backend Code Organisation that lasts.WHAT THE COMMON LAYERS ARERouting, mapping addresses to handlers... Structuring Larger Programs Beyond a single file.WHEN TO SPLITWhen a file becomes hard to navigate When parts are reusable... Subdomains and Addon Domains: Everything That Matters, Briefly The whole category in one page.THE DISTINCTIONAddon domain and subdomain: separate content,... Supported PHP Versions and Extensions We run multiple PHP versions side by side, selectable per domain.CHOOSING A VERSIONcPanel >... Suspending and Unsuspending Client Accounts Suspension takes an account offline without deleting anything, which makes it the right tool for... Symptom: Cannot Log In to the Site Administration access lost.WHAT TO ESTABLISHIs the password wrong, or is the page failing?FOR A... Symptom: Error Establishing a Database Connection The site cannot reach its database.WHAT IT MEANSThe application cannot connect to the... Symptom: Files or Data Missing Something is gone.WHAT TO ESTABLISHWhat is missing, and when it was last seen Who has access What... Symptom: Images Not Displaying Broken image placeholders.WHAT TO CHECKWhether the file exists at the path requested Whether the... Symptom: Layout Broken or Unstyled The page appears as plain text.WHAT IT MEANSThe CSS is not loading.THE COMMON CAUSESA mixed... Symptom: The Site Is Very Slow Loading takes too long.WHAT TO ESTABLISHSlow for everyone, or only for you? All pages or specific... Syncing a Database Between Environments Moving data safely in the right direction.THE SAFE DIRECTIONProduction to staging or local. This... System Design: Everything That Matters, Briefly The summary.ESTABLISH REQUIREMENTS AND MAGNITUDES BEFORE PROPOSING A DESIGNRough numbers are what... Systems Languages: Everything That Matters, Briefly The summary.C IS WHAT OTHER LANGUAGES HIDEOperating systems, runtimes and databases are built on... Table doesn't exist A table is missing from the database.WHAT IT MEANSThe database exists and connects, but a table... Table is marked as crashed A table needs repair.WHAT IT MEANSThe table was left in an inconsistent state, usually by an... Taking a Backup from cPanel Take your own backup before any significant change. Do not rely solely on ours.FULL ACCOUNT... Taking a Full cPanel Account Backup The most complete backup available to you.HOWcPanel > Backup.Under Full Backup, click Download... Taking Over an Existing PHP Application Inheriting code.WHAT TO ESTABLISH FIRSTWhat it doesWhat it runs on: PHP version, framework,... Taking Partial Backups You Can Restore Yourself More practical for day-to-day use.WHAT THEY ARESeparate downloads of the home directory and of... Taking Your Own Backups Take one before every update, migration or significant change. It takes two minutes and has saved... Tax and Record Keeping for Online Businesses Keeping the records you will need.WHY IT MATTERSOnline sales are business income. Records are... Telling the Difference Between a Site Problem and a Server Problem Most outages are site-level. Knowing which you are facing saves a great deal of time.SIGNS IT IS... Templates and Producing Pages Generating output.WHAT A TEMPLATE ISA page with placeholders, filled with values when... Terminating a Client Account Termination removes the account and all its data permanently. Treat it as final, because it... Test Doubles and Isolation Substituting dependencies.WHAT THE TYPES AREDummies, passed but unused Stubs, returning fixed... Testing .NET Applications Verification practices.WHAT LEVELS TO WRITEUnit tests for logic Integration tests for data access... Testing Across Languages Verifying correctness.WHAT LEVELS EXISTUnit tests, covering individual pieces Integration tests,... Testing an Application Before Committing Trying before you build on it.WHYDocumentation and screenshots do not tell you whether an... Testing and Verifying Backups Proving they work.WHY IT MATTERS MOSTAn untested backup is an assumption, and the assumption... Testing Databases and Data Integrity Verifying stored information.WHAT TO TESTData written matches what was submitted Constraints are... Testing Generated Code and Commands Safely Before it touches anything real.THE PRINCIPLENever run anything generated as the first attempt on... Testing in a Pipeline Running checks automatically.WHAT TO RUN ON EVERY CHANGEFast checks: formatting, static analysis,... Testing Laravel Applications Automated verification.WHAT THE FRAMEWORK PROVIDESA testing setup, a separate testing database... Testing Permissions and Multi-Tenancy Verifying isolation.WHAT TO TEST FOR EVERY ROLEEvery function they should access Every function... Testing Queries Safely Working out what a query does before it does it.THE METHODSRun it as a SELECT first, with the... Testing Your Backups Properly The step that turns an assumption into protection.WHYAn untested backup is a guess. People... The Application Installed but Will Not Load Setup completed, site does not work.BLANK PAGEEnable error logging and reproduce. The log names... The Application Is Slow Diagnosing performance.MEASURE FIRSTLoad a static file. If that is fast while pages are slow, the... The Application Will Not Install Failures during setup.DATABASE CONNECTION FAILSThe most common cause. Check the database name and... The Backup Questions to Answer Honestly A short self-assessment.DO BACKUPS EXISTNot "is a plugin installed", but: is there a file, dated... The C Programming Language The foundational systems language.WHAT IT ISA statically typed, compiled, procedural language... The Citation Problem in Legal AI Use The risk that ends careers.WHAT HAPPENSAsk a model for authority on a point and it produces case... The Code Does Not Work Programming problems.THE COMMON CAUSESOutdated methods removed in current versions A library that... The Data Platform Landscape Components and how they fit.WHAT THE LAYERS ARESources: applications, databases, files, external... The Error Is Not Listed Here Diagnosing something unfamiliar.READ IT PROPERLYErrors usually name a file, a line, and a... The Fabricated Citation Problem Why references cannot be trusted.WHAT HAPPENSAsk for sources and you receive citations: authors,... The Server Is Slow: Systematic Diagnosis Working through it rather than guessing.ESTABLISH WHERE THE TIME GOESLoad a static file directly.... The Site Ahead Contains Malware A browser or search engine security warning.WHAT IT MEANSMalicious content was detected on your... The Site Does Not Work After Migration Common causes.A DATABASE CONNECTION ERRORThe configuration file has the wrong database name, user... The Test Pyramid Structuring an automated suite.WHAT THE SHAPE DESCRIBESMany unit tests, fewer integration tests,... The WordPress Database Structure What each table holds.THE CORE TABLESwp_posts: posts, pages, products, revisions, attachments,... Timezones and Date Storage Why times appear wrong.THE COMMON CONFUSIONTimes displaying offset by hours from what you... Too many connections The database refused a new connection.WHAT IT MEANSThe connection limit was reached. Existing... Too many connections or Too many concurrent sessions Connection limits reached.FOR FTPMost clients open several simultaneous connections. Reduce the... Transactions and Data Integrity Changes that must succeed together.WHAT A TRANSACTION ISA group of changes applied entirely or... Transferring Databases Moving the data.EXPORTINGFrom phpMyAdmin on the old host, or a command-line export.Export as SQL,... Transferring Files to and from Your Server Getting data on and off.SCPCopies files over SSH. Simple and available everywhere. Good for... Transfers Between Users Moving value inside a system.WHAT MAKES IT ATTRACTIVEInstant, free or cheap, and entirely within... Troubleshooting HTTPS on WordPress Specifically The common WordPress-specific issues.SITE ADDRESS MISMATCHSettings > General must show https... Troubleshooting Laravel on Shared Hosting Common failures.BLANK PAGE OR SERVER ERRORRead the log first, then the server error log.Debug... Troubleshooting: Everything That Matters, Briefly The whole category in one page.THE FOUR QUESTIONS THAT SOLVE MOST PROBLEMSWhat exactly happens?... Trying to access array offset on value of type null A value was expected and was not there.WHAT IT MEANSThe code expected an array or object and... Tuning Your Database The most impactful tuning on most servers.THE KEY SETTINGFor InnoDB, the buffer pool size... Tuning Your Web Server Configuration that matches your resources.APACHEThe main tuning is the process or thread model... Understanding Add-ons During Checkout Add-ons are optional extras attached to the service you are ordering.TYPICALLY OFFEREDDedicated... Understanding and Adding Indexes The most effective database fix.WHAT AN INDEX ISA structure allowing the database to find... Understanding ASP.NET The Microsoft framework.WHAT IT PROVIDESRouting Dependency injection, built in Middleware... Understanding Azure What the platform provides.WHAT IT ISA cloud platform providing infrastructure, platform and... Understanding Clean Architecture Dependencies pointing inward.WHAT THE CORE IDEA ISBusiness rules at the centre, with everything... Understanding Cloud Run Containers without infrastructure.WHAT IT DOESRuns a container, scaling instances with traffic,... Understanding Collation Mismatches Why some joins fail or behave oddly.WHAT COLLATION ISThe rules for comparing and sorting text:... Understanding CPU Limits Processor time.WHAT IT MEASURESHow much processor time your account uses.WHAT CONSUMES ITEvery... Understanding Data at Different Scales Matching approach to volume.WHAT SMALL DATA MEANSFits comfortably in memory on one machine.WHAT... Understanding Data Sources Where data comes from.WHAT THE COMMON SOURCES AREApplication databases Event streams from... Understanding Database Indexes The single most common performance fix.WHAT AN INDEX DOESLets the database find matching rows... Understanding Database Privileges What a user is permitted to do.THE COMMON ONESSELECT: read dataINSERT: add rowsUPDATE: change... Understanding Disk Space Storage.WHAT COUNTSWebsite files Databases Email Backups on the account Logs CacheWHAT USUALLY... Understanding Environment Configuration Settings that differ.WHAT THE ENVIRONMENT FILE ISA file of key and value pairs, read at startup,... Understanding File Types What extensions mean.WHAT AN EXTENSION ISThe part of a filename after the final dot, indicating... Understanding Firebase A backend platform for mobile.WHAT IT PROVIDESAuthentication Real-time and document databases... Understanding Full-Stack Development Working across both sides.WHAT IT MEANSWorking on both the interface and the server side.WHAT IT... Understanding Input and Output Limits Disk operations.WHAT IT MEASURESHow much reading and writing to disk your account does.WHAT... Understanding Jetpack Compose The declarative approach on Android.WHAT IT ISA toolkit for building Android interfaces by... Understanding Language Performance What actually matters.WHAT DETERMINES APPLICATION PERFORMANCE, USUALLYDatabase queries Network... Understanding Load Average and CPU Usage Reading the numbers correctly.LOAD AVERAGEThree numbers: the average over one, five and fifteen... Understanding Migrations Schema as code.WHAT A MIGRATION ISA file describing a change to the database structure.WHY USE... Understanding Performance Problems Why code is slow.WHAT TO DO FIRSTMeasure.Never optimise based on where you assume the time... Understanding Resource Limits as a Developer Working within a shared environment.THE LIMITSCPU time, memory, entry processes, and disk I/O,... Understanding Slow Database Queries When the database is the bottleneck.THE SYMPTOMPages slow even with caching, particularly for... Understanding the Laravel Project Structure Where things live.WHAT THE MAIN DIRECTORIES HOLDApplication code: controllers, models, and your... Understanding the Request Lifecycle What happens on every request.THE SEQUENCEThe request reaches the single entry point The... Understanding What Is Included With Your Hosting Before you buy extras.INCLUDED WITH EVERY PLANcPanel Free SSL through AutoSSL Email accounts on... Understanding What You Can Afford to Lose Recovery point and recovery time.RECOVERY POINTHow much data you can afford to lose, measured in... Understanding What You Can Change Safely Editing without breaking things.SAFEText on pages Images Adding pages and posts Prices and... Understanding WHM and How It Relates to cPanel Two control panels, two levels.WHM (WEB HOST MANAGER)Your panel. From here you create cPanel... Understanding Your cPanel Statistics and Plan Limits The panel on the right of the cPanel home page shows what you are using against what your plan... Understanding Your Email Storage Mail storage and website storage are the same pool, which surprises people.WHERE IT... Understanding Your Plan Limits The right-hand panel of the cPanel home page shows what you are using against what your plan... Understanding Your Reseller Allocation vs Client Limits Two layers of limits operate at once, and confusing them causes avoidable outages.YOUR... Undoing a Bad Query When you have just broken something.STOP IMMEDIATELYDo not run anything else. Further changes... Uninstalling WordPress and Starting Over Cleanly Sometimes a fresh start is faster than repairing a badly broken or compromised site. Before you... Unknown database The named database does not exist.WHAT IT MEANSThe application is looking for a database that is... Updating Hardcoded HTTP Links in Content Old content keeps pointing at insecure URLs.WHERE THEY HIDEImage src attributes in posts and... Updating WooCommerce Safely Shop updates carry more risk than ordinary site updates, because breakage costs sales.BEFORE... Updating Your Site URL After Enabling HTTPS The application must agree with the server.WHY IT MATTERSApplications generate links and... Upgrading a Service You Already Have Moving to a larger plan.WHEN TO UPGRADEYou are approaching your disk limit You are hitting... Using a Content Delivery Network Serving from closer.WHAT IT DOESServes your files from servers closer to each visitor.WHY THAT... Using a Control Panel on a VPS Managing without the command line.WHAT A CONTROL PANEL GIVES YOUA web interface for sites, email,... Using AI for Legal Research Searching and understanding.WHERE IT HELPSExplaining an unfamiliar area Suggesting search terms... Using AI for Medical Literature and Research Searching and summarising.WHERE IT HELPSExplaining an unfamiliar area Summarising papers you have... Using AI to Fix Website Problems Diagnosis assistance.HOW TO DESCRIBE A PROBLEMThe exact error message, copied not paraphrased... Using AI With Databases Working with your data safely.WHERE IT HELPSWriting queries Explaining what a query does... Using AI With Everyday Software: Briefly The section summarised.THE DIVISION THAT APPLIES EVERYWHEREThe software does the work. AI... Using Content-Security-Policy to Upgrade Requests A header that can mitigate mixed content.WHAT IT DOESAdding upgrade-insecure-requests to a... Using Firebase Securely The critical configuration.WHAT THE MOST COMMON SERIOUS MISTAKE ISSecurity rules left open.WHAT... Using JetBackup to Restore Where JetBackup is available on your plan.WHAT IT PROVIDESBrowsable restore points by date, with... Using Our Knowledgebase With Clients Not writing everything yourself.WHAT IS AVAILABLEExtensive documentation covering email setup,... Using phpMyAdmin Effectively The browser interface, used well.WHAT IT IS GOOD FORBrowsing data Running ad-hoc queries Small... Using phpMyAdmin to Manage Your Database phpMyAdmin is a browser interface for viewing and editing your databases directly.OPENING... Using Screen or Tmux for Long Tasks Preventing a dropped connection from killing a running job.THE PROBLEMA long-running command over... Using Softaculous to Install Applications Hundreds of applications in a few clicks.WHAT IT DOESCreates the files, the database and the... Using Subdomains for Different Applications Separating systems.COMMON USESshop.yourdomain.com for a separate shop platform... Using the Command Line for Large Databases When phpMyAdmin is not enough.WHYphpMyAdmin runs inside a web request and is subject to time and... Using the Knowledgebase Support > Knowledgebase holds articles on hosting, domains, email, security and... Using Transactions Grouping changes so they apply together.WHAT IT ISA set of changes treated as one unit. Either... Using WP-CLI for Database Work The command line tool for WordPress.WHAT IT ISA command-line interface to WordPress, available... Using WP-CLI on Your Account Managing WordPress from the command line.WHYMany tasks are faster and more reliable than through... Validating and Sanitising Input Trusting nothing.WHERE INPUT COMES FROMForms URLs and query strings Headers and cookies Uploaded... Validating Input and Data Trusting nothing from outside.WHERE UNTRUSTED DATA COMES FROMUsers Files APIs Databases populated... Validating Input in Laravel Checking what arrives.WHAT THE FRAMEWORK PROVIDESA validation system with a large set of... Vector Storage and Retrieval Storing embeddings.WHAT A VECTOR STORE DOESHolds embeddings and finds the most similar to a query... Verifying Your Backups Are Actually Running The check almost nobody performs.WHY IT MATTERSA backup system configured and silently failing is... Version Control: Everything That Matters, Briefly The summary.SET UP THE IGNORE FILE BEFORE THE FIRST COMMITOnce a secret is committed it remains... VPS Security Fundamentals The basics, in priority order.THE ESSENTIALSSSH keys rather than passwords, with root login... VPS Terminology You Will Encounter A glossary for the terms that appear in documentation and support tickets.ROOTThe administrative... Web Development: Everything That Matters, Briefly The summary.CHOOSE AN ESTABLISHED, WELL-DOCUMENTED FRAMEWORKAnswers exist when you are stuck.... Web Security: Everything That Matters, Briefly The summary.THE COMMONEST SERIOUS FAULT IN CUSTOM APPLICATIONSChecking authentication but not... Web Technology Terms The underlying pieces.HTMLThe markup describing a page's structure and content.CSSThe rules... Website Recovery Planning Getting back online.WHAT YOU NEED TO RESTORE A SITEA current backup of files and database Access... Website Speed: Everything That Matters, Briefly The whole category in one page.THE THREE THINGS THAT PRODUCE MOST OF THE GAINImages: resize, then... Websites for Property and Real Estate Listings and enquiries.WHAT VISITORS WANTListings they can filter by area, price and type Good... What a Blockchain Actually Is The technology, plainly.WHAT IT ISA record of transactions, replicated across many computers,... What a Cleanup Should Cost Reasonable expectations.WHAT AFFECTS THE COSTSite complexity How long the compromise persisted... What a Complete Backup Actually Contains More than most people include.THE WEBSITEAll files in the web directory: application code,... What a Database Actually Is The part of your site that holds everything.THE SHORT VERSIONYour website has two halves. Files... What a Large Language Model Is The system behind AI chat tools.WHAT IT DOESGiven text, it predicts what text should come... What a Proper Handover Includes What you should receive.ACCESSDomain registrar Hosting Site administration Any third-party... What a Static Site Is Pages without a database.WHAT IT MEANSThe server sends a file that already exists, rather than... What a WordPress Theme Actually Does Understanding the layer.WHAT IT CONTROLSHow your content is displayed Layout and structure... What an ERP System Does Integrated operational management.WHAT IT ISOne system covering several core business functions,... What Bioinformatics Is Computing for biological data.WHAT IT ISThe application of computational methods to biological... What Blockchains Are Not Good For Honest limitations.WHAT THEY DO POORLYStoring large data High-throughput processing Anything... What Breaks When You Change PHP Version Common problems.REMOVED FUNCTIONSOlder code calling functions removed in newer versions produces... What Caching Is and Why It Matters The second biggest gain.THE PROBLEM IT SOLVESWithout caching, every visit rebuilds the page:... What Happens If an Invoice Is Not Paid The sequence is predictable, and at every stage before termination it is recoverable.STAGE 1 -... What Hosting Backups Cover and What They Do Not Understanding the safety net.WHAT WE PROVIDEScheduled backups of hosting accounts, with retention... What Is a Large Language Model? The system behind AI chat tools.THE DEFINITIONA model trained on very large amounts of text to... What Is an Embedding? Turning meaning into numbers.THE DEFINITIONText converted into a list of numbers representing its... What Is Included and What Is Extra Knowing the boundary before you order prevents disappointment afterwards.INCLUDED WITH... What Is Included in Your Hosting Plan Every ZillionKingHost shared hosting plan includes the following as standard.THE ESSENTIALScPanel... What is the ZillionKingHost Domain Marketplace? The Domain Marketplace is a place inside your client area where domain names change hands between... What is WHOIS privacy (ID Protection) and do I need it? When you register a domain, the registry records your name, address, phone number and email as... What Laravel Provides Why use a framework.WHAT IT GIVES YOURouting Request and response handling Database access and an... What Migrating Your Website Actually Involves The full picture.WHAT MOVESYour website files Your databases Your email accounts and their... What Mixed Content Is A secure page loading insecure resources.WHAT HAPPENSThe page itself arrives over https, but... What Not to Paste Into AI Tools Regardless of which software.NEVERPasswords or credentials of any kind Database connection... What Not to Store on Your Hosting Account Files that should not be there.NEVER IN PUBLIC_HTMLBackup archives Database exports Spreadsheets... What Plugins Do and What They Cost Understanding the trade-off.WHAT THEY DOAdd functionality WordPress does not include: forms,... What Public_html Actually Means Web-accessible storage.THE RULEAnything inside public_html can be downloaded by anyone who knows... What Shared Hosting Can and Cannot Run Understanding the boundary.WHAT IT RUNSStatic files, always PHP applications Anything using a... What to Do in the First Hour Immediate steps.DO NOT PANICMost compromises are recoverable.STEP ONE: TAKE A BACKUPEven of the... What to Do When Your Website Is Down Work through this quickly before opening a ticket. Several of these are resolved in under a... What You Need Before Migrating Gathering access.FROM YOUR CURRENT HOSTControl panel access, or a full backup FTP or file access... When a Plugin Is Consuming Resources Finding the culprit.WHAT TENDS TO BE HEAVYSecurity plugins scanning constantly Related-post... When a Restore Fails The backup did not work.COMMON CAUSESThe archive is corrupt or was incompletely transferred The... When to Get Help With Speed Knowing your limit.WHAT YOU CAN DO YOURSELFResize and compress images Enable caching Update PHP... When to Move Beyond Spreadsheets Recognising the limit.WHAT SPREADSHEETS DO WELLAd hoc analysis Modest volumes One person working... When You Actually Need to Touch the Database And when you do not.YOU DO NOT NEED TOEdit content, which the application does properly Change... When Your Database Has Outgrown Shared Hosting Recognising the limit.THE SIGNSQueries consistently slow despite indexes and caching Connection... Where to Find Your cPanel Login Details Three separate logins exist and they are frequently confused.THE THREEClient Area: billing,... Where to Store Backups The decision that determines whether a backup is useful.THE RULENot only on the server being... Where Website Slowness Actually Comes From The real causes, ranked.IMAGESThe largest cause by a wide margin. Uncompressed photographs... Where Your Database Lives Finding it in cPanel.LISTING YOUR DATABASEScPanel > MySQL Databases. It shows every database... Which Languages to Learn for Employment Practical choices.WHAT DETERMINES EMPLOYABILITYDemand in your market Depth, rather than a list of... Whitelisting Your Address for Access Where you need reliable access from a fixed location, an address can be whitelisted.WHEN THIS IS... Why Backups Matter More Than Anything Else The single most valuable thing you can do for a website.WHAT BACKUPS PROTECT AGAINSTA compromise... Why Databases Get Slow Understanding the causes.THE MAIN CAUSESMissing indexes on tables that have grownBloat:... Why Everything Belongs in Version Control The foundation.WHAT TO COMMITApplication code Configuration structure and examples Database... Why Version Control Matters The foundation of collaboration.WHAT IT PROVIDESA complete history of every change The ability to... Why Website Speed Matters The commercial case.WHAT SLOW COSTS YOUVisitors who leave before the page loads Customers who... Why Your Website Is Slow Slow sites almost always come down to the same handful of causes, and the server is rarely one of... Wikis and Documentation Platforms Software for structured knowledge.THE OPTIONSMediaWiki: powerful, the software behind the largest... WooCommerce Database Considerations What changes when you run a shop.THE ADDITIONAL TABLESWooCommerce adds its own tables for... Working With Blade Templates Producing output.WHAT BLADE ISLaravel's template engine.WHAT IT PROVIDESValue output, escaped by... Working With Collections Handling sets of data.WHAT A COLLECTION ISA wrapper around an array with a large set of... Working With Data: Everything That Matters, Briefly The summary.ALWAYS SPECIFY THE ENCODING WHEN OPENING FILESDefaults differ between systems,... Working With Databases Persistent structured storage.WHEN TO USE ONEData that outlives the program Data several... Working with Databases for Other cPanel Applications Not every database belongs to a website.WHAT ELSE USES DATABASESRoundcube webmail, which stores... Working With Eloquent and the Database Layer Data access in Laravel.WHAT THE ORM PROVIDESModels mapping to tables, with relationships... Working with Environment Variables and Paths Why a command works for you and not in a script.THE PROBLEMYour interactive shell loads a profile... Working With JSON Structured data interchange.WHAT JSON ISA text format for structured data, widely used by web... Working with Multiple Databases Several applications, several databases.THE PRINCIPLEOne database and one database user per... Working With Text in PHP Strings.COMMON OPERATIONSJoining Splitting Searching Replacing Trimming Changing case Formatting... Working With the Django ORM Data access.WHAT IT PROVIDESModels defining tables, with relationships and constraints.WHAT... Working With Unstructured Data Text, documents, images and audio.WHAT MAKES IT DIFFERENTNo schema Large individual objects... Writing Code With ZillionKingHost AI Generating working code.HOW TO ASK"Write [what] in [language]. Requirements: [list]. Include... Writing Efficient Code for Shared Environments Habits that keep applications within limits.PRINCIPLESDo the minimum work per request Never do in... Writing Modern PHP Current practice.WHAT TO DECLAREStrict types, at the top of every file.WHYOtherwise values are... Writing Secure Database Queries Preventing the most damaging class of vulnerability.SQL INJECTIONNever build a query by... Writing Tests Verifying behaviour automatically.WHAT A TEST ISCode that checks your code does what it... Writing Unit Tests Testing in isolation.WHAT A UNIT TEST SHOULD BEFast Independent Repeatable Self-verifying Written... Your PHP installation appears to be missing the MySQL extension WordPress cannot find the database driver.WHAT IT MEANSThe PHP extension WordPress uses to talk...