Learning Center
Learning Center
  • HTML
  • CSS
  • JAVASCRIPT
  • Bootstrap
  • React
  • jQuery
  • NodeJs
  • Sql
  • MySql
  • Python
  • OpenVPN Setup
  • Log In
Coding Choice Home About Contact ☰
  1. You are here
  2. Home
  3. mysql
  4. backups_and_restorations

Sidebar
  • Introduction
  • MySQL Basics
  • Advanced SQL Queries
  • Indexing and Optimization
  • Stored Procedures and Triggers
  • MySQL Security
  • Backups and Restorations
  • Transactions and Concurrency
  • Share via
    • Share via...
    • Twitter
    • LinkedIn
    • Facebook
    • Pinterest
    • Telegram
    • WhatsApp
    • Yammer
    • Reddit
    • Teams
  • Send via e-Mail
  • Print
  • Permalink

Backups and Restorations

Backing Up a Database

mysqldump -u root -p my_database > backup.sql

This command creates a backup of my_database.

Restoring a Database

mysql -u root -p my_database < backup.sql

Restores the database from backup.sql.