1mysql -s --skip-column-names -ne "use DB_to_Use; show tables;"

See https://serverfault.com/questions/42789/how-to-increase-memory-usage-in-mysql-server-to-improve-speed

1mysqldump -u<username> -p<password> --no-create-db myDB -h localhost > mysql.backup That way, it would strip the original database name and NOT become a problem when importing to another database name. See …

1root@rh:~# /usr/local/bin/automysqlbackup /etc/automysqlbackup/rh.conf 2Parsed config file "/etc/automysqlbackup/automysqlbackup.conf" 34grep: /home/icasimpan/.my.cnf: No such file or directory 5grep: /home/icasimpan/.my.cnf: No such file or directory 6# Checking for permissions to write to folders: 7base …

In a machine 'rh', tested automysqlbackup cron job if it would work and got the issue below: 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 …

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