The PHP MySQL driver must support the utf8mb4 charset (libmysqlclient 5.5.3 and up, or mysqlnd 5.0.9 and up, MySQL(mysqlnd) Native Driver is a replacement for the MySQL Client Library (libmysqlclient)).
The MySQL server must support the utf8mb4 charset (5.5.3 and up).
Run the command mysql --version to see your current MySQL version. As for checking the MySQL driver version, run the command php -i | grep 'mysqlnd\|libmysqlclient'.
For existing Drupal installations
First, back up your database and convert all existing tables to utf8mb4, such as by using the drush command provided by the utf8mb4_convert contrib project.
Set the "charset" and "collation" keys on the database connection array in settings.php to "utf8mb4" and "utf8mb4_general_ci" respectively:
Method for EXISTING WEBSITES with active databases doesn't work
mysql -u database_user -p
Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 425 Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4;') AS mySQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= "c0_db_core" AND TABLE_TYPE="BASE TABLE";
ALTER DATABASE c0_db_core CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;
SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;') AS MySQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= "c0_db_core" AND TABLE_TYPE="BASE TABLE";
SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, ROW_FORMAT = DYNAMIC;') AS MySQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= "c0_db_core" AND TABLE_TYPE="BASE TABLE";
Therefore, we have to use recommendation for
new Drupal installations
Prior to running the installer, edit settings.php and manually add in the full database settings array code, with 'charset' as 'utf8mb4', and 'collation' as 'utf8mb4_general_ci', and with the actual values for 'database', 'username', 'password', 'host', as shown below:
# Various rewrite rules. <IfModule mod_rewrite.c> RewriteEngine on
RewriteCond %{HTTPS} !=on # This checks to make sure the connection is not already HTTPS RewriteCond %{HTTP:X-Forwarded-Proto} !https RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
PART 3 -
Enabling
Unpack multiple archives in folder
for archive in *.tar.gz do tar xzvf $archive done
Backup and Migrate(backup_migrate) /admin/config/media/file-system /admin/config/system/backup_migrate
Running first BACK-UP
+ Scheduling DAILY_BACKUPS
/admin/config/system/backup_migrate/schedule
Name
Destinations
Profile
Frequency
Keep
Enabled
Last run
Operations
Untitled Schedule
Scheduled Backups Directory
Default Settings
Every 3 days
24 hourly, 30 daily, all weekly backups
Enabled
Never
edit delete export
Administration menu Adminimal Theme works corectly
Changed layout of MENU to a nice view
/admin/config/user-interface/modulefilter
Editing toolbar - Admin Menu /sites/all/modules/admin_menu/admin_menu.inc/** * Build icon menu links; mostly containing maintenance helpers. * * @see theme_admin_menu_links() */ function admin_menu_links_icon() { $destination = drupal_get_destination();