Home / Questions / 88153
Accepted
Angel Montes de Oca
Asked: 2020-07-20 14:46:04 +0800 CST 2020-07-20 14:46:04 +0800 CST

Check if a mysql server exists on network with CMD?

  • 772

I am trying to create an installer with Inno Setup which installs a Server or Terminal of a point of sale, the problem is that when I install a terminal I need to verify if the database exists in the Hostspecified (Server) to be able to advance.

The way I achieve and get close to what I want to do is by running the mysqldump.exe:

mysqldump.exe -uroot -pjavac -P3500 -h10.1.12.79 baseDatos

The problem I have is that I don't want to create a backup, I just need to check if the database exists or not, with some lightweight command line program.

Is there any tool that can check the existence of a database and can run it for CMDsimilar?

mysql

1 Answers

  1. Best Answer

    You can use mysqllike this for example:

    mysql.exe --host=HOST --user=USER --password=PASS --execute="SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'DB_NAME'"

    If the basis:

    • Does not exist the result will be empty.
    • If exists , it will return a row.
    • 1