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
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.
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.
wow fantastic simon, it works, thanks!!!
On Mon, 26 Jun 2023 at 09:35, robert k Wild robertkwild@gmail.com wrote:
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.
Glad you’ve got it sorted, Rob.
From: robert k Wild robertkwild@gmail.com Sent: Monday, June 26, 2023 3:07 PM To: Simon Avery Simon.Avery@atass-sports.co.uk Cc: discuss@lists.mariadb.org Subject: Re: [MariaDB discuss] mysql restore error
You don't often get email from robertkwild@gmail.commailto:robertkwild@gmail.com. Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification wow fantastic simon, it works, thanks!!!
On Mon, 26 Jun 2023 at 09:35, robert k Wild <robertkwild@gmail.commailto:robertkwild@gmail.com> wrote: 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.ukmailto: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.orgmailto:discuss@lists.mariadb.org> Sent: Sunday, June 25, 2023 12:06 PM To: discuss@lists.mariadb.orgmailto: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.
-- Regards,
Robert K Wild.
participants (2)
-
robert k Wild
-
Simon Avery