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
•
07 May 2024
Understanding transaction control in MySQL: A guide to START TRANSACTION, ROLLBACK and COMMIT
Recently I came across this piece of gold when dealing with databases, particularly relational ones like MySQL, managing transactions efficiently is crucial to ensure data integrity and consistency. In MySQL, transactions are used to group several SQL commands into a single unit that either...
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'...