Hi Rob, Looks like that database has at least one stored function. Those aren’t exported by default but can be toggled with with --routines
Try the same process, but with: mysqldump --routines -u root -p'password' aspera_console > /mnt/pixit/engineering/aspera_console/mysql_backups/20230623.sql S From: robert k Wild via discuss <[email protected]> Sent: Sunday, June 25, 2023 12:06 PM To: [email protected] Subject: [MariaDB discuss] mysql restore error 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]
