How do I skip an offline database over the network in MySQL import?
With some suggestion from Akina, I'm able to find one post in SO about how to determine if an IP is online or not through the network before executing the MySQL import command. Here is the link to the answer : https://stackoverflow.com/a/21252613/10910692

Below is the code I'm using in my batch file:

ping -n 1 192.xxx.xxx.xx | find "TTL=" &gt;nul
if errorlevel 1 (
    echo host is offline..
    ) else (
    echo Updating host...
    mysql.exe -h 192.xxx.xxx.xx -P -u -p inventory &lt; C:\xxx\data\xxx.sql
)


I also took Akina's suggestion to concatenate both the import and update query into one file and only need to call that one file for the update. As I mention in my question, the code above is repeated for about 20 times. 

If I stick to my previous method and assuming that all IP is offline, it will take about 800 secs = 13-14 mins for the batch file to finish processing while with the method above, it reduces to 1-2 mins only! (based on assumption that each command took 5 secs max while in reality its less than 5 secs per command).