Skip to content
Zenuncl Wiki

Backup

MySQL

Section titled “MySQL”

All Database

Section titled “All Database”
mysqldump --user=$USER -password=$PASSWORD -A > ~/backup/mysql_dump.sql

One or Multiple (But not all) Database

Section titled “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

Section titled “Restore Database”
mysql --verbose --user=$USER --password=$PASSWORD DB_ONE < ~/backup/mysql_dump_db_one.sql

Restore All Database

Section titled “Restore All Database”
mysql --verbose --user=$USER --password=$PASSWORD < ~/backup/mysql_dump.sql

MongoDB

Section titled “MongoDB”

Backup MongoDB

Section titled “Backup MongoDB”
mongodump --dbpath /data/db/ --db test --out /data/backup/

Store MongoDB

Section titled “Store MongoDB”
mongorestore --dbpath <database path> <path to the backup>

Reference: