Monthly Archives: June 2017

SOLVED: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

Posted on June 10, 2017 by Darren

This video shows how to correct the error:   ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes   The commands that you will need to run to correct the error are:   SET GLOBAL … Continue reading →

Posted in CentOS, Computer Science, Databases, learning, linux, mysql | Leave a comment

How to backup and restore a MySQL (MariaDB) database in CentOs Linux

Posted on June 6, 2017 by Darren

This video describes how to back up a MySQL (MariaDB) database to a file. You can then restore this file to another database.    

Posted in CentOS, Computer Science, Databases, learning, linux | Leave a comment