Andrew Fletcher published: 4 April 2019 (updated) 15 January 2021 1 minute read
To add ejabberd and run MYSQL to the server I needed to update the server version of mysql from 5.5 to 5.7. Fortunately, there are great instructions on the Plesk support page regarding how to achieve this outcome.
As a point of reference, as I worked through the steps... step 10 you need to restart the MYSQL server. This is a quick progress by running the following command
service mysqld start
However, for me it failed. To correct this I needed to edit the my.cnf file located in the etc directory (/etc/my.cnf).
vi /etc/my.cnf
Search for the line innodb_additional_mem_pool_size=500K and comment it out. Save the file and try to restart the MYSQL server
service mysqld start
Now working as anticipated, so I could move on and complete steps 11 and 12.
Related articles
Andrew Fletcher
•
11 Dec 2023
Importing and Exporting a MySQL database with Drush
These steps are for Drupal 8 and 9. Export your databaseOrder here is important. First you want to clear all the Drupal caches. Then export / dump the db the sql database to a file in your home directory.drush cr
drush sql-dump >...
Andrew Fletcher
•
27 Jul 2023
Exporting a MySQL table to a file
Goal: I want to download a table list to a txt or csv file.Initially, as a root user I tried using drushdrush sql-dump --tables-list=media_field_data > db-list.sqlOf course as a root user and Drush set-up not as root. failed with Command 'drush' not found, did you mean:
command 'rush'...
Andrew Fletcher
•
17 Aug 2022
How To Install Apache Solr 8.11 on CentOS/RHEL 7
Looking to install Solr on your server? Not sure if it worth the effort? Well, Apache Solr is the open-source, popular, super fast open source enterprise search platform from the Apache Lucene project. Written in Java, Solr is highly scalable, providing fault-tolerant distributed...