Skip to content

Losnia

Random tech stuff

  • Home
  • Portal
  • CV
  • Telegram
  • About

Category: mysql

bookmark_borderBackup and restore all MySQL databases

Posted on 28/03/201430/08/2019 by Kael

To backup all databases at the same time:

mysqldump –user=[USER] –password=[PASSWORD] –all-databases > [BACKUP_FILENAME]

mysqldump --user=[USER] --password=[PASSWORD] --all-databases > [BACKUP_FILENAME]

To restore a dump (in our case, all databases):

mysql -u [USER] -p < [BACKUP_FILENAME]
Posted in debian, mysqlTagged backup, mysql, restoreLeave a Comment on Backup and restore all MySQL databases

Categories

  • debian
  • docker
  • iptables
  • javascript
  • mysql
  • php
  • powershell
  • python
  • security
  • ssl
  • steam
  • windows
  • wpf
  • wsl
  • xslt
keyboard_arrow_up
Theme: Noto Simple