Skip to content

Instantly share code, notes, and snippets.

@chrisjangl

chrisjangl/DB_report.sh

Created November 24, 2021 12:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save chrisjangl/7362db6ae26ff211b7d7dbe268506ab3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save chrisjangl/7362db6ae26ff211b7d7dbe268506ab3 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. chrisjangl revised this gist Nov 24, 2021. No changes.
  2. chrisjangl created this gist Nov 24, 2021.
    21 changes: 21 additions & 0 deletions DB_report.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,21 @@
    i=1
    touch urls.txt
    COUNT=$(wc -l sites.txt)
    for SITE in $(cat sites.txt)
    do
    cd $SITE
    echo "Working on $SITE ($i of $COUNT)..."
    echo "## $SITE" >> ../urls.txt
    url=$(wp option get siteurl)
    postURL="/wp-login.php"
    db=$(wp config get DB_NAME)
    echo "DB: $db" >> ../urls.txt
    echo $url$postURL >> ../urls.txt
    echo "----------------" >> ../urls.txt
    echo " " >> ../urls.txt
    echo " " >> ../urls.txt
    echo " " >> ../urls.txt
    ((i=i+1))
    clear
    cd ..
    done