database
3 articles in this category.
Automating Database Backups with mysqldump and Cron
Set up automated daily WordPress database backups using mysqldump and cron. Compress, timestamp, rotate old backups, and upload offsite with rclone.
Read →Database Backup & Restore — Copy-Paste Command Reference
Every mysqldump and restore command you'll actually need. Copy, change the database name and filename, run. No explanation you don't need — just commands that work.
Read →Installing MariaDB and Creating the WordPress Database
Install MariaDB on Rocky Linux 9, run the security setup, create a database and dedicated user for WordPress. Plus an honest note on why using root for everything is convenient but not ideal.
Read →