mysqldump – Blog

Mysqldump error: The user specified as a definer does not exist

2039 admin

May 19, 2021 at 4:33 pm (last edited May 19, 2021 at 4:33 pm)

Error:

mysqldump myuser_db > myuser_db.sql

mysqldump: Got error: 1449: “The user specified as a definer (‘user_db’@’localhost’) does not exist” when using LOCK TABLES

To pass this error try to use –single-transaction

mysqldump --single-transaction myuser_db > myuser_db.sql

Should be good now

Source: https://stackoverflow.com/questions/26583103/mysqldump-got-error-1449/26583311… Read the rest

How to create SQL dumps of all user’s MySQL databases

1282 admin

September 8, 2018 at 10:57 pm (last edited September 8, 2018 at 11:36 pm)

Enter username and wait while it creates MySQL dumps:

read -p "Username: "user && for i in `mysqlshow |grep $user |cut -d '|' -f2`; do mysqldump $i > $i.sql; done

… Read the rest

How to create MySQL dump and get it on your email

1280 admin

September 8, 2018 at 10:52 pm

Definitely could be a mail sending problem if your SQL dump too large

mysqldump -ce my_db --user=my_user --password=mypass |gzip > ~/DBBackup.`date +\%F`.gzip; uuencode ~/DBBackup.`date +\%F`.gzip DBBackup.`date +\%F`.gzip |mail -s "my DB" [email protected]; rm -f ~/DBBackup.`date +\%F`.gzip

… Read the rest