I'm creating script to connect to mysql and perform function. I'm into process in querying mysql from shell. Here is the content of a sample script:
Code:
#!/bin/bash
USER=scripter
PASS=test123
DB=test_scripts
Can't single the cause of the error.
mysql> CREATE TABLE Shipment (
-> Shipment_ID INT(10) NOT NULL,
-> Delivery_ID INT(10) NOT NULL,
-> Customer_ID INT(10) NOT NULL,
-> Driver_Employee_ID INT(10) NOT NULL,
-> Consignee VARCHAR(255) NOT NULL,
-> Payment_Method VARCHAR(255) NOT NULL,
-> Payment_Received VARCHAR(1) NOT NULL,
-> CONSTRAINT PRIMARY KEY (`Shipment_ID`)
-> FOREIGN KEY (`Delivery_ID`) REFERENCES `Delivery`(`Delivery_ID`)
-> FOREIGN KEY (`Customer_ID`) REFERENCES `Customer`(`Customer_ID`)
-> FOREIGN KEY (`Driver_Employee_ID`) REFERENCES `Driver`(`Driver_Employee_ID`)
-> )ENGINE=InnoDB DEFAULT CHARSET=latin1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (`Delivery_ID`) REFERENCES `Delivery`(`Delivery_ID`)
FOREIGN KEY (`C' at line 10)
1. How do I create an array with 5 entries
2. Output one of the entries in the array randomly
3. Subtract the entry output from the array
4. Repeat steps 2 and 3 until there are no more entries in the array
I have a command that outputs n lines of text, and I want to place each line into an array element, but I can't seem to get the syntax correct
So my command is this:
cat $configfile | sed -n '/cluster:'$clustername'/,/cluster/ p' | awk /host/
Which produces many lines depending on the value of $clustername. I'd like to get each line as elements of an array.
I am trying a scenario for calling a shell script when ever a trigger is called. Can some one guide me how to achieve this scenario. Also it should passes the value from the table to the shell script. Can some one explain me along with the example.
View 2 Replies View RelatedI'm using MYTHTV with AT&T's U-Verse system. AT&T apparently turns off the set-top box if the box doesn't receive any commands after some number of hours. When this happens the box takes so long to turn on that it doesn't process the lirc IR channel change command. I've rewritten my channel changer to add a lockfile, and added a cron entry to kick off an entry to just "ping" the set-top box once an hour. But, OK, I'd like to play the bandwidth saving game and not do this if there isn't anything in the "record" table.
So, how would I write a script that will check the number of rows in the "record" table in the "mythconverg" database and exit if there are zero rows? I'm afraid I don't know how to even start this. Here is my "keepalive.sh" script that does the pinging:
Code:
#!/bin/sh
#if there are no rows in the record table, just exit this script
# lock the lockfile - MUST be same one as channel lock
while [ `lockfile "/tmp/mythchanlock.lck"` ]
[Code]....
I need a little help creating a ftp script that will take connection and file details from text files.For example:ftpscript.sh - script that looks for details and does transferftpparams.txt - ftp server connection details in single line csv formatftpfiles.txt - files that need to be transfer, one file per line.I have tried using awk with no success
View 2 Replies View RelatedHow do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedI am having fedora 12 with php and mysql rpms installed on my computer.. but I am unable to log in...nether create an user?
View 3 Replies View RelatedI tried to down grade my PHP5.3.x to 5.2.6 and some how I broke the connection to my Mysql. I needed to do this for version 6.xx of Drupal. Anyone know a quick fix to the mysql.lock or do I have to re-install Mysql?Error Message:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13).
View 6 Replies View Relatedwhile creating a new database iam facing the below problem
mysql> create database auto-download-gta; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-download-gta' at line 1
what is wrong with this SQL to create a stored procedure in MySQL please?
Code:
CREATE DEFINER=`root`@`localhost` PROCEDURE `CheckStatus`(
IN start_date DATE,
IN end_date DATE)
BEGIN
[code]...
To me the syntax is correct. It complains with error 1327 'Undeclared variable: temp_sales'. What I don't understand is why I would need to declare a temporary table's name as a variable. Am I missing something here?
how to do in Debian
1. am required to create a bash-shell script called terminator that terminates all processes of a name given to the shell script as an argument. Make sure the terminator shell script will not take any crucial file system services as arguments.
2. Show how you would configure an Ethernet card by reapplying your existing IP and network mask
3. Install a workable nfs file sharing system between your system and a remote system, using optimum values for resize and wsize.To demonstrate send a 512Mb block of random data between client and server using the dd command.Write down the relevant steps and procedures
I would like to create the shell which would support the LS command in C++. And the way the command prompt can be changed.
View 7 Replies View RelatedIn a shell script, I am creating a .tar using this command
Code:
tar -zcvf dst/lib/library.tar.gz dst/lib
There are two problems:
[code]...
`cat /var/log/secure | grep "refused connect" |awk '{print $9}'|sed 's/::ffff://g'|uniq -c | sort -nr |head -2 | awk '{print $2}' >/root/sample`
for IP in `cat /root/sample`;
[code]...
I am trying to create a shell script similar to ls, but which only lists directories. I have the first half working (no argument version), but trying to make it accept an argument, I am failing. My logic is sound I think, but I'm missing something on the syntax.
Code:
if [ $# -eq 0 ] ; then
d=`pwd`
for i in * ; do
if test -d $d/$i ; then
echo "$i:"
code....
I know that it's possible to create panoramic photos very easily with hugin. But I would like to create a script for nautilus where I select my picture and then create a panoramic without any questions.I guess it's possible but I can't find on google, each time I find something about hugin.Is it possible to call from the command line and hide the interface during the process ?
View 3 Replies View Relatedi need the source code to create my own shell in linux or provide atleast procedure for doing it
View 9 Replies View Relatedhow to create Samba user using shell script
View 6 Replies View RelatedIs there some type of functional way to read things in the Python shell interpreter similar to less or more in the bash (and other) command line shells?
Example:
Code:
>>> import subprocess
>>> help(subprocess)
...
[pages of stuff to read]
...
I'm hoping so as I hate scrolling and love how less works with simple keystrokes for page-up/page-down/searching etc.
This is regarding the KDE application Basket:
I want to create a shell script that I can run as a cron job to do automated backups. how to proceed. I have the source code and have pulled out the backup source files. Here is the link for the source code. The download is at the bottom of this page. The backup files can be found in the src folder listed as backup.cpp and backup.h [URL]
If someone can do this, I believe it will make a nice addition to the Basket application for all.
Also I am not running Kubuntu I am running Karmic 9.10 64 bit
I would like to a build a CD image (of CentOS 5, x86_64 that loads into memory and boots to the OS without installing anything to hard drives. Then I would like the system to execute a shell script automatically. The shell script will have commands that will control execution.
The goal of this exercise is basically to pre-configure a system (RAID config, BIOS update, etc) automatically using the shell script before installing the OS. I would like the ability to change the shell script as needed and probably repackage the ISO image. I would prefer not to deal with building a source tree to accomplish this. this is something one could do using mkisofs.
I have a box that's used as an SFTP server. All users have restricted shell so they can only use SFTP to send and receive files. But it makes it hard to have them change their passwords. I thought that if we had a web page set up where the user could enter their username, old password, new password and confirmed new password, that this would be the easiest solution.
View 1 Replies View RelatedIs there any reason for the mysql user to need bash shell?
From /etc/passwd:
Code:
mysql:x:100:103:MySQL server:/var/lib/mysql:/bin/bash
Will anything break if I change that to /bin/false?
I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.
View 1 Replies View Related1-what is the shell command which allows me to know how many opened sessions on a mysql server?
2- what are the important points we can manage in a mysql server?
I just downloaded MySQL-Workbench and I see it in the folder: Code: /usr/bin how do I access it from my desktop without having to tie up my bash shell because the only way I can get to it right now is
Code:
cd /usr/bin
mysql-workbench
and only when I close the program can I use my bash for anything else.
from nmap localhost | grep mysql command i will come to know whether mysql server is running or not.my problem is i want to test whether mysql server is running or not in shell script and if it is running i need to tell the user to stop the server to run the shell script.
View 3 Replies View Relatedi want to know how can i change the owner of the mysql data base with shell commands.
View 3 Replies View Related