Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Plesk is not accessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
- Can not connect to the database server: can't connect to mysql server on example.com (10061)
- Unable to restore the Microsoft SQL database: Log file size in backup is greater than the maximum allowed size
- MariaDB fails to restart after upgrade from 10.5 or below to 10.6 or above using upgrade tool in Plesk
- MariaDB crashes after update on a Plesk server: mariadb.service: main process exited, code=exited, status=218/CAPABILITIES
- MariaDB pre-upgrade check failed: The following package manager configuration files contain options that may result in an upgrade failure
- MySQL does not start after replacing MariaDB: MySQL has been frozen to prevent damage to your system
- Unable to check the Mysql/Mariadb status after upgrade: ERROR! MariaDB is running but PID file could not be found
- Plesk provides error on opening database list in Tools & Settings > Database servers: Dependent row(s) 'Domains.id = 783' isn't found for 'data_bases.dom_id = 783'.
- Unable to dump database manually or during a backup process on Plesk: Error 2013: Lost connection to server during query when dumping table example at row: 0
- How to copy a MySQL/MariaDB database in Plesk?
- MariaDB is not able to start: Got error '144 "Table is crashed and last repair failed"' for './mysql/global_priv'
- Domain hosting settings can't be opened in Plesk: Internal error: Full path is undefined. Inconsistency in the table 'domains' for the column id: No rows in the table 'hosting' with dom_id
- Attempt to repair or check MariaDB/MySQL table produces the following message: The storage engine for the table doesn't support repair
- Unable to access Plesk panel: ERROR: 500 Plesk\Exception\Database: SQLSTATE[HY000] [2002] Connection refused
- Plesk is not accessible due to a stuck mysqld/mariadb process: "Connection refused" or "No such file or directory"
- How can I change the MySQL root password in Plesk?
- Unable to connect remotely to MySQL on Plesk: Connection refused
- Database Error 1194: Table 'corrupted_table' is marked as crashed and should be repaired
- Unable to delete the database of a domain in Plesk: Directory not empty
- Restoration of the psa database fails: Data truncated for column 'event_type' at row
- How to restore specific tables from a customer's database dump on Plesk for Linux?
- Database server list can't be accessed: 500 GraphQL Internal Server Error
- Unable to create database from the site by a database user: Access denied for user SQL: CREATE DATABASE
- Unable to create a backup of PostgreSQL database: pg_dump: aborting because of server version mismatch
- Unable to clone or backup MSSQL database in Plesk: Property TextHeader is not available for StoredProcedure <...>. The text is encrypted
- MySQL/MariaDB fails to start: Upgrade after a crash is not supported
- How to manage a database hosted in Plesk using a local database client?
- Plesk and websites slow or not accessible due to high CPU load MySQL processes
- MariaDB service status failed after upgrade while Plesk and all databases are available: Could not get an exclusive lock