• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

database

  1. P

    Resolved Plesk update: ERROR while trying to backup MySQL database

    Hello, I tried to update my Plesk version from 18.0.47 to the latest available one (18.0.60) from my Plesk panel (Tools & Settings>Plesk>Updates) and got the following error : I didn't find anything about this specific issue on the internet. The only similar case I found didn't really resolve...
  2. N

    Resolved Can't connect remotely (local network) to database

    Hello, When I try to connect to my MariaDB through my local network, using DBeaver, server answer me : (conn=536) Access denied for user 'jam_staging'@'NVINCENT-PC.horizon.local' (using password: YES) I've checked the remote option in the database server plesk page, as you can see below : What...
  3. S

    Question Restore database and change the name

    Hi, Is it possible to change the name of the database in order to restore it without drop the production database ? thanks
  4. M

    Resolved Cannot connect to DB Remotely

    Basically cannot connect to my db from my local computer. The database is on localhost:3306 on the server, remote connections are allowed. What I've done: 1. Turned off the Firewall completely (didn't work) 2. Restarted MySQL and MariaDB services 3. Adjusted the config file to bind 0.0.0.0 4...
  5. S

    Issue Plesk Control Panel search and specific pages/actions are extremely slow, while website works fine.

    Hi, I've been using Plesk since 4 years, I've never changed Plesk Panel settings, I own only 1 website that has an heavy traffic, the website doesn't seems affected by this issue, the problem poped out 3 days ago, I decided to update Plesk to the latest version: 18.0.56, unfortunately the issue...
  6. K

    Resolved I cannot manage MSSQL even though we have a Developer Pack license

    Good morning, We purchased the Developer Pack in order to be able to manage MSSQL database servers. We followed the procedure, but it only added the keys for Docker and for PageSpeed Insight... nothing about MSSQL. I don't see anywhere to add it or even configure it, is this normal? (I...
  7. S

    Question How to upgrade MariaDB 5.5.68 to 10.5 or higher version?

    My server is running MariaDB 5.5.68. I would like to upgrade to 10.5 or a higher version. Could someone please assist me in upgrading it?
  8. Z

    Resolved date/time of the last change to a Database in Plesk

    Hi, to all. I have 9 Databases on Server and i need to know date/time of last change each Database. How i can see this in Plesk or phpMyAdmin? Can someone advise me? Thank you in advance.
  9. S

    Issue Error: Connection to the database server failed: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'UTF8_GENERAL_CI'

    1.) When trying to Export Dump from the Plesk Database dashboard I get following error: Unable to export a dump of wp_c2: mysqldump: Warning: Charset id '33' csname 'utf8' trying to replace existing csname 'utf8mb3' mysqldump: Warning: Charset id '83' csname 'utf8' trying to replace existing...
  10. J

    Resolved How do I access a database dump from a backup?

    I have a remote Windows 2019 server running Plesk. Incremental backups are done daily and stored locally on the server; complete backups are done weekly and stored in a DigitalOcean space. Backups include database dumps of the SQL Server (Express) database. My own machine is a Mac, running...
  11. Z

    Issue Database server (and sites) hanging during backup

    During the backup, the database server hangs. And, accordingly my sites too ( 504 ). Only restarting the database server helps. after one-two days, everything repeats. OS: Ubuntu 18.04.6 LTS DB Server: MariaDB 10.3.38 Plesk Obsidian: Version 18.0.49 Update #2
  12. Quinten

    Question Database information of the main plesk database

    Hello, I would like to connect my plesk database to our Grafana panel as a data source to read out some data. Where do i find the database connection info of the main database of the Plesk server? Any help would be appriciated. Kind Regards, Quinten
  13. C

    Issue Documentation: Deleting Database Users

    Hello, everyone! I am trying to remove a certain user from a certain database using their IDs. Anyone can tell me what's wrong with this xml packet code, or do I just need to find another way? <packet> <database> <del-db-user> <filter> <id>55</id>...
  14. K

    Resolved Unable to backup databases (Exit code: 7)

    We are getting errors with the backup manager from Plesk which is unable to backup the databases from our server. For example: Warning: Database "xenforo_a" Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 7: mysqldump: unknown variable 'ft_min_word_len=3' These...
  15. Fester77NL

    Resolved PHPMyAdmin is not available

    Dear support, I have created a database in plesk. The database works well. Only I can't manage the database in phpmyadmin because it is not available. As you can see in the picture, there is no icon of phpmyadmin. I've already tried this, but it doesn't work: How to access phpMyAdmin shipped...
  16. E

    Question CLI - Get list of databases by domain

    Hello, Do you know if there's a way to get the list of databases associated with a domain from the CLI (Bash script)?
  17. W

    Issue Database import issue after server migration

    I migrated my Plesk, which I use in Ubuntu, to Centos 7 on my new server. I get the following error when I want to import my database backups on the new server. What is the reason?
  18. M

    Resolved Bug managing databases after migration from Onyx server to new Obisdian One

    Hello, A little context : - the source server is a Centos 6.10 machine with Onyx Plesk (with reseler and subscriptions) - the destination server is an Almalinux 8.5 with Obsidian Plesk (without subscriptions) I migrate all domains with very few problems but for some of migrated websites...
  19. Fester77NL

    Issue Try to create a database server MySQL

    Hello all, I am trying to create a database server. But I get a server error. SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) The database can then be seen in the overview. When I try to add a database I get this message: Error: No database servers are...
  20. P

    Question Removed default MariaDB Server

    Hi, this is my first few days with Plesk and love it. I have some quick questions about some things I have done. Plesk Obsidian Web Host Edition Version 18.0.41 Update #1 Microsoft Server 2022 VPS host is IONOS I removed the default MariaDB Server from the Database Servers list, with the...
Back
Top