mysql 5.6

After restoring a site through function Tools & Settings -> Backup Manager -> and then restore i find that the content of the original view is destroyed and also the permission is now set to "DEFINER=`backup_AOjmJQR`@`%`" thus preventing the right user to accessing or modifying the view. MySQL...

Hi guys, I manually intervened to update my database. I followed the necessary steps through Putty and first upgraded from 5.1 to 5.5. Then I increased from 5.5 to 5.6 and finally from 5.6 to 5.7. But currently plesk is not working on my server. Only .frm, .myi and myd files of my database...

Hello, I am new to the forum so forgive me for for any mistakes while posting this thread. We have a dedicated server with following configuration Processor: 1x3.2GHz E3-1230 Operating System: Centos 6.2 64-bit-old RAM: 8 GB GB We have around 10WordPress websites on this server with moderate...

Recently, I attempted to upgrade MySQL from version 5.5.55 to 5.6. In doing so, this has resulted in the Plesk Dashboard and Mail Server being inaccessible. Learning the hard way of doing updates in a Live Environment. Whilst I have manually backed up the Website's Web Files and MySQL...

Earlier, I attempting to upgrade my MySQL, from version 5.5.55 to 5.6, using the SSH Client 'PuTTY'. This being my first time, I decided to strictly follow this Plesk Article. I managed to reach step 10 within the 'Plesk on CentOS 6' drop down menu. As per the step, I then tried to start the...

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

HI all OK, i've searched the website for the instructions for this 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 But before I proceed to do that I need some assurance. I need at least 5.6 to install Magento 2 but I have 39 databases running 5.5.56 on...

Hi all New here so bear with! I want to upgrade the vBulletin forum that we use to the latest version, but before I can do that I need to upgrade MYSQL as the minimum requirements are v5.5.8 (minimum). I inherited this system and my Linux knowledge is pretty much zero (I am a new-age windows...

Hello, I'm unable to update Mysql 5.5 to Mysql 5.6. I followed the description found at How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux step-by-step. In the beginning it looks very good. But when it comes to the step "apt-get install mysql-server" it breaks with an...

Hello! I have big problem. If this is wrong place in forum, please tell me, I will delete thread and copy content to somewhere else, think it is also related general to plesk onyx. To this year a friend with database experience was optimising my mysql database for many years. Now he is ill and...

Hello, good day, sorry but I'm a bit newbie here, after trying to update mysql (on ubuntu 14.04.5 LTS) using as reference the documentation of you on this page Cómo actualizar MySQL 5.5 a 5.6/5.7 en Linux I get some issues related to broken dependencies, the terminal showed that tried to...

Hello, the mysql server of my VPS in not working since today morning. After trying to start the MYSQL server manually I can see the following message in the command line: Command: sudo service mysql start mysqld_safe Can't log to error log and syslog at the same time. Remove all...

I have followed this guide to upgrade MySQL: How to upgrade MySQL 5.5 to 5.6/5.7 on Linux All looks good but the last step does not want to complete: 7. Upgrade MySQL databases: # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin This is the message I get when trying to run this...

For the reason that my providers offers now Ubuntu Server 16.04 LTS with Plesk Onyx (64 Bit) as an default-image option. What is recommended by You or Plesk for this environment? Upgrading MySQL 5.5 to only 5.6 or better upgrading to MySQL 5.7? Greets

Hi, last days I looked closer to the setup environment of local MySQL-Server 5.6 (upgraded from default 5.5 with great help by this forum). Database works fine from my point of view, but it shows a "special" php-version 5.6.27 of nginx-server. That makes me absolutely wonder, because in my...

Hi, a few days ago I made my server new and successfully made an upgrade to MySQL 5.6 [former 5.5] Today I had one MySQL update to mysql-apt-config_0.8.4-1_all.deb [former 0.8.3.1] Also worked fine. But I got the well-known message: root@domain:~# service mysql restart * Stopping MySQL...

Hello, I had a crash with my Plesk 12.5, definitely due to the latest update! I would like a little help please! The mysql service did not start on the machine. http://imgur.com/a/VMlwA I tested a Plesk repair with the command: plesk installer --select-release-current --reinstall-patch...

Hi Folks, For a long time im struggling now to upgrade MySQL on my Plesk Server. It runs on CentOS 6.8 and Plesk 17.0.17. For now MySQL 5.1 is installed, and i would like to upgrade to 5.6 or 5.7. Without any loses and close all of the danger out. Im a total noob in upgrading databases and...

Almost a year ago I upgraded Mysql 5.1 to 5.5 through Atomic. Not the best choice :(. OS: ‪CentOS 6.8 (Final)‬ Product: Plesk Onyx 17.0.17 Update #18 , last updated at Mar 6, 2017 09:58 AM When I run mysqld -V it shows: mysqld Ver 5.5.54 for Linux on x86_64 (MySQL Community Server (GPL))...

Hello Is it possible install mysql 5.6 using plesk Onyx 17? my plesk is version Version 17.0.17 Update #17 installed on ‪CentOS 6.8 (Final)‬. thanks!