Guides tagged “database”
Step-by-step MdmHost guides about database, sorted A-Z.
93 guides · page 4 of 5
Migrate a WordPress site to MdmHost
Move an existing WordPress site to MdmHost hosting without downtime: copy files and database, update wp-config, test with a hosts file and switch DNS.
Move WHMCS to a new server or hosting account
Migrate WHMCS to a new server: copy files and database, keep configuration.php and the encryption hash, update paths, licence, cron, DNS and payment callbacks.
MySQL command-line cheat sheet for server admins
The MySQL and MariaDB commands you use most on a VPS, from logging in and listing databases to finding slow queries, killing them and checking server status.
MySQL Point-in-Time Recovery Using Binary Logs
Recover a MySQL or MariaDB database to an exact moment after a bad write or dropped table by restoring a full backup and replaying binary logs up to the incident.
MySQL vs MariaDB: which to use on your VPS
Compare MySQL and MariaDB on compatibility, licensing, features, release support and app support, so you can choose the right database for your VPS.
Optimize MySQL Indexes with Composite and Covering Indexes
Learn how to design MySQL composite and covering indexes for WHERE, JOIN and ORDER BY queries, then verify the plan with EXPLAIN and EXPLAIN ANALYZE.
Optimizing Redis for high-read, low-latency applications
Tune maxmemory, eviction and persistence so Redis answers read-heavy traffic in under a millisecond, and learn which kernel settings stop latency spikes.
PostgreSQL Point-in-Time Recovery with WAL Archiving
Set up WAL archiving and restore a PostgreSQL cluster to an exact second with point-in-time recovery, using pg_basebackup, archive_command and a recovery target.
psql cheat sheet: essential PostgreSQL commands
The psql commands you need day to day, from connecting and listing databases, tables and roles to running SQL files and exporting query results to CSV.
Repair Corrupted MySQL InnoDB Tables on a Linux VPS
Confirm InnoDB corruption with CHECK TABLE, start MySQL with innodb_force_recovery to dump readable data, then rebuild the tables from that dump.
Reset a Forgotten MySQL Root Password on Linux
Recover access to MySQL or MariaDB on a Linux VPS by starting the server with skip-grant-tables, setting a new root password and restarting normally.
Reset the PostgreSQL postgres user password
Set or reset the password of the postgres superuser, and regain access when normal logins fail by trusting local connections for a moment and then reverting.
Restore a MySQL Database from a mysqldump File
Load a.sql or.sql.gz dump back into MySQL or MariaDB on your Linux VPS with the mysql command, including charset options and fixes for the usual import errors.
Restore a MySQL database from JetBackup 5 in cPanel
Roll a WordPress or shop database back to an earlier day with JetBackup 5 in cPanel, download a database dump, and restore files and database together safely.
Restore MariaDB from a mariabackup Backup
Restore MariaDB from a mariabackup backup on a Linux VPS: stop the server, prepare the backup files, copy them back into the data directory, fix ownership and start MariaDB again.
Scan WordPress databases for malware with Imunify360 (root guide)
Use the Imunify360 Malware Database Scanner as root to find and clean malicious JavaScript and spam links injected into WordPress databases, with backups and restore.
Search and replace URLs in the WordPress database safely
Replace old URLs or text across a WordPress database without breaking serialised data, using WP-CLI or a plugin, with a dry run and backup first.
Secure MongoDB Remote Access with bindIp and Authentication
Configure bindIp, enable authorization and restrict port 27017 so MongoDB accepts remote connections from your app server only.
Self-host Nextcloud with Docker Compose, MariaDB and Redis
Run Nextcloud, MariaDB and Redis as containers on one Linux VPS. Build the compose file, set trusted domains and verify the stack end to end.
Set Up a MariaDB Galera Cluster on Multiple VPSs
Install MariaDB with the Galera provider on three Linux VPSs, configure wsrep, bootstrap the first node and confirm every node reports Synced.
Browse by topic
- Getting startedYour first hour with a new server: access, logins and basics.69 guides
- cPanelFiles, databases, email, domains and every cPanel tool, step by step.37 guides
- WHM & resellingWHM, packages, reseller accounts, WHMReseller and running a hosting brand.49 guides
- WordPressInstall, secure, speed up, migrate and fix WordPress sites.40 guides
- Email & webmailMailboxes, webmail, forwarders, spam filters and email delivery.37 guides
- DomainsRegistering, transferring and managing domains and nameservers.20 guides
- SSL certificatesFree AutoSSL, Let's Encrypt, paid certificates and HTTPS.19 guides
- CloudLinuxCloudLinux setup and use: LVE limits, CloudLinux Manager, CageFS and PHP/Node.js selectors.31 guides
- LiteSpeedLiteSpeed Web Server, LSCache and the LiteSpeed Cache plugin: install, settings and tuning.30 guides
- Imunify360Malware scanning, firewall and proactive defence with Imunify360.23 guides
- SoftaculousInstall, update, clone and back up apps with Softaculous.23 guides
- WP SquaredcPanel's WordPress platform: sites, plugins, staging and backups.9 guides
- SitePadBuild and publish websites with the SitePad builder.9 guides
- SitejetDesign, edit and publish sites with the Sitejet builder.9 guides
- WHMResellerAlpha and master resellers with WHMReseller: install, setup and use.12 guides
- VirtFusionInstall, set up and manage VirtFusion: hypervisors, packages, servers and WHMCS integration.7 guides
- VirtualizorManage your VPS with Virtualizor: power, OS reinstall, VNC, IPs and backups.30 guides
- PleskWebsites, email, databases and settings in the Plesk panel.52 guides
- DirectAdminUsers, domains, email and reseller tools in DirectAdmin.40 guides
- WHMCSBilling, automation, products and client management with WHMCS.51 guides
- Control panelscPanel & WHM, Plesk, DirectAdmin and other panels on your VPS.106 guides
- SecurityKeys, passwords, firewalls and keeping a server patched.115 guides
- Networking & DNSIP addresses, reverse DNS, ports and traffic.34 guides
- Websites & appsWeb servers, WordPress, PHP, Node.js, SSL and app hosting.52 guides
- DatabasesMySQL, MariaDB, PostgreSQL, Redis and MongoDB on a VPS.64 guides
- Billing & accountInvoices, renewals, the client area and your account.9 guides
- TroubleshootingWhen something is not working: checks and fixes.68 guides
- Linux VPSSSH, packages, services and everyday Linux administration.70 guides
- Windows VPS & RDPRemote Desktop, Windows Server settings and Admin RDP tips.58 guides
- Docker & DevOpsContainers, Git deploys, automation, monitoring and backups.58 guides
Still stuck?
Ask MdmHost AI for a quick answer, or open a ticket and our team will take a look. We are here 24/7.