Execute script on remote mysql db?

Question

I'm using below script to update a table in mysql db which is installed in my local machine.

update.sql

use test;
update test.stockcurrent set units='0' where units<'0';

update.bat

@ECHO OFF
SET MYSQL_EXE="C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe"
SET DB_USER=root
SET DB_PWD=password

CALL %MYSQL_EXE% --user=%DB_USER% --password=%DB_PWD% < update.sql
IF %ERRORLEVEL% NEQ 0 ECHO Error executing SQL file

Above code is working fine in if mysql is running locally in my machine.

But Now I need to connect to mysql which is running remotely and I need to execute the script from my local machine. How can I do this?

Zafar Malik · Accepted Answer · 2015-07-15 12:26:07Z

1

change your script as per below, need to add -h in your script.

@ECHO OFF
SET MYSQL_EXE="C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe"
SET DB_USER=root
SET DB_PWD=password

CALL %MYSQL_EXE% -h <your_server_ip> --user=%DB_USER% --password=%DB_PWD% < update.sql >> C:\log\error.txt 2>&1
IF %ERRORLEVEL% NEQ 0 ECHO Error executing SQL file

Note: user should have rights on remote server from your local machine.

edited Jul 15, 2015 at 12:26

answered Jul 15, 2015 at 11:29

Zafar Malik

6,8723 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

user755806 Over a year ago

Thanks for your reply. My local machine should have mysql.exe?

Zafar Malik Over a year ago

yes mysql.exe utility should be in your machine at the path as you mentioned in your script.

Zafar Malik Over a year ago

even you can keep this utility at any path and change that path in your script.

user755806 Over a year ago

But I should not install any mysql stuff in my local machine. How can I connect to remote mysql and run commands without installing mydql utility locally?

Zafar Malik Over a year ago

just copy mysql.exe from any other machine where mysql installed and copy at the path you mentioned in script. it will work. Without this client you can't connect remote server.

|

Collectives™ on Stack Overflow

Execute script on remote mysql db?

update.sql

update.bat

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

update.sql

update.bat

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related