Command Line Database Exports

From Kubernetes:
Template:
kubectl exec DBPOD -n NAMESPACE -- mysqldump -u DBUSER -p'PASSWORD' DBNAME > FILENAME.sql

Example:
kubectl exec rwm-lamp-mariadb-0 -n riverworks -- mysqldump -u rwm_user -p'add-password-here' sitedb > rwm_database-2024-01-01.sql

kubectl exec rwm-lamp-mariadb-0 -n riverworks -- mysqldump -u rwm_user -p'add-password-here' sitedb > ~/Documents/backups/rwm_database-2024-01-01.sql

-----------------------------------------------------------------------------------------

From Docker:

docker exec stack_db_1 /usr/bin/mysqldump -u rwm_user --password='add-password-here' sitedb > rwm_database-2024-01-01.sql

docker exec stack_db_1 /usr/bin/mysqldump -u rwm_user --password='add-password-here' sitedb > rwm_database-2024-0-01.sql

-----------------------------------------------------------------------------------------

From MySQL:

Export --
Template: 
mysqldump -u [user] -p [database] > [file_name].sql

Example: 
mysqldump -u rwm-user -p rwm_database > ~/backup/rwm_database-2024-01-01.sql

mysqldump -u rwm-user -p rwm_database > rwm_database-2024-01-01.sql

Import --
Template: 
mysqlimport -u [user] -p [database] [file_name].sql

Example:
mysqlimport -u rwm_user -p rwm_database ./path-to-file/rwm_database-2024-01-01.sql

-----------------------------------------------------------------------------------------

CyberPanel 
Export --
Template:
mysqldump -u [user] -p[password] [database_name] > [filename].sql

Example:
mysqldump -u rwm_admin -p'add-password-here' rwm_database > rwm_database-2024-01-01.sql

Import --
Template:
mysql -u [user] -p [database_name] < [filename].sql

Example:
mysql -u rwm_user -p'add-password-here' rwm_database < rwm_database-2024-01-01.sql

----------------------------------------------------------------------------------------

Digital Ocean External Database
Template:
mysqldump -u doadmin -p -h [host] -P 25060 --single-transaction --set-gtid-purged=OFF [database] > /path/to/database_file.sql

Go to https://cloud.digitalocean.com/databases/283eb28d-335f-4d57-8856-c17f2a4a9381?i=8cb6c3 for credentials