Sunday, June 21, 2020

Export database + mysqldump + MySql


I share example how to export database from command line, use mysql dump

A DB, then:

mysqldump -u [uname] -p db_name > db_bk.sql
   
Remote DB, then:

$ mysqldump -P 3306 -h [ip_address] -u [uname] -p db_name > db_bk.sql











No comments:

Post a Comment

🚀 Streaming PostgreSQL Changes to BigQuery using Cloud Run Jobs + Cloud Scheduler 🔄

This lightweight Change Data Capture (CDC) pipeline streams PostgreSQL logical replication events to BigQuery — no Debezium, no Kafka, just ...