Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


Unknown command '\;'


Login or Register to Reply

 
Thread Tools Search this Thread
# 8  
Thank you so much Rudic!
It's almost okay. The only error is at here:
In barisprep code:
Code:
'a:1:{i:0;s:2:'" $2

gives:
Code:
'a:1:{i:0;s:2:'en';}'

How may I change it to:
Code:
'a:1:{i:0;s:2:"en";}'


Thank you
Boris
# 9  
Hey c'mon, Baris, that should be easily doable by yourself, don't you think? You did similar things in your post #4.
# 10  
:/ Yes, I did before posting. This is my 2nd try:

Changed the part as:
Code:
'a:1:{i:0;s:2:'" \"$2\"

gives:
Code:
awk: 2: unexpected character '\'
awk: 3: unexpected character '''
awk: barisprep: line 3: runaway string constant "} ...

Also tried without escape:
Code:
'a:1:{i:0;s:2:'" "$2"

gives single quote:
Code:
{i:0;s:2:'$2';}'

Thank you
# 11  
Did you look at what youdid in post #4? This a:1:{i:0;s:2:\"$COL2\";}" is close ... complete it with two unescaped double quotes.
This User Gave Thanks to RudiC For This Post:
# 13  
FWIW - it seems to me you may not know about a shell facility called a here document.

It lets you write code that dynamically enters data for another program like mysql, and behaves as is if it was you directly typing into the program. What you are doing is temporarily replacing stdin with a shell script or an awk script, or a really complex set of statements, etc. The kind of thing data entry staff employees did 50 years ago.

Syntax: we are going to feed the program yesterday's date and last Friday's date, as a very simple example (uses linux/GNU date in the example)
Code:
/path/to/program  <<EOF   [ > /path/to/output file, write program stdout  from program to a file -- optional feature]
me 
password
date -d yesterday
date -d "last friday"
EOF                 
# thanks to RudiC for finding the typo.

the <<EOF tells the shell to start feeding "keystrokes" to /path/to/program EOF is block name could be anything, Charlie or Baris or !
the EOF marks the end of the code block. This has to be in the LEFTMOST column
Most of what you asked for help with can be handled more easily with a here document.

Last edited by jim mcnamara; 05-08-2019 at 07:13 PM..
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
There's a unknown command on line 1 and i don't know whats causing it.
thatguy565
My OS is Linux GL version 2.4.26. I am trying to make a shell script that outputs a chart displaying info of who is online, boot time, and the real time, I have manage to get it to work, but I still get the error "./user/script: line 1: : command not found." I do in fact have access to root, if...... Shell Programming and Scripting
2
Shell Programming and Scripting
'SP2-0734: unknown command beginning "elect' Error
aimy
My environment is HP-UX... NIS CEL | uname -a HP-UX s53kj113 B.11.11 U 9000/800 1510201964 unlimited-user license I ran this command directly from the server's sqllplus. Logically, it should have work. But in my case, it always escaped the 1st character of the next command after the...... HP-UX
3
HP-UX
Sed unknown command
BlueberryPickle
Hi everyone, I am trying to replace a string that contains a space using sed. A typical input file is: CATEGORY=1 1:1.0 CATEGORY=2 13:1.0 CATEGORY=3 1:99.0 CATEGORY=8 14:1.0 CATEGORY=11 1:1.0 I want to use a string (as it can change) to make replacements using ...... Shell Programming and Scripting
3
Shell Programming and Scripting
PING - Unknown host 127.0.0.1, Unknown host localhost - Solaris 10
Przemek
Hello, I have a problem - I created a chrooted jail for one user. When I'm logged in as root, everything work fine, but when I'm logged in as a chrooted user - I have many problems: 1. When I execute the command ping, I get weird results: bash-3.00$ usr/sbin/ping localhost ...... Solaris
4
Solaris
<drive type unknown> when format command run
prvnrk
Hi, we are running solaris 9 on V280R. Due to power failure, one disk's label and lost its details like drive type etc. Disk details: <SUN72G cyl 14087 alt 2 hd 24 sec 424> single partition on slice 6 with UFS. The below i see when i run "format" command ..... ..... 4....... Solaris
1
Solaris

Featured Tech Videos