61 lines
1.3 KiB
Markdown
61 lines
1.3 KiB
Markdown
# 📦 Requirements
|
|
|
|
```bash
|
|
sudo apt update
|
|
sudo apt install mariadb-client postgresql-client
|
|
```
|
|
|
|
# ⚠️ Common Issues and Fixes
|
|
|
|
### ❌ mysqldump: command not found
|
|
### Cause: MySQL client is not installed.
|
|
|
|
Fix:
|
|
```bash
|
|
sudo apt install mariadb-client
|
|
```
|
|
|
|
### ❌ pg_dump: command not found
|
|
|
|
### Cause: PostgreSQL client is missing.
|
|
Fix:
|
|
```bash
|
|
sudo apt install postgresql-client
|
|
```
|
|
|
|
### ❌ pg_dump: error: aborting because of server version mismatch
|
|
|
|
### Cause: The local pg_dump is version 15, while the remote PostgreSQL server is version 17.
|
|
Fix: Install pg_dump version 17 from the official PostgreSQL (PGDG) repository:
|
|
```bash
|
|
# Add the official PostgreSQL repository
|
|
echo "deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list
|
|
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/pgdg.gpg
|
|
sudo apt update
|
|
|
|
# Install the PostgreSQL 17 client
|
|
sudo apt install postgresql-client-17
|
|
|
|
```
|
|
|
|
|
|
# ⏰ Automating via Cron
|
|
|
|
Open your crontab:
|
|
|
|
```bash
|
|
crontab -e
|
|
```
|
|
|
|
Add a line like this to run the script daily at 1 AM:
|
|
```bash
|
|
0 1 * * * /path/to/backup.sh >> /path/to/logs/backup.log 2>&1
|
|
```
|
|
|
|
# 🔐 Security Tips
|
|
Restrict access to the config file containing credentials:
|
|
|
|
```bash
|
|
chmod 600 config.sh
|
|
```
|