07-12-2006
Guys .... i found the way...
you can.. use the line below to execute a line after your inside the mysql window.
#/usr/local/mysql/bin/mysql --user=xxx --password=xxx [db name] -e 'select * from whatever'
Anyways, thanks for those who at least saw this thread and was trying to help..
thanks a bunch
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
MySQL on my server is down....
I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock
Any suggestions?
Here's what I can't do:
can't be root
don't have physical access (do stuff via SSH)
reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies
2. Shell Programming and Scripting
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
Discussion started by: Danny_10
11 Replies
3. Linux
Hello,thanks for your help.
I can't connect my MYSQLserver , the note from my Linux System is 'Error 1130 (00000): Host 'my ip address' is not allowed to connect to this MySQL server. What could I do on this?
Thanks again! (4 Replies)
Discussion started by: lancepanda
4 Replies
4. Web Development
Hi,
I'm the new user of mysql. I facing one problem to delete one of the database in mysql. Hope can get all of your suggestion and advice.
Input:
mysql> show databases;
+-------------------------+
| Database |
+-------------------------+
| information_schema |
|... (3 Replies)
Discussion started by: patrick87
3 Replies
5. Shell Programming and Scripting
Dear folks,
i am importing a database since yesterday that is innodb tablespace, the space of dump file is 4GB, almost 24 pass out it is not yet complete. What should i do to import it fastly. I have disable foreign key check because it have some issues so thats why i am importing it with source... (2 Replies)
Discussion started by: learnbash
2 Replies
6. UNIX and Linux Applications
:confused: hi all, RHEL 4 has installed on the server, when i use rpm -i command to install mysql5.1 enterprise version, error failed dependencies occurs as below:
mysql conflicts with mysql-4.1.22-2.el4.i386
mysql conflicts with mysql-4.1.22-2.el4.x86_64
have tried rpm -e which was... (2 Replies)
Discussion started by: maxlee24
2 Replies
7. Shell Programming and Scripting
Hi Experts,
I am a beginner of PHP and trying to create a tutorial database. My web interface takes a value and inserts into table very correctly. But when I refresh the same interface, it inserts the same value again and again. My code is below:
<?php
$con =... (2 Replies)
Discussion started by: naw_deepak
2 Replies
8. Web Development
Hi, I had a chance to create a database refreshing the previous post. An error was tossed out with the following message:DBI connect('nr20111117_db','yifangt',...) failed: Unknown database 'nr20111117_db' at create-nrDB-20111214.pl line 17
Cannot connect: Unknown database 'nr20111117_db' at ... (6 Replies)
Discussion started by: yifangt
6 Replies
9. AIX
Hi,
Trying to setup mediawiki on a system but having problems configuring mysql:
CC=/usr/bin ./configure
checking build system type... powerpc-ibm-aix6.1.0.0
checking host system type... powerpc-ibm-aix6.1.0.0
checking target system type... powerpc-ibm-aix6.1.0.0
checking for a... (9 Replies)
Discussion started by: vpundit
9 Replies
10. Red Hat
Hi i am trying to install mysql rpm package on my linux machine but getting below error :
warning: MySQL-embedded-5.5.28-1.rhel5.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL-devel is needed by MySQL-embedded-5.5.28-1.rhel5.i386
... (9 Replies)
Discussion started by: mukulverma2408
9 Replies
LEARN ABOUT DEBIAN
bp_meta_gff
BP_META_GFF(1p) User Contributed Perl Documentation BP_META_GFF(1p)
NAME
bp_meta_gff.pl - Get/set Bio::DB::GFF meta-data
SYNOPSIS
# set the following meta data values
% bp_meta_gff.pl -d testdb tag1=value1 tag2=value2
# get the indicated meta data value
% bp_meta_gff.pl -d testdb tag1 tag2
DESCRIPTION
This script gets or sets metadata in a Bio::DB::GFF database. Not all adaptors support this operation! To set a series of tags, pass a
set of tag=value pairs to the script. To get the contents of a series of tags, pass the bare tag names.
The output from the get operation will be an easily parseable set of tag=value pairs, one per line.
COMMAND-LINE OPTIONS
Command-line options can be abbreviated to single-letter options. e.g. -d instead of --database.
--database <dsn> Mysql database name (default dbi:mysql:test)
--adaptor <adaptor> Mysql adaptor (default dbi::mysqlopt)
--user <user> Username for mysql authentication
--pass <password> Password for mysql authentication
SEE ALSO
Bio::DB::GFF
AUTHOR
Lincoln Stein, lstein@cshl.org
Copyright (c) 2002 Cold Spring Harbor Laboratory
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See DISCLAIMER.txt for
disclaimers of warranty.
perl v5.14.2 2012-03-02 BP_META_GFF(1p)