cPanel: Search the site | MozOut

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseBackups & Migration

How to restore only the database from a backup

In cPanel, open JetBackup 5 (Files section), pick the day, and restore only the one database, leaving the files and the e-mail alone. A restore replaces the current database with…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseDatabases

Moving a database to another account or server

Export the database from the source, create an empty database and user at the destination, import the file and point the application at the new connection details. What always changes…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseDatabases

SQLite or MySQL: which one fits a small project

The short answer: SQLite fits a small application with few users writing at the same time and nobody from outside needing the database. MySQL (here, MariaDB) fits anything that is…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseBackups & Migration

Why a backup is huge or fails, and how to make it smaller

A huge backup is almost never “the site”: it is what has piled up around the site. Cache folders, old copies forgotten in the account, error files that kept growing,…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseComparisons and alternatives

Automatic daily backup or your own copy: which one saves you, and when

Short answer: they are not alternatives, they cover different problems. The automatic daily backup handles most everyday disasters (a deleted file, a plugin that broke the site). Your own copy,…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseDatabases

Creating a database user and giving it the right privileges

A database without a user is no use to anyone, and a user with too many privileges is an open door. In cPanel you do it in MySQL Databases: create…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseDatabases

A table marked as crashed: what it means and how to repair it

The message Table is marked as crashed and should be repaired means a table, almost always of the MyISAM type, has an inconsistent file, usually because something stopped halfway through…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseBackups & Migration

Looking inside an old backup without restoring over the live site

To look at an old copy without touching the live site, use JetBackup’s Download instead of Restore: the copy is prepared for you to download, you open it on your…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseSecurity

Someone is sending e-mail in the name of your domain: what SPF, DKIM and DMARC do about it

The short answer: sending an e-mail that looks as if it comes from [email protected] is trivial: the sender address is written freely, like the return address on a letter. To…

MozOut - Kenya www.my.mozout.com › My MozOut › Knowledge Base Knowledge baseChoosing the Right Plan

Which hosting plan for a portfolio or photography site

A portfolio asks for little processor and plenty of disk space and well-handled images. Images define it: each one is a large file, and a gallery turns into dozens of…