title: Backup
category: Database
time: 1484087943023
---
# MySQL

## All Database
```
mysqldump --user=$USER -password=$PASSWORD -A > ~/backup/mysql_dump.sql
```

## One or Multiple (But not all) Database
```
mysqldump --user=$USER -password=$PASSWORD -database DB_ONE DB_TWO > ~/backup/mysql_dump_db_one.sql
```

## Restore Database
```
mysql --verbose --user=$USER --password=$PASSWORD DB_ONE < ~/backup/mysql_dump_db_one.sql
```

## Restore All Database
```
mysql --verbose --user=$USER --password=$PASSWORD < ~/backup/mysql_dump.sql
```

# MongoDB

## Backup MongoDB
```
mongodump --dbpath /data/db/ --db test --out /data/backup/
```

## Store MongoDB
```
mongorestore --dbpath <database path> <path to the backup>
```

***Reference:***
- [Database Backup - PhoenixWiki](https://wiki.phoenixlzx.com/page/DB-Backup/)