MySQL 5.5.55 backup from .gz archive
by Bolshedvorskii from LinuxQuestions.org on (#6DAWH)
Hi guys!
I need to recover MySQL database via .gz archive.
But I got this error:
Code:root@test-udprf:/var/data# zcat /var/data/20230726_sql.gz | mysql -uroot -ppassword udprf
ERROR 1071 (42000) at line 57: Specified key was too long; max key length is 767 bytesI found in Google how to fix it (Add a few lines at /etc/my.cnf)
But here other problem: I installed MySQL 5.5.55 from source.
Installation directory is /usr/local/mysql
There is no my.cnf in system by default.
If there are no configuration files in the system, where does MySQL get the standard configuration from?
I checked the mysql.server daemon for any tips, but I still don't understand how to create a configuration file and the most important thing is that MySQL would understand this and start working with it.
I need to recover MySQL database via .gz archive.
But I got this error:
Code:root@test-udprf:/var/data# zcat /var/data/20230726_sql.gz | mysql -uroot -ppassword udprf
ERROR 1071 (42000) at line 57: Specified key was too long; max key length is 767 bytesI found in Google how to fix it (Add a few lines at /etc/my.cnf)
But here other problem: I installed MySQL 5.5.55 from source.
Installation directory is /usr/local/mysql
There is no my.cnf in system by default.
If there are no configuration files in the system, where does MySQL get the standard configuration from?
I checked the mysql.server daemon for any tips, but I still don't understand how to create a configuration file and the most important thing is that MySQL would understand this and start working with it.