Path issue with script to run MySql command 1

[ChrisRChamberlain]

Hi all

Mysql newbie so please be gentle.

mysql -uroot -pPassword mydatabase < /var/data/backup/mydatabase.sql

correctly restores a MySql database from a backup when run in the terminal.

Want to run this ultimately as a cron job, but

#! /bin/bash

/etc/init.d/mysql -uroot -pPassword mydatabase < /var/data/backup/mydatabase.sql

does not work.

Would appreciate the error(s) being corrected.

TIA

FAQ184-2483​

Chris
PDFcommander.com
motrac.co.uk

 

[feherke]

Hi

does not work.

Would appreciate the error(s) being corrected.

[ul]
[li]How do you know it does not work ?[/li]
[li]What it does instead of working ?[/li]
[li]Are there error messages ? If yes, what they say ?[/li]
[/ul]


Feherke.

http://free.rootshell.be/~feherke/

 

[ChrisRChamberlain]

feherke

Thanks for your reply.

If the script file is run, the terminal window simply flashes momentarily, where as in the terminal with '--verbose' in the command, you can observe the progress of the restore.

I am unaware as to how to find the relevant logfile, assuming there is one, or how to output the error(s) to a file?

FAQ184-2483​

Chris
PDFcommander.com
motrac.co.uk

 

[vacunita]

Its likely producing an error, but in common Terminal Window operation for a few years now in both Windows an Linux, the Terminal Windows that are open from a shortcut, or batch file etc.., will self close when the execution of said shortcut or file is done.

To see what is actually happening open a terminal window the normal way, and from that terminal window call your job file.

You'll likely get to see the error which, unless its a formatting issue when you copied and pasted the command here, I'd wager is caused by the fact that your input file's path seems to be on another line which breaks the command.



----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Behind the Web, Tips and Tricks for Web Development.

http://behindtheweb.blogspot.com/

 

[feherke]

Hi

Ah ! I missed it previously. You are trying to use /etc/init.d/mysql as MySQL client, but that is the init script of the MySQL daemon. Use /usr/bin/mysql instead.


Feherke.

http://free.rootshell.be/~feherke/

 

[ChrisRChamberlain]

feherke

Thanks for that, well spotted, it now works correctly.

vacunita

Thanks for your reply

The error message produced running the script that way still did not give much of a clue - it was concerned with using service(8) utility, e.g. service mysql -uroot, etc.

FAQ184-2483​

Chris
PDFcommander.com
motrac.co.uk