Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- 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?
- How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?
- How to add db_owner role to newly created users
- How to create a database dump using PHPMyAdmin in Plesk?
- Unable to import MySQL database from .tmp file in Plesk: ERROR: ASCII '\0' appeared in the statement
- "Import Dump" and "Export Dump" buttons are not shown in Plesk
- Plesk upgrade or databases backup fails: mysqldump: unknown variable
- How to fix InnoDB corruption cases for the MySQL databases on Plesk for Windows?
- MariaDB logrotate on Plesk server reports error: logrotate_script: 3: [: /var/run/mysqld/mysqld.pid: unexpected operator
- How to increase upload dump size for phpMyAdmin in Plesk?
- MariaDB 10.3 error after upgrade: Plugin 'unix_socket' is not loaded
- Which MariaDB versions are supported by Plesk?
- MySQL error on the server with Plesk: Could not increase number of max_open_files to more than 16384
- Remote connection to MySQL database hosted on Plesk fails: ERROR 2003 (HY000): Can't connect to MySQL server
- Diagnose & Repair tool detected issues with the database: Checking the Plesk database using the native database server tools
- Website hosted on Plesk is not working: Microsoft OLE DB Provider for SQL Server error '80004005'
- How to back up/restore a system database in Plesk
- How to enable remote access to MySQL server in Plesk?
- Warning on the "Database Servers" page in Plesk: Unable to determine the TCP port number used by Microsoft SQL server
- MySQL reports the error on a Plesk for Linux server: Cannot load from mysql.<table_name>. The table is probably corrupted
- How to upgrade MySQL from 5.1 to 5.5 on Plesk for Linux?
- How to repair non-InnoDB MySQL tables on Plesk server?
- Fail2ban jails not activated on Plesk server: NOK: ('database disk image is malformed')
- How to manually create MSSQL database backup in Plesk?
- MySQL crashes with error: Fatal error: cannot allocate memory for the buffer pool
- MySQL/MariaDB fails to start on a Plesk for Linux server: Can't open and lock privilege tables
- How to change a PostgreSQL admin password in Plesk for Linux