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

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
web-hosting
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
HtaccessPHP

Macguire's docs