Knowledge Base
Exporting a database
Save a copy of your database to a file.
mysqldump -h HOST -P PORT -u USER -p DBNAME > backup.sql
- In HeidiSQL use Tools › Export database as SQL, and in DBeaver use Tools › Dump Database.
- For MongoDB, use
mongodump, and for Redis, copy the dump or useredis-cli --rdb.
Keep your exports safe, since they contain your data.