mysql

Hi all, I am attempting to update MySQL on my Plesk server from 5.5 to 5.6. I have followed the guide here and initially run into the problem outlined here. Unfortunately the latter does not seem to have resolved the issue, in trying to update to 5.6. Can anyone of you kind people please...

Hello Plesk! I accidently deleted plesk and its dependencies to reinstall mysql through grep on Debian 8 (jessie) Now, I see no fix to get it back working as apache is down apt-get update doesn't work. I tried changing sources.list but it doesn't work either. I tried ./plesk-installer and...

Hi, recently the health monitoring on our server has started larting us to high MySQL CPU and Memory usage (it;s beeing getting over 20%). Howveer when I check 'SHOW PROCESSLIST' there is almost always less than 10 process runnig and other than the admion 'Sleep' commands, ther eother have...

how to configure plesk database remote access settings? can anyone tell me step by step guide because i'm noob to this field

Hello, Following an update from Plesk 17.5.3 to version 17.8.11 update#6; I can not access Plesk's control panel anymore. I get a 500 error with the following message: Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory Type Zend_Db_Adapter_Exception...

Ok. I ran into a small problem with my Plesk Server. I accidentally typed "rm -rf /etc", instead of "rm -rf etc", on the production server... On a positive note, we don't host customer sites, just our own. On the down side, there are about a dozen web sites down now. I had been bugging the boss...

Hi at all, I want to optimize my MySQL database for example InnoDB Buffer Pool Size. Therefor I performed this test: mysql> SELECT CONCAT(ROUND(KBS/POWER(1024, -> IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.49999), FROM (SELECT SUM(data_length+index_length) KBS FROM...

Hi, I have a Wordpress site on Plesk using DropBox to do the backup daily. The host firm upgraded the server and for some unknown reasons now my database is gone! When I tried to restore the backup this happened: Failed to Execute: \'/usr/local/psa/bin/pleskrestore\' --restore...

Dear pleskers! Love your forum and platform. Plesk is my main server manager and I totally love it. Unfortunately there are some things that are different when considering plesk installed. I got a new server with couple of websites on it (im providing hosting). It hosts big woo commerce...

I am trying to migrate a huge website from cpanel to plesk. This website is a WordPress multisite that allows users to create their own blog. Wordpress multisite create new tables for each new user and blog, this is how it works. I have set open-files-limit to 65535 on both servers but I am...

Hello, I Have a major issue, for database backup copy one file from /var/lib/psa/dumps one daily backup. but how i can extract it. and how i use this backup database ?

Hi , since nowadays centos7 comes out with MariaDB 5.5 so any plesk I installed on centos7 , it is already binded with mariadb how can I switch to Percona or Mysql ? because all I googled out is about change from mysql to mariadb, no vice versa.

Hi everyone, We are using Plesk since mid 2016 to manage 10 websites on our VPS Cloud (OVH as hosting) It works really good, thank you for providing such product However, we are experiencing an issue since a few weeks Everyday we have an alert on a red background which says "Failed to update...

Hi, I am used to use MariaDB for all my server setups, but im not sure how to install MariaDB 10.1 in a safe way for Plesk. All my optimization configs are based on MariaDB, and i would like to stay on that version. I found the guide How to install MariaDB in Ubuntu 16.04 Thats fine and all...

Morning guys, CentOS 7.4 - Plesk Onyx 17.5.3 After trying to fix an issue last night I ended up restoring a snapshot on the server which has led to a new issue. I've SSH'd and done df -h. Disk is showing 106GB used. This is correct so I know the disk contents is still there but...Plesk login...

Hi, what are you using on yours servers, MariaDB or MySQL and why?

Hi I have a dedicated mysql server to host the clients' databases. I have the need to turn off this dedicated server. In order to do this, I need to migrate the databases that are on this dedicated server to the server where plesk is installed. How should I proceed? Thank you

Hey Guys, i want to ask how i can connect to the server's database with my .net Application. I used the MYSQL data.dll but it keeps showing me timeouts

When Plesk Migrator has to rename a MySQL user during migration due to a conflict, showing this warning message in the log: MySQL database user with the name 'wordpress_0' already exists on target server. Database user 'wordpress_0' from the source server will be renamed to 'wordpress_02' on...

As the thread title says really but we can't We suspect this MAY be linked back to the MySql / Maria DB setup... We want to ensure that if/when on the rare occasions that Roundcube is used, it's via https only. Post_#6 in that previous thread clearly explains how to do this. However, in our...