How to Backup and Restore a MySQL Database

N1Node Editorial Team

22/12/2025

MySQL Backup and Restore Guide | Linux VPS Tutorial - How to Backup and Restore a MySQL Database

Regular database backups are essential for protecting your data against accidental deletion, corruption, or server failures.

Backup a MySQL Database


mysqldump -u root -p database_name > backup.sql

Restore a MySQL Database


mysql -u root -p database_name < backup.sql

Backup All Databases


mysqldump -u root -p --all-databases > alldb_backup.sql

Warning:
Always verify backups before deleting original data.

Note:
Store backups offsite for maximum safety.

Read next articles

MySQL Backup and Restore Guide | Linux VPS Tutorial - How to Find and Kill High CPU Processes on VPS

Guides & Tutorials

How to Find and Kill High CPU Processes on VPS

Step-by-step guide to finding and terminating high CPU processes on a Linux VPS safely.

N1Node Editorial Team

MySQL Backup and Restore Guide | Linux VPS Tutorial - What Are VLANs and the Benefits of a Private VLAN

Guides & Tutorials

What Are VLANs and the Benefits of a Private VLAN

An easy-to-understand explanation of VLANs and the advantages of hosting servers in a private VLAN.

N1Node Editorial Team

MySQL Backup and Restore Guide | Linux VPS Tutorial - Automating VPS Tasks with cron and systemd Timers

Guides & Tutorials

Automating VPS Tasks with cron and systemd Timers

A practical tutorial on automating VPS tasks using cron and systemd timers.

N1Node Editorial Team

MySQL Backup and Restore Guide | Linux VPS Tutorial - How to Configure NFS Server and Client on Ubuntu 24.04 VPS

Guides & Tutorials

How to Configure NFS Server and Client on Ubuntu 24.04 VPS

Learn how to configure NFS file sharing between VPS servers on Ubuntu 24.04.

N1Node Editorial Team