MySQL/MariaDB Client
mysql [options] [database]mysql -u root -pmysql -u user -p database_namemysql -e "SHOW DATABASES;"mysql < backup.sqlmariadbInteraktiver MySQL-Client. Funktioniert auch mit MariaDB.
MySQL Datenbank-Backup
mysqldump [options] [database] [tables]mysqldump -u root -p database > backup.sqlmysqldump -u root -p --all-databases > all_backup.sqlmysqldump -u root -p database table1 table2 > partial_backup.sqlErstellt SQL-Dumps von MySQL-Datenbanken.
PostgreSQL interaktiver Client
psql [options] [database [username]]psql -U postgrespsql -U user -d databasepsql -c "SELECT * FROM users;" databasepsql -f script.sql databasePostgreSQL Kommandozeilen-Client.
PostgreSQL Datenbank-Backup
pg_dump [options] [database]pg_dump -U postgres database > backup.sqlpg_dump -U postgres --format=c database > backup.dumppg_dump -U postgres -t table_name database > table_backup.sqlErstellt Backups von PostgreSQL-Datenbanken.
MongoDB Shell
mongosh [options] [database]mongoshmongosh mongodb://localhost:27017/databasemongosh --eval "db.collection.find()"mongosh < script.jsmongoInteraktive MongoDB-Shell. Nachfolger von mongo.
MongoDB Datenbank-Backup
mongodump [options]mongodump --db databasemongodump --db database --collection collectionmongodump --out /backup/pathmongodump --archive=backup.archiveErstellt BSON-Backups von MongoDB-Datenbanken.
Redis Command Line Interface
redis-cli [options] [command]redis-cli pingredis-cli get keyredis-cli set key valueredis-cli -h host -p port infoRedis Kommandozeilen-Client.
SQLite3 Datenbank-Client
sqlite3 [options] [database] [sql]sqlite3 database.dbsqlite3 database.db "SELECT * FROM table;"sqlite3 database.db < script.sqlsqlite3 -header -column database.db "SELECT * FROM users;"Leichter SQLite-Datenbank-Client.