podlom · November 6, 2023 14:58 · Nov 6, 2023 · Nov 6, 2023 · Nov 6, 2023
diff --git a/_start_stage_to_prod_sync.sh b/_start_stage_to_prod_sync.sh
@@ -45,26 +45,36 @@ ls -alh "${DB_BACKUP_PATH}"
 # Pass log file name sswith a prod SQL dump file name in it
 # Check if an argument was provided
 if [ "$#" -ne 1 ]; then
-    echo "Usage: $0 /path/to/your/file.txt"
+    echo "Error. Usage: $0 /path/to/your/file.sql.tar.bz2"
     exit 1
 fi
 
-# The first argument is the file path
+# The first required argument is the dump.sql.tar.bz2 file name
 FILE_PATH="$1"
 
 # Check if the file exists
-if [ -f "${DB_RESTORE_REMOTE_PATH}/${FILE_PATH}" ]; then
-    printf "Display directory listing in ${DB_RESTORE_REMOTE_PATH}.\n"
+if [ -f "${DB_BACKUP_PATH}/${FILE_PATH}" ]; then
+    cd "${DB_BACKUP_PATH}"
+    pwd
+    ls -alh
+    tar xjvf "${DB_BACKUP_PATH}/${FILE_PATH}"
+
+    STRIPPED_NAME="${FILE_PATH%.tar.bz2}"
+    printf "Display directory listing in ${DB_RESTORE_REMOTE_PATH}...\n"
     ls -alh "${DB_RESTORE_REMOTE_PATH}"
 
-    printf "Starting DB import from SQL dump file ${DB_RESTORE_REMOTE_PATH}/${FILE_PATH}"
-    wp db import "${DB_RESTORE_REMOTE_PATH}/${FILE_PATH}"
+    if [ -f "${DB_RESTORE_REMOTE_PATH}/${STRIPPED_NAME}" ]; then
+        printf "Starting DB import from SQL dump file ${DB_RESTORE_REMOTE_PATH}/${STRIPPED_NAME}...\n"
+        wp db import "${DB_RESTORE_REMOTE_PATH}/${STRIPPED_NAME}"
 
-    echo "Fix website URLs..."
-    wp db query < "${DB_RESTORE_REMOTE_PATH}/_update_stage_to_prod_option_urls.sql"
+        printf "Fix website URLs...\n"
+        wp db query < "${DB_RESTORE_REMOTE_PATH}/_update_prod_to_stage_option_urls.sql"
 
-    echo "Well done at:"
-    date
+        echo "Well done at:"
+        date
+    else
+        echo "Error: The file at path '${DB_RESTORE_REMOTE_PATH}/${STRIPPED_NAME}' does no exists."
+    fi
 else
-    echo "Error: The file at path '${FILE_PATH}' does not exist."
+    echo "Error: The file at path '${DB_RESTORE_REMOTE_PATH}/${FILE_PATH}' does not exist."
 fi
diff --git a/_start_stage_to_prod_sync.sh b/_start_stage_to_prod_sync.sh
@@ -1,5 +1,6 @@
 #!/bin/bash
 
+
 # Set up local and remote credentials
 LOCAL_WP_PATH="/home/wpe-user/sites/asianlegacystg" # Change to your WordPress directory path
 LOCAL_UPLOADS_PATH="${LOCAL_WP_PATH}/wp-content/uploads" # Local uploads directory path
@@ -17,13 +18,16 @@ REMOTE_DB_BACKUP_PATH="/nas/content/live/asianlegacylib/wp-content/_db_backups"
 REMOTE_DB_BACKUP_NAME="_wp_prod_backup_$(date +%F_%H-%M-%S).sql" # Backup file name with a timestamp
 
 
-# Make sure the local db backups directory exists
-mkdir -pv "${DB_BACKUP_PATH}"
-
-rm -fv "${DB_BACKUP_PATH}/*.sql"
-
-printf "Display directory listing in ${DB_BACKUP_PATH}.\n"
-ls -alh "${DB_BACKUP_PATH}"
+# Check if the directory exists
+if [ -d "${DB_BACKUP_PATH}" ]; then
+    rm -fv "${DB_BACKUP_PATH}/*.sql"
+    printf "Display directory listing in ${DB_BACKUP_PATH}.\n"
+    ls -alh "${DB_BACKUP_PATH}"
+else
+    # Make sure the local db backups directory exists
+    echo "Directory does not exist. Creating directory ${DB_BACKUP_PATH}..."
+    mkdir -pv "${DB_BACKUP_PATH}"
+fi
 
 # Navigate to the WordPress installation directory
 cd "${LOCAL_WP_PATH}"

