Mysqldump Unix commands

export all Databases

NOT A ROOT USER

mysqldump -uroot -p --all-databases > database-march24-2021.sql

mysqldump --all-databases -uuser -ppassword> database.sql

mysqldump --all-databases --skip-lock-tables -u user -p > Sept2018database.sql