MySQL error when restoring portal database to new server.

Products

• CA API Developer Portal

Issue/Introduction

When we are doing a portal migration from version 5.0 to 5.1. and go from MySQL 8.0.22 to 8.0.28 ,

We have the following error when importing the dump:

ERROR 1305 (42000) at line 3468: FUNCTION portal.CURRENT_MS does not exist.

Environment

Release : 5.1

Component :

Resolution

The dump taken with mysqldump does not include the functions by default you need to add  --routines to the mysqldump to include the functions used in the portal database in the backup.