5

Sql issue in shell scripting

view full story
linux-howto

http://www.unix.com – HI friends , i am also facing an issue in mysql i ma trying to insert detail in a variable but not got success Code: #!/bin/sh mysql -u<username> -p<password> <dbname> << EOF DEV=`mysql --skip-column-names <dbname> -e "SELECT timestamp from process_record where id = 1"` EOF echo $DEV ERROR 1064 (42000) at line 1: 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 '1354888190' at line 1 its means i am gettting result. but why ia m getting result (HowTos)

robot1's picture
Submitted by robot1 on 12/11/2012 – Made popular on 12/11/2012

Stories similar to Sql issue in shell scripting

The following works for me:

mysql -u 'root' -h 8.8.8.88 mo -e 'UPDATE `path_last_updated` SET timestamp="2012-01-03 00:00:00"'

However, the following does not:

TIMESTAMP=`date "+%Y-%m-%d-%T"` mysql -u 'root' -h 8.8.8.88 mo -e 'UPDATE `path_last_updated` SET timestamp=$TIMESTAMP'

How would I insert the timestamp from unix into my mysql table?

Update:

TIMESTAMP=`date "+%Y-%m-%d %T"

SSH import database 45 weeks 2 hours ago

Hi all,

I am trying to import a database in putty with the syntax:

Code: mysql –u database_username –p database_name < filename.mysql As you can see in the screenshot it asks me for the database password - which suggests that the syntax is correct - but then after I enter the password it gives me it gives the syntax error message =

Code: ERROR 1064 (42000): You have an

I have a server running Debian 5.0, and MySQL. Suddendly, MySQL stopped working, and after many attempts to fix it, I decided to reinstall it. I installed MySQL 5.1.63, and when started it goes to safe mode. I made some typing, and when I executed mysql_upgrade as root, it complained:

... Running 'mysql_fix_privilege_tables'... ERROR 1548 (HY000) at line 1111: Cannot load from mysql.proc.

I'm trying to import 641 MB MySQL database with a command:

mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql

but I got an error:

ERROR 1064 (42000) at line 2351406: 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 '<br /> <b>Fatal error</b>: Maximum execution time of 300 seconds

connecting to mysql from R 22 weeks 3 days ago

Hello

I've just installed R for the first time, along with DBI, Rmysql packages - all from package manager (using Kubuntu at the moment).

I can't connect to mysql:

Code: con1 <-dbConnect(MYSQL(), user="myname", password="mypassword", host="localhost", dbname="casualty")

 error in evaluating the argument 'drv' in selecting a method fo

I am using mysql version Server version: 5.0.77 and php version PHP 5.1.6 (cli) (built: Nov 29 2010 16:47:37) My code is below:

<?php $username="root"; $password=""; $hostname="localhost"; $dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); echo "Connected to MySQL<br>"; $selected = mysql_select_db("examples",$dbhandle) or die("Could not se

You do not put username and password in config.inc.php, this is only if you use $cfg['Servers'][$i]['auth_type'] = 'config';but this means that the user is directly logged in and only when you have created the user in mysql first. This method is not recommened. just comment out user and password and then create the user IN MYSQL.

cron wont backup my database 48 weeks 19 hours ago

I uploaded the cronjob but it wont backup my database.

I've been trying to figure out why I keep getting this error when I try to connect to the MySQL server with the following commands.

$~ mysql -u username -h SQLserver -p Enter password: ERROR 1045 (28000): Access denied for user 'username'@'myIP' (using password: YES)

I've done the following: Port is open in the firewall other wise I wouldn't get the error it'd just timeout. MySQL server not run