mysql

How to setup mysql my.cnf to accept both uppercase and lowercase tables. Environment: Os: Ubuntu 14.04 TLS Mysql Server: App Server: Weblogic Server 12.2.1 (Only uppercase tables are accepted) Plesk: 12.0.8 (Only lowercase tables are accepted) I try lower_case_table_names=2 #(default value...

(Plesk Onyx 17.8.11) I have a domain and a database connected to it. I have set the settings to 'Allow remote connections from any host' and created a user. When I try to connect to it from an external programm (datagrip) it gives this error: (database and host.com are the databasename and the...

Hello, starting 3 days ago the updates are failing with this error yum-errors - CentOS Wiki If above article doesn't help to resolve this issue please use My View - CentOS Bug Tracker. epel/x86_64/updateinfo | 938 kB 00:00 remi-safe/primary_db...

Using Plesk Version 17.8.11. Mysql has some nice real time encryption/decryption (aes_encrypt/aes_decrypt) possibilities that others like libsodium dont have at the moment. On earlier versions mysql was build with ECB mode as onliest option. Since version 5.6.17 its possible to use other modes...

I am following the guide here: How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux when I get to the step # yum update mysql I get this output: Loaded plugins: fastestmirror Setting up Update Process Loading mirror speeds from cached hostfile * base...

Hallo, I'm wondering how to change mysql version to version 5.7 in plesk 17.8.11. At "Tools & Settings > Applications & Databases > Database Servers" MySQL Version 10.1.29 is shown - I think this version cannot be correct; maybe it's the MariaDB version. In a software running on this server...

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...