Now that all of the latest distros of OSX use bash by default, I thought I
would amend this with bash instructions.
When you instantiate a shell in OSX, the ~/.bash_login file is parsed.
Because this isn't a global file you can edit it just like the .tshrc below.
The entry you need to make is:
ex
Hi Steve,
You have to edit a file called ".tcshrc" which resides in your users
home directory, and add ":/usr/local/mysql/bin" to the PATH
environment variable.
The tricky part is, this file is not visible to any text editor (for
example BBEdit), so I always use a command line editor, for
At 10:29 -0800 2/23/05, Nupur Jain wrote:
I am executing a mysql query through shell and expecting to see a
return of SQL execution.
mysql -D $dbName --vertical -u $DBUSER -p$DBPASS < $queryFile > $opFile
rc=$?
Here rc is always 0 and so are $opFile entries. $queryFile contains
exactly the same
On Wednesday, February 23, 2005 12:30, Nupur Jain wrote:
> I am executing a mysql query through shell and expecting to see a
> return of SQL execution.
>
> mysql -D $dbName --vertical -u $DBUSER -p$DBPASS < $queryFile >
> $opFile
> rc=$?
>
> Here rc is always 0 and so are $opFile entries. $qu
On Wed, 23 Feb 2005, Nupur Jain wrote:
Hi Nupur,
I am executing a mysql query through shell and expecting to see a return of SQL
execution.
mysql -D $dbName --vertical -u $DBUSER -p$DBPASS < $queryFile > $opFile
rc=$?
Here rc is always 0 and so are $opFile entries. $queryFile contains exactly the
The way I usually do it is this..
I have a shell scipt called "query"
It contains:
/fullpath/mysql --user=root --password= Database_Name
I then make new scripts for the queries as such:
(query file name: Select_all.sql)
Select * from Table where blah=foo;
To run this I then execute
Mike Tuller wrote:
I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name (column_name) VALUES ("value");
After I
The first line starts mysql.
When mysql exits, the second line does nothing, as it is not a valid
shell command.
try :
echo 'INSERT INTO table_name (column_name) VALUES ("value")' | mysql
--user=root --password= Database_Name
Or put the second line in a file, and cat the file through a
Put the full path to mysql in the script...
Jeff
> -Original Message-
> From: Mike Tuller [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 10, 2003 1:07 PM
> To: [EMAIL PROTECTED]
> Subject: Shell Script to Insert Data
>
>
> I am trying to create a script that will insert data. Righ
En réponse à Ilyas Keser <[EMAIL PROTECTED]>:
Hi
you can use mysqldump et a crontab to save all databases in a text file.
Regards
Julien Sobrier
> Hi all...
>
> I am a new Linux user. Does any one have a shell script to backup all
> Mysql databases?
>
> Thanks
> ilyas...
>
> -
You could use something like :
mysqldump -Q --opt -F --all-databases -h serverName -u root
--password=yourpasswd > /some/where/backup.sql
It generates a SQL commands file able to completely rebuild the DB, e.g.
useful after a mysql_install_db command.
Ciao,
Stefano
> -Original Message
On Thu, 18 Jul 2002, Ilyas Keser wrote:
> Hi all...
>
> I am a new Linux user. Does any one have a shell script to backup all
> Mysql databases?
Read The fine Manual - it gives several ways.
-
Before posting, please check:
mysqldump -opt > everything.sql
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 8:44 AM
To: [EMAIL PROTECTED]
Subject: shell script to backup
Hi all...
I am a new Linux user. D
At 9:42 -0800 1/26/02, mike vogel wrote:
>can anyone recommend a command line shell to admin mysql that will
>run under osX? thanks in advance!
What does that mean? From the wording of the question (command line shell),
it sounds like you're asking about tcsh, bash, etc., but from "admin mysql
Rolf Hopkins wrote:
>
> What you have just described means that database permissions have not been
> set up correctly and your ISP has left himself wide open for all kinds of
> attacks and I'm not just talking about attacks on the database itself but
> also attacks on the whole system. Ie access
t;[EMAIL PROTECTED]>
To: "clay bond" <[EMAIL PROTECTED]>
Cc: "mysql@lists. mysql. com" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 21:18
Subject: Re: Shell Shocking
> Problem is that most ISPs can't afford a competent DBA...;(
>
> clay
Absolutely this is nothing short of bad adminingIbet you could scag in their
passwd file and has root access in short order...;( And of course the ISP will blame
mysql if anything happens to them though...lazy bad ISP
cheers,
mikel
Donald Korth wrote:
> Hello
>
> The hosting company
Problem is that most ISPs can't afford a competent DBA...;(
clay bond wrote:
> On Tue, 13 Feb 2001, Donald Korth wrote:
>
> > The hosting company has given me a user name and passwd . When i log into my own
>site thro' a telnet session i 'm able to view all the databases created in the server
On Tue, 13 Feb 2001, Donald Korth wrote:
> The hosting company has given me a user name and passwd . When i log into my own
>site thro' a telnet session i 'm able to view all the databases created in the server
>that includes DBs not created by me . I also did a "USE DB" command to connect t
Donald,
Poor administration of the server or incorrect privileges assigned to your user
account.
Donald Korth wrote:
> Hello
>
> The hosting company has given me a user name and passwd . When i log into my own
>site thro' a telnet session i 'm able to view all the databases created in t
20 matches
Mail list logo
