MYSQL timeout

[Malte Pfaff-Brill]

Hi Terry,

had the same problem. I settled to ping the IP first before trying to connect to the DB:

  switch
         case "mac" is in the platform
            get shell("ping -q -o -c3 -t3"&&tIP)
            if the result is not empty then
               put the result into tError
            end if
            break 
         case "win" is in the platform
            set the hideConsoleWindows to true
            local tShell
            put ("ping -n 1 -w 100 "&tIP) into tShell
            get shell(tShell)
            if the result is not empty then
               put the result into tError
            end if
            break
      end switch

      if tError is not empty then
      -- can not connect to server
      end if

Even though you can not be sure, that mySQL is really up and running, you will at least know if the server is there. Hope that helps a little.

Cheers,

Malte