diff --git a/_start_stage_to_prod_sync.sh b/_start_stage_to_prod_sync.sh
@@ -0,0 +1,66 @@
+#!/bin/bash
+
+# Set up local and remote credentials
+LOCAL_WP_PATH="/home/wpe-user/sites/asianlegacystg" # Change to your WordPress directory path
+LOCAL_UPLOADS_PATH="${LOCAL_WP_PATH}/wp-content/uploads" # Local uploads directory path
+DB_BACKUP_PATH="/home/wpe-user/sites/asianlegacystg/wp-content/_db_backups" # Local backup directory
+DB_RESTORE_REMOTE_PATH="/home/wpe-user/sites/asianlegacystg/wp-content/_db_backups/nas/content/live/asianlegacylib/wp-content/_db_backups"
+DB_BACKUP_NAME="_wp_stage_backup_$(date +%F_%H-%M-%S).sql" # Backup file name with a timestamp
+TAR_BACKUP_NAME="${DB_BACKUP_NAME}.tar.bz2"
+REMOTE_USER="wpe-user" # Remote server username on prod
+REMOTE_HOST="asianlegacylib.ssh.wpengine.net" # Remote server host on prod
+REMOTE_PATH="/nas/content/live/asianlegacylib" # Remote backup directory on prod
+REMOTE_UPLOADS_PATH="/nas/content/live/asianlegacylib/wp-content/uploads" # Remote uploads directory path on prod
+REMOTE_SSH_PORT="22" # Default SSH port is 22, change if it's different on prod
+REMOTE_WP_PATH="/nas/content/live/asianlegacylib" # Change to your WordPress directory path on prod
+REMOTE_DB_BACKUP_PATH="/nas/content/live/asianlegacylib/wp-content/_db_backups" # Local backup directory
+REMOTE_DB_BACKUP_NAME="_wp_prod_backup_$(date +%F_%H-%M-%S).sql" # Backup file name with a timestamp
+
+
+# Make sure the local db backups directory exists
+mkdir -pv "${DB_BACKUP_PATH}"
+
+rm -fv "${DB_BACKUP_PATH}/*.sql"
+
+printf "Display directory listing in ${DB_BACKUP_PATH}.\n"
+ls -alh "${DB_BACKUP_PATH}"
+
+# Navigate to the WordPress installation directory
+cd "${LOCAL_WP_PATH}"
+# Print working directory
+pwd
+# Display current directory listing
+ls -alh
+
+# Create a backup of the WordPress database using WP-CLI
+wp db export "${DB_BACKUP_PATH}/${DB_BACKUP_NAME}"
+tar cpjvf "${DB_BACKUP_PATH}/${TAR_BACKUP_NAME}" "${DB_BACKUP_PATH}/${DB_BACKUP_NAME}"
+ls -alh "${DB_BACKUP_PATH}"
+
+
+# Pass log file name sswith a prod SQL dump file name in it
+# Check if an argument was provided
+if [ "$#" -ne 1 ]; then
+    echo "Usage: $0 /path/to/your/file.txt"
+    exit 1
+fi
+
+# The first argument is the file path
+FILE_PATH="$1"
+
+# Check if the file exists
+if [ -f "${DB_RESTORE_REMOTE_PATH}/${FILE_PATH}" ]; then
+    printf "Display directory listing in ${DB_RESTORE_REMOTE_PATH}.\n"
+    ls -alh "${DB_RESTORE_REMOTE_PATH}"
+
+    printf "Starting DB import from SQL dump file ${DB_RESTORE_REMOTE_PATH}/${FILE_PATH}"
+    wp db import "${DB_RESTORE_REMOTE_PATH}/${FILE_PATH}"
+
+    echo "Fix website URLs..."
+    wp db query < "${DB_RESTORE_REMOTE_PATH}/_update_stage_to_prod_option_urls.sql"
+
+    echo "Well done at:"
+    date
+else
+    echo "Error: The file at path '${FILE_PATH}' does not exist."
+fi
No results found