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


-- 
Regards,

Robert K Wild.
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to