Hi guys!

I need to recover MySQL database via .gz archive.
But I got this error:
I 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.

probably that was my.ini that time, not my.cnf (or my*.ini)
You need to know your system, you need to find the location.

There are some sample config files under /usr/local/mysql/support-files in the mysql binary installation. You can choose one that matches your setup and put it in /etc/my.cnf

By default mysql looks first for /etc/my,cnf. There are also other locations as mentioned in Table 4.2 where mysql looks also for a config file.

Okay, I set up the my.cnf and it seems to mysql work with this.

Solution from Google:
Add a few lines in [mysqld] case
innodb_large_prefix=on
innodb_file_format=Barracuda

Also I tried "mysql> set global innodb_large_prefix=on;"
and "mysql> set global innodb_file_format=Barracuda;"
--------------------------------------------------------------------------------------
Unfortunately this solution not help me, I still got that error.
Any ideas how to fix it?

I think you should upgrade mysql to version 5.7.x, because it doesn't have this limitation. Besides if the key in your backup gives this error, the backup is more likely made from a higher mysql version that 5.5.x.

Anyway if that's not an option, you should go to line 57 of the sql file and add a length for the key.
See this for details, but make sure you make a good backup of the sql file before start messing around with it...

1 members found this post helpful.