Batch File: MySQL Database Backup (mysqldump.exe)

Hi there,

I need to modify this batch file command line to backup MySQL database running on a remote Linux server at address 192.168.1.10:3306

mysqldump.exe -u%mysqluser% -p%mysqlpassword% --opt --databases %mysqldatabasename% > %localdir%\%backupfilename%

EXTRA QUESTION:
Will the modification you propose to my command line can be applied as is to a "mysqlcheck.exe" command line?

PS: it works on local database.

Thanks for your help,
Rene
LVL 10
ReneGeAsked:
Who is Participating?
 
hernst42Connect With a Mentor Commented:
for dump you should be able to use -h remote.host
for check also
0
 
ReneGeAuthor Commented:
Will try it later tonight and let you know.

Thanks and cheers,
Rene
0
 
ReneGeAuthor Commented:
I feel that the information in my question was misleading.

Finally, "--command" was required in the batch file.

So "--host remote.host" was the answer.

Your answer provided me a clue helping me to find the solution.

Thanks for your help.

Cheers,
Rene


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.