Databases

Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.

How to disable the Binary Log (BinLog) for MySQL/MariaDB in Plesk for Linux?
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
How can I change the MySQL root password in Plesk?
Unable to create databases on a Subscription: There are no database servers available for this subscription
MariaDB upgrade fails: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
Remote connections to MySQL/MariaDB database server fail when port 3306 is filtered by firewall
Unable to access Plesk when MySQL/MariaDB database server service is stopped: SQLSTATE[HY000] [2002] No such file or directory
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
An attempt to restore 'psa' database from a dump fails with: Data truncated for column 'event_type' at row
How to restore specific tables from a customer's database dump on Plesk for Linux?
Unable to create database from the site by a database user: Access denied for user SQL: CREATE DATABASE
How to install a MySQL database server in a Docker container hosted in Plesk
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?
Unable to start MariaDB service in a Plesk server: Can't read dir of '/etc/my.cnf.' (Errcode: 2)
Plesk and websites are slow or not accessible due to high CPU load MySQL/MariaDB processes
Unable to restore a database from a dump / backup on the Plesk server: errno: 150 "Foreign key constraint is incorrectly formed"
MariaDB service status failed after upgrade while Plesk and all databases are available: Could not get an exclusive lock
How to create a Plesk backup with databases only
Database issues found by Plesk Repair after MariaDB Upgrade: The attribute 'type' value mismatch: datetime in the original schema and datetime
Plesk SQL Server / MySQL / MariaDB service fails to start: GetDiskFreeSpace(C:\,...) failed - OS error number 5
Plesk customer can not be deleted: Unable to find service node for ip address with id=
Does Plesk for Windows support PostgreSQL?
How to replace MariaDB with MySQL on Ubuntu with Plesk?
Is it possible to move databases location in Plesk for Linux?
An attempt to connect a PostgreSQL instance in Plesk produces an Internal Server Error: Configuration in /etc/psa/psa.conf is malformed