| Question: |
Good afternoon, could you update the version MysqlРЅРµ function AES_DECRYPT(FROM_BASE64 |
| Question: |
To 5.6 |
| Answer: |
Hello. it is the most affordable version of mysql for this panel. utochnyat what version of mysql do You need? server is mysql Ver 15.1 Distrib 5.5.52-MariaDB |
| Question: |
The same проблемаhttp://stackoverflow.com/questions/29741313/mysql-1305--does-not-exist-from-base64пишут need to be updated to Upgrade to MySQL 5.6.1 MySQL said: Documentation#1305 - FUNCTION FROM_BASE64 does not exist |
| Answer: |
we submitted a request to the developers of the panel. by default mysql 56 is available. |
| Question: |
Strange, I have the same ISP stood 5.6 |
| Question: |
But I think it was updated |
| Answer: |
if possible it will be updated |
| Question: |
Thank you, because without it, the desired functionality does not work |
| Answer: |
please wait. please Yong nothing yet to change at |
| Question: |
Do not touch anything |
| Answer: |
mysql --version
mysql Ver 14.14 Distrib 5.6.35, for Linux (x86_64) using EditLine wrapper |
| Question: |
Anne failed to connect to database \" Can`t connect to local MySQL server through socket `/var/lib/mysql/mysql.sock` (111) |
| Question: |
And all off the service was just |
| Answer: |
inform if there are any problems |
| Question: |
the mysqld service is not started |
| Answer: |
wait, in panel error. now upgraded. if that doesn`t work we pereustanovit server. utochnyat what data You uploaded, what would we load it poutre |
| Answer: |
when you create the database choose an alternate version of mysql https://doc.ispsystem.ru/index.php/Альтернативные_версии_MySQL |
| Question: |
\"wait, in panel error. now upgraded. if that doesn`t work we pereustanovit server. utochnyat what data You uploaded, what would we load it poutre\"I thing that the current database has not changed(or if you reinstall, then restore the current data in the database) |
| Question: |
This is important |
| Answer: |
sorry. due to failure of the panel current base is already available, we can vosstanovit only from your dump. change the version of mysql may be the cause of the data loss |
| Question: |
It erased, or is simply no way to connect to it? |
| Answer: |
the database server does not start after the upgrade, we can`t do a database dump. now he reset the mysql server |
| Question: |
/var/lib/mysql/ stored physical database files, you can throw after recovery of the mysql server? |
| Question: |
On the local Denver that works |
| Answer: |
you have now two alternative ustanovleny mysql server , but the main one that perstel to work specify option works but not always. please wait, usingopera do |
| Answer: |
launched the server, make a dump |
| Answer: |
the same panel is not working properly, we did a dump, now it is save and you can reinstall the server. let do I need something else to save from the folder of the user and the base shop? |
| Question: |
All that`s there, and crontab settings |
| Answer: |
we saved the www folder and database dump shop the job as we understand these? php /var/www/teamteam/data/www/cb.php >/dev/null 2>&1
php /var/www/teamteam/data/www/cron.php >/dev/null 2>&1 |
| Question: |
Yes |
| Answer: |
when Ustinovka mysql5.6 panel died again. again you want to reset the server |
| Question: |
Can panel another version to put older? |
| Question: |
I basically do not care what panel, the main thing that worked |
| Answer: |
no, because the old version does not support mysql56. very update will not work. now use the possibility of installation of alternative versions. the last time they ostanovilis. you will additionally ustavlena another version of php it will have slightly different port that you want to Buyukanit in connection settings. now again sets the bar. then ustnovit an alternate versie https://doc.ispsystem.ru/index.php/Альтернативные_версии_MySQL |
| Answer: |
these will not work, reinstall the server on a different OS , for example ubuntu16 |
| Answer: |
set. now import the database |
| Answer: |
base importieren the way in isp5 has the ability to import from lokalnogo file, ie you can load the dump to the hosting as sql file and importierte it in the panel check pozhaluista Your website |
| Question: |
Yes, thank you, now everything works, you change the credentials? |
| Answer: |
What data? |
| Question: |
Not like everything is fine, the key is just to update I had when connecting |
| Answer: |
OK |
