Error while restoring mysql database via dump, what should I do?

Question

MariaDB

The problem is this, I created a database dump through mysqldump on the server, a dump of the Bitrix database, the size is 25.8 GB. There are more than 500 tables in the database.
When transferring to a local machine via mysql, an error occurs on table 170. The work is worth it, I can not expand the project locally. Here is the error: ERROR 3105 (HY000) at line 6938: The value specified for generated column 'INVERSE_SORT' in table 'b_iblock_element' is not allowed.

I really need advice!

Answer 1

Here it is advised to check (and update) the version of the client.
Well, a stupid question - are the versions of the database that were dumped and where deployed to - the same?

Answer 2

Dumps are SQL queries to make changes to the database. You need to act on the principle of "from complex to simple". Find on which query the error occurs (most likely it is INSERT into the b_iblock_element table and try to execute it manually. If it doesn’t work, manually edit the query, leave half of the inserted records and try again. And so on until you find the problematic value that stops the filling of the entire dump
If you have already shown a specific line with a problematic value, the task is simplified .