great, thank you simon, i will try the dump again and then the restore and get back to you On Mon, 26 Jun 2023 at 07:49, Simon Avery <Simon.Avery@atass-sports.co.uk> wrote:
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 <discuss@lists.mariadb.org> *Sent:* Sunday, June 25, 2023 12:06 PM *To:* discuss@lists.mariadb.org *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.
-- Regards, Robert K Wild.