1[root@rh icasimpan]# /usr/local/bin/automysqlbackup /etc/automysqlbackup/rh.conf 2Parsed config file "/etc/automysqlbackup/automysqlbackup.conf" 34# Checking for permissions to write to folders: 5base folder /var/lib ... exists ... ok. 6backup folder /var/lib/automysqlbackup ... exists ... writable? yes. …

1mysql> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%'; Sample output as follows: Image not found a.warning-link { color: inherit !important; font-weight: inherit !important; text-decoration: underline !important; border-bottom: none !important; } Web …

1mysql> SHOW CHARACTER SET;

1drupal@ubuntu:/var/www/sites/openedu.localhost/docroot$ drush si site-name='OpenEDU Testing' --db-url='mysql://openedu_DBA:openedu_PASS@127.0.0.1/openedu_DB' openedu 2PHP Fatal error: Uncaught Error: Undefined class constant 'MYSQL_ATTR_SSL_CA' in …

In drupal root: 1drush sql-drop

1icasimpan@am2018:~$ sudo mysql_secure_installation 23Securing the MySQL server deployment. 45Connecting to MySQL using a blank password. 67VALIDATE PASSWORD PLUGIN can be used to test passwords 8and improve security. It checks the strength of password 9and allows the users to set only those passwords which are …

Caused by difference in database versions where the latest version you're running does not support 'utf8mb4unicode520_ci'. Search and replace it from within the dump file with 'utf8mb4_unicode_ci'. See details in …

Check /etc/mysql/my.cnf and examine "datadir" value. If it isn't valid or you know the disk is bad, change it. Restart service and all will be well.

1mysql -u root -p your_DB < ./your_system.sql More details in https://stackoverflow.com/questions/9696249/restoring-a-mysql-table-back-to-the-database

1mysqldump -u root -p yourDB system > yourDB_system.sql More details in https://dba.stackexchange.com/questions/9306/how-do-you-mysqldump-specific-tables