vicidial.org

Posted: **Tue Jan 12, 2010 2:49 pm**

I am have created a SH file.

In that I have a line

mysql -uroot -pvicipass

After this Line I want to execute few sql queries.

How to do that ?

Posted: **Tue Jan 12, 2010 3:06 pm**

ok so you want to create a sh file that will be executed after
of say same sql queries you want then and i will help you .
or create you date base file .sql then call it as this for exemple .
mysql --user="user" --password="password" < /root/sample.sql

Posted: **Tue Jan 12, 2010 3:09 pm**

ok so you want to create a sh file that will be executed after
of say same sql queries you want then and i will help you .

I am looking for this.

Posted: **Tue Jan 12, 2010 4:37 pm**

Enter your SQL syntax

Make the file executeble

Run it

Posted: **Tue Jan 12, 2010 5:58 pm**

An Example will definitely help.

Posted: **Tue Jan 12, 2010 6:08 pm**

example of what?

http://www.freeopenbook.com/mysqlcookbo ... CT-33.html

Posted: **Tue Jan 12, 2010 7:09 pm**

This is what I am trying to do ..

Sql.sh:
======================
mysql -uroot -pvicidialnow
Use asterisk;
Insert Into ...... blah blah...
Insert Into ...... blah blah...
Insert Into ...... blah blah...
Insert Into ...... blah blah...
Insert Into ...... blah blah...
Update..... ...... blah blah...
Exit

I tried chmod +x switch. But it gets stuck after getting into mysql and after I enter EXIT, then it tries to run sql command.

Posted: **Tue Jan 12, 2010 9:36 pm**

ok we will do a small exemple here:
first thing we will create a file sample.sh
we will write this:

#!/bin/bash
echo "welcome to our script"
echo "------------------------"
echo " drop database asterisk if exist"
mysql --user=cron --password=1234 --execute="DROP DATABASE IF EXISTS `asterisk`;"
echo "-----------------------"
echo "create asterisk database"
mysql --user=cron --password=1234 --execute="create database 'asterisk' default character set utf8 collate utf8_unicode_ci;
echo "---------------------------"
echo "use database asterisk"
mysql --user=cron --password=1234 --execute="use 'asterisk';"
echo "---------------------------"
echo" "create table mytable"
mysql --user=cron --password="CREATE TABLE 'mytable' (
'P_Id' int, 'LastName' varchar(255), 'FirstName' varchar(255), 'Address 'varchar(255), 'City' varchar(255) )"
echo "---------------------------"
echo "insert data in table mytable"
mysql --user=cron --password="INSERT INTO 'mytable' ('FirstName', 'Address', 'City') VALUES ('111', '222', '333');"
echo "---------------------------"
echo "bye bye"

then save your file sample.sh for exemple in /usr/local and run it
chmod 777 -R /usr/src/sample.sh
./usr/src/sample.sh

if they are same thing mistake please correct it :wink:

enjoy

Posted: **Tue Jan 12, 2010 9:54 pm**

Perfect !!!

Awesome and Thanks { though thats spoon feeding }.

Here is the Updated and a BIT corrected :

#!/bin/bash
echo "Welcome to our script"
echo "------------------------"
mysql -uroot -pvicidialnow -e "use asterisk;CREATE TABLE mytable (P_Id int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255))"
echo "---------------------------"
echo "insert data in table mytable"
mysql -uroot -pvicidialnow -e "use asterisk;INSERT INTO mytable(FirstName, Address, City) VALUES ('111', '222', '333')"
echo "---------------------------"
echo "bye bye"

vicidial.org

SH file

SH file

thanks

thanks