mysql

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

Hi, i've this version plesk 17.5.3 patch #26 installed on a centos 7.4.1708 and this morning i've realized that mariadb service is down because of this : Oct 24 11:01:50 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:50 139851548907648 [Note] InnoDB: Starting shutdown... Oct 24 11:01:51...

Hi, this is my first post on this forum. I have searched related info on How to upgrade client MySQL from 5.1 to 5.6 on Windows It says I can use "plesk installer" to finish this upgrade. Now I have three mysql databases(version 5.1) linked with three websites. I want to know the following...

So I have this error: [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found and I am aware of the suggestions / solutions provided here: Unable to access Application Vault: Can't open lib '/usr/lib64/libmyodbc5.so' : file not found but still I am not getting it...