Viewing articles tagged 'database'

How to Download a MySQL Database Backup in cPanel The cPanel Backup interface can download individual database backups. Open cPanel → Files →... How to Manage a WordPress Database with WP Toolkit WordPress stores posts, pages, settings, users, plugin data, and other information in a database.... How to Restore a MySQL Database Backup in cPanel To restore a database partial backup through cPanel: Open Backup or Backup Wizard →... Why Dynamic Websites Need Both Files and Database Backups Many applications store different parts of the site in different places. Website code, themes,... Diagnosing a Database “Access Denied” Error A MySQL or MariaDB “Access denied” error usually means the connection credentials or privileges... Diagnosing a Database “Too Many Connections” Error MySQL returns “Too many connections” when all ordinary client connection slots are in use. The... Diagnosing “MySQL Server Has Gone Away” “MySQL server has gone away” can occur when a connection is closed after a timeout, when a client... Diagnosing Database Packet Too Large Errors MySQL rejects a communication packet that exceeds the active max_allowed_packet limit and can... Diagnosing Symptoms of a Damaged Database Table Database-table damage can produce query errors, missing data, or application failures, but those... Understanding Databases, Database Users, and Privileges in cPanel MySQL and MariaDB applications normally use three related pieces of information: a database, a... How to Create a Database with cPanel Database Wizard Current cPanel documentation recommends Database Wizard for creating the first database and... How to Create and Manage Databases in Manage My Databases In current cPanel versions, the main MySQL/MariaDB management interface is named Manage My... How to Add a Database User and Set Privileges To give an application access to a database, assign a database user to that database. Open Manage... How to Change a Database User Password Database-user passwords can be changed from Manage My Databases. Locate the database user.Choose... How to Check and Repair a Database in cPanel Manage My Databases includes tools to check a database for errors and attempt repairs.... How to Rename or Delete a Database Safely Renaming or deleting a database can immediately break applications that depend on it. cPanel... How to Use phpMyAdmin from cPanel phpMyAdmin is a third-party database administration tool available through cPanel for... How to Import or Export a Database with phpMyAdmin phpMyAdmin provides Import and Export tools for database data. ExportOpen phpMyAdmin.Select the... How to Configure Remote Database Access in cPanel When enabled, Remote Database Access allows specified remote hosts to connect to MySQL or MariaDB... Understanding cPanel Database Connection Settings A web application generally needs a database name, database username, password, and database... Troubleshooting Database Connection Errors When an application reports that it cannot connect to its database, verify the connection in a... How to Restore a Production Database More Safely A production database can change every minute on stores, forums, membership sites, booking... Backup Planning for Static vs. Dynamic Websites A static website may consist almost entirely of files, while a dynamic website usually depends on...
« Back