Re: How can i execute sql commands using jenkins

2020-04-14 Thread Kumar Praful
Hi All, I have almost similar requirement. I am taking backup of databases (as .sql file ) through cron job daily on ubuntu system. Now, I am thinking to run a mysql in docker container and then through Jenkins pipeline job (groovy), I want to restore the db backup file in the docker mysql back

Re: How can i execute sql commands using jenkins

2019-05-01 Thread farrukhf
Hi My Scenario is that what if i want to run multiple queries using jenkins time to time . As using shell script i need to change the script every time for which i have to login server . On Monday, January 23, 2017 at 7:13:07 PM UTC+5:30, Sivakrishna Yarra wrote: > > Hi, > I am using Jenkins as

Re: How can i execute sql commands using jenkins

2017-01-23 Thread Sivakrishna Yarra
Thanks man.. I got it On Mon, Jan 23, 2017 at 8:39 PM, wrote: > If I remember well, the command return value is the fail/pass. So you may > want to craft your command to return non 0 and make the build fail when > something did not goes as planed. > > -- > You received this message because you a

Re: How can i execute sql commands using jenkins

2017-01-23 Thread jerome
If I remember well, the command return value is the fail/pass. So you may want to craft your command to return non 0 and make the build fail when something did not goes as planed. -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe

Re: How can i execute sql commands using jenkins

2017-01-23 Thread Sivakrishna Yarra
I am using old way like i had copied the shell script file in to linux server. Through Jenkins job i am calling the shell script. On Mon, Jan 23, 2017 at 7:55 PM, wrote: > Are you running inside a pipeline script or the "old" way? > > pipeline: https://jenkins.io/doc/book/pipeline/ > "old" way:

Re: How can i execute sql commands using jenkins

2017-01-23 Thread jerome
Are you running inside a pipeline script or the "old" way? pipeline: https://jenkins.io/doc/book/pipeline/ "old" way: https://goo.gl/images/uKcWFd If this is a new project, you may want to try the new pipeline, it will make thing more flexible. -- You received this message because you are subs

Re: How can i execute sql commands using jenkins

2017-01-23 Thread Sivakrishna Yarra
Hi Jerome, Thanks for the info. I have a *.sql file* which contains multiple set of queries. I will execute this *.sql* *file *by using shell script. For this script i had created a Jenkins Job. But How i will get to know from JenkinsCI if any exception has came ..? On Mon, Jan 23, 2017 at 7:18 P

Re: How can i execute sql commands using jenkins

2017-01-23 Thread jerome
Hi, you need to execute either a bat or sh command with the mysql binaray: https://dev.mysql.com/doc/refman/5.7/en/mysql.html You can either cat the command into a temporary file then pipe it to the command or have the scripts already prepared. Jerome -- You received this message because you

How can i execute sql commands using jenkins

2017-01-23 Thread Sivakrishna Yarra
Hi, I am using Jenkins as a CI. how can i execute sql statements by using jenkins tool. I am using Mysql is the database. Can you please help on this. -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop rece