Perplexity Ai writing scripts

[neurosis]

lol

Just for fun I asked perplexity ai to write a batch script that will back up a database and delete any backups older than 14 days.  It wrote the script in less than one second. 

I wish this had been around when the forums started.   


The exact question   

can you write a bash script that will back up a sql database, date the backups, and delete any backup older than 14 days?

Code Select Expand

bash
#!/bin/bash

# Configuration
DB_USER="your_username"
DB_PASSWORD="your_password"
DB_NAME="your_database_name"
BACKUP_DIR="/path/to/backup/directory"
DAYS_TO_KEEP=14

# Create backup directory if it doesn't exist
mkdir -p "$BACKUP_DIR"

# Generate timestamp for the backup file
TIMESTAMP=$(date +"%Y%m%d_%H%M%S")

# Backup filename
BACKUP_FILE="$BACKUP_DIR/${DB_NAME}_${TIMESTAMP}.sql"

# Perform the database backup
mysqldump -u "$DB_USER" -p"$DB_PASSWORD" "$DB_NAME" > "$BACKUP_FILE"

# Check if the backup was successful
if [ $? -eq 0 ]; then
    echo "Backup created successfully: $BACKUP_FILE"
   
    # Compress the backup file
    gzip "$BACKUP_FILE"
    echo "Backup compressed: $BACKUP_FILE.gz"
else
    echo "Error: Database backup failed"
    exit 1
fi

# Delete backups older than 14 days
find "$BACKUP_DIR" -name "${DB_NAME}_*.sql.gz" -type f -mtime +$DAYS_TO_KEEP -delete

echo "Deleted backups older than $DAYS_TO_KEEP days"

[Incogneeto]

I asked it to "Find my next wife"

I'm getting a Loud Ear Splitting Whine and Smoke??

[neurosis]

When I asked it to do this same thing months ago I had to keep asking it questions until it got everything right.  It does more than I asked it to probably based on popular requests. 

[RobertELee]

I asked it to "Find my next wife"

I'm getting a Loud Ear Splitting Whine and Smoke??

[Incogneeto]

Nope Higher than that.

[neurosis]

This is what I tell my girlfriend she sounds like when she's drunk.   


https://www.barbneal.com/wp-content/uploads/fogleg04.mp3

[RobertELee]

Nope Higher than that.

[Tim Johnson]

Mazak has a mill-turn that writes a machining program using the part model alone with AI.