[mdlug] Help with MariaDB and Bash scripting

[Mathew May]

Carl, you sir are my hero!!!  Session is exactly the issue.  I will have to
chain commands in order to do the steps that need to be done while
foreign_key_checks=0.

Days of google searching and pounding my head on the wall are over!

On Wed, Mar 16, 2016 at 1:34 PM, Carl T. Miller <carl at carltm.com> wrote:

> I suspect that setting the foreign_key_checks only
> survives within the current session.  Try this and
> let me know the output.  If my theory is right, it
> will be show 0 then 1.
>
> $MYSQL -u root -p$DB_PASS -e "set foreign_key_checks = 0;
> show variables like '%foreign%';"
> $MYSQL -u root -p$DB_PASS -e "show variables like '%foreign%';"
>
> c
>
>
> Mathew May wrote:
> > Hey guys,
> >
> > I am trying to write a bash script that will my life a bit easier to
> > refresh database clusters in my lower environments.
> >
> > Basic overview of the process is as follows:
> > set foreign_key_checks=0;
> > drop the database
> > create the database
> > set foreign_key_checks=1;
> > rsync .sql from remote location
> > import .sql file from local file system
> >
> > rinse and repeat for each database
> >
> > The problem I am having is in executing the setting the
> foreign_key_checks
> > via a bash script. I cannot even set the variable from the command line
> >
> > Here is the line I have in my script:
> > $MYSQL -u root -p$DB_PASS -e "set foreign_key_checks = 0;"
> >
> > $MYSQL = /usr/bin/mysql
> > $DP_PASS = password for my root user
> >
> > After I run either the script (all steps except for set
> > foreign_key_checks=0; are commented out) or the command line command; I
> > log
> > into the mariadb instance and run the following command:
> >
> > show variables like '%foreign%';
> >
> > And always the value is "on"
> >
> > Is this parameter not able to be set from anywhere other then inside of
> > mysql?
> > _______________________________________________
> > mdlug mailing list
> > mdlug at mdlug.org
> > http://mdlug.org/mailman/listinfo/mdlug
> >
>
>
> _______________________________________________
> mdlug mailing list
> mdlug at mdlug.org
> http://mdlug.org/mailman/listinfo/mdlug
>