💽
Hosting

MySQL database backup — mysqldump and other methods

15.10.2025
← All articles

MySQL databases need daily backups.

mysqldump

mysqldump -u user -p mydb > backup.sql

Standard CLI tool. Automated via cron.

phpMyAdmin

Export tab via GUI. Saves as .sql or .gz.

Plesk Backup

Plesk runs weekly backups automatically, can push to Google Drive.

Replication

For heavy sites — real-time copy on a second server.

Test restores

Periodically restore your backup — verify it actually works.

Related articles

🛡️ Protecting an OJS journal site from bots: search, load and logs 🛠️ How to Contact Hosting Support So Your Issue Gets Solved Fast 🧭 Self-Hosting a Vector Database: Qdrant and pgvector 🧭 Portainer: Managing Docker from Your Browser
🌐 Language
🇺🇿 O⁠'zbek 🇺🇿 Özbek (yangi) 🇺🇿 Ўзбек 🇷🇺 Русский 🇬🇧 English ✓