hi all,
i successfully backed up the database
/opt/aspera/common/mysql/bin/mysqldump -u root -p'password' aspera_console > /mnt/pixit/engineering/aspera_console/mysql_backups/20230623.sql
then i try to restore it, first i delete the database and create the database
/opt/aspera/common/mysql/bin/mysql -u root -p'password'
drop database aspera_console;
create database aspera_console;
then run the restore command and i get the error
/opt/aspera/common/mysql/bin/mysql -u root -p'password' aspera_console < /mnt/pixit/engineering/aspera_console/mysql_backups/20230623.sql
ERROR 1305 (42000) at line 80504: FUNCTION aspera_console.report_user_id does not exist
luckily this is not the live vm, its a clone of the live, so im messing around
thanks,
rob