DB migration from new Zabbix Server

[JavierH]

I installed the Zabbix Server 6.4 version in CentOs 9 Stream with NGNIX. I am trying to migrate the DB of my old Zabbix Server 5.0.3 version, using MariaDB, but I get the following error:

[root@production-zabbix home]# mysql -uroot -p zabbix < zabbixbackup.sql
Enter password:
ERROR 1064 (42000) at line 7860: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

What is wrong with the syntax?

Thanks

[cyber]

But we have no idea, as you do not share, what is there on line 7860 of that sql file...

And besides all that, you cannot just insert your old backup into your new DB schema... you should first restore your old backup into your new DB, which will create old schema and data as it is in your old server... Then you start up your new server, which does all the necessary upgrade tasks with your old data...