Macguire's Docs
GitHubGitHub (opens in a new tab)
  • Setup
    • Install Proxmox
    • Get ISOs
      • pfSense
      • Create Vms
      • pfSense
      • Wireguard
  • macOS
  • Topics
  • Alpine
  • Ansible
    • Resize VM Disk
  • Apache
  • Asdf
  • Borg
  • Dotfiles
  • Favicon
  • Find
  • Firewalld
  • Git
  • Host
  • Index
  • JavaScript
  • Linux
  • Message Authentication Code Incorrect
  • Moving Proxmox to New Disk
  • Mysql
  • Nextra
  • PHP
  • Phpmyadmin
  • Python
  • Rsync
  • Setup
  • Simplelogin
  • Ssh
  • Stat
  • Symbolic Links
  • TypeScript
  • WordPress
    • Box Shadow
    • Motion
    • Adguard Home
    • General
    • Home Assistant
    • Nginx Proxy Manager
    • Mdx
  • Setup
    • Install Proxmox
    • Get ISOs
      • pfSense
      • Create Vms
      • pfSense
      • Wireguard
  • macOS
  • Topics
  • Alpine
  • Ansible
    • Resize VM Disk
  • Apache
  • Asdf
  • Borg
  • Dotfiles
  • Favicon
  • Find
  • Firewalld
  • Git
  • Host
  • Index
  • JavaScript
  • Linux
  • Message Authentication Code Incorrect
  • Moving Proxmox to New Disk
  • Mysql
    • Dump all databases to a file
    • Import a file to mysql
  • Nextra
  • PHP
  • Phpmyadmin
  • Python
  • Rsync
  • Setup
  • Simplelogin
  • Ssh
  • Stat
  • Symbolic Links
  • TypeScript
  • WordPress
    • Box Shadow
    • Motion
    • Adguard Home
    • General
    • Home Assistant
    • Nginx Proxy Manager
    • Mdx

On This Page

  • Dump all databases to a file
  • Import a file to mysql
Question? Give us feedback → (opens in a new tab)Edit this page
Mysql

MySQL

Dump all databases to a file

mysqldump -v -u root -p --all-databases --result-file=alldb.sql

Import a file to mysql

⚠️ This will overwrite everything.

mysql -v -u root -p < alldb.sql
Moving Proxmox to New DiskNextra

Macguire's docs