Hi,
this Thursday, Giuseppe Maxia will give a MySQL University session:
http://forge.mysql.com/wiki/Advanced_LUA_Scripting
(topic: Advanced LUA Scripting)
Please register for this session by filling in your name on the session
Wiki page. Registering is not required but appreciated. That Wiki
Hi,
Why don't you run the CREATE TABLE query with the IF NOT EXISTS clause
then your script could look like this
CREATE TABLE IF NOT EXISTS table_name ...;
ALTER TABLE table_name;
If the table already exists only the ALTER statement will be executed,
otherwise the ALTER statement will not do any
Hey all,
I've got a question for you. What would be the best way to set up a set of
srcipts to create\Update the databse when my app is installed?
The problem is that I obviously can't just drop the database cause if the
database is already installed then the client would lose all his data. I n
Hi.
Remove ';' from the end of the line.
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]
>
> I am trying to utilize MySQL's batch execution functionality by using build scripts
> to create tables in my database (ref:
> http://dev.mysql.com/doc/mys
Hi.
System error: 2 = No such file or directory
Check if file exists. Do you have permissions to read this file?
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]
>
> I am trying to utilize MySQL's batch execution functionality by using build s
I am trying to utilize MySQL's batch execution functionality by using build scripts to
create tables in my database (ref:
http://dev.mysql.com/doc/mysql/en/Batch_Commands.html )
Is it possible to execute additional source files from within a source file from the
MySQL command line?
Ex:
mysql
Brad Tilley <[EMAIL PROTECTED]> wrote:
>
> Is there a way to do regex search are replace on all entries in a mysql field?
> Or, a way to uppercase or lowercase all characters for all entries in a
> filed? Some of the fields are varchars with numbers and letters. In my
> particular case, I have
Hello again,
Is there a way to do regex search are replace on all entries in a mysql field?
Or, a way to uppercase or lowercase all characters for all entries in a
filed? Some of the fields are varchars with numbers and letters. In my
particular case, I have a field of serial numbers some of wh
Linux, Solaris and many others. If you wanted a simple scripting
language you could use the Rhino project from Mozilla and create a
basic java application that launches java script giving you a true
scripting language that can access all the goodness of java.
From what I understand there are
from web-based
applications. PHP is a server-side, HTML-embedded, cross-platform scripting
language. It supports DB2 access using the Unified-ODBC access method, in
which the user-level PHP communicates to DB2 using ODBC calls. Unlike
standard ODBC, with the Unified-ODBC method, communication is dire
rom: Rhino [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 04, 2004 8:30 AM
> To: HACKATHORN, TODD (SWBT); [EMAIL PROTECTED]
> Subject: Re: Scripting
>
> Todd,
>
> I'm also pretty new to MySQL and Linux but I have years of DB2 experience on
> various platforms.
>
one connection to import the data.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/4/04, 9:11:02 AM, "HACKATHORN," TODD "(SWBT)" <[EMAIL PROTECTED]> wr
BNAME;
> >/usr/bin/mysqldump --opt --verbose -u${USERID} -p${PASSWORD}
> > ${ONE_DBNAME} -r ${BACKUP_PATH}"/"${ONE_DBNAME}"."${BACKUP_TI
> >echo ">> Deleting these old backups for this database..."
> >/usr/bin/find $
abase
server? To make two connections and pull data from one to the other?
Thanks,
Todd Hackathorn
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 8:30 AM
To: HACKATHORN, TODD (SWBT); [EMAIL PROTECTED]
Subject: Re: Scripting
Todd,
I'm also
EP -name $ONE_DBNAME'*' -exec rm '{}' ';';
> #delete old
> done
>
> echo
> echo "** REPORT ENDS **";
> ---
>
> If you want to take a backup manually with this script (and omit the email
> being sent to you), you can do this from the
bstacle you're going to face in writing bash scripts is
the lack of good tutorials on it. There are umpteen bash references that
show you generic syntax and tell you the terminology used by bash but darned
few decent tutorials to show you how to write bash scripts. Some people can
do anything they
Hello,
I am new to Linux, and mySQL. I am currently a MsSQL Server 2000 and VB
programmer, but trying to break away from that side. I have my database set
up and working great, but I am really struggling on how to perform scheduled
updates, and data imports. Can anyone please point me to a good
That worked like a charm, thanks so much! I don't know why I didn't try
that before!
Julian
At 02:46 PM 11/21/2003 -0600, Paul DuBois wrote:
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea of
creating a tale for each day. M
ql List
Subject: RE: DB design question - shell scripting...
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea
of creating a tale for each day. My thoughts were to write a shell
script to do this for me, but I am running into a pr
Wouldn't this also work?:
mysql -u root -p -e "CREATE TABLE t$date(...)" yourdatabase
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 12:46 PM
To: Julian Zottl; Andy Eastham; Mysql List
Subject: RE: DB design question -
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea
of creating a tale for each day. My thoughts were to write a shell
script to do this for me, but I am running into a problem: I wrote
the following:
#!/bin/sh
date=`date "+%m%
Andy,
Thanks for responding. I think that I am going to go with the idea of
creating a tale for each day. My thoughts were to write a shell script to
do this for me, but I am running into a problem: I wrote the following:
#!/bin/sh
date=`date "+%m%d%Y"`
export date
mysql -u root -p < createdb.
At 12:25 -0500 3/2/03, Stephen Tiano wrote:
Paul, Oliver--
I really, really appreciate you guys taking time from your
respective Sundays to try and enlighten me. But I'm still getting
nowhere fast.
I've gotten it to this:
I open a new shell and type:
/usr/local/bin/mysql --local-infile -u
I'm fairly new to MySQL as well (although, I do have experience with Oracle).
Even though you create a new database doesn't mean that MySQL will
automatically start using that database. After all you might want to
create 10 or 15 databases all at once (why? I don't know), then start
creating ta
Guys, Guys--
I got it! I stopped being a dimwit long enough to realize that the
change to "USE Temp;" below was for INSIDE the script.
When I made that change and again went to a new shell and typed
(actually, I dragged the file from the window in which it sat in the
Finder into the Terminal a
Paul, Oliver--
I really, really appreciate you guys taking time from your respective
Sundays to try and enlighten me. But I'm still getting nowhere fast.
I've gotten it to this:
I open a new shell and type:
/usr/local/bin/mysql --local-infile -u root -p [the full pathname up
to]/Temp.sql
a
Hy Steve,
> USE DATABASE Temp;
try to change this into :
USE Temp;
and try it again, this should work.
HTH
Oliver
for the filter : sql,query,queries,smallint
-
Before posting, please check:
http://www.mysql.com/manual.
Paul,
Thanks very much for responding.
I tried what you suggested, but got:
ERROR 1102: Incorrect database name '/Users/stephent/Sites/Temp.sql'
I don't get this. What wrong database name? The script is supposed to
create the database and a table in it. What an I too dense to see?
Thanks a
At 8:53 -0500 3/2/03, [EMAIL PROTECTED] wrote:
I'm doing all kinds of exercises and tutorials to get up to speed on MySQL
on my PowerBook with OS X.2 running. I just tried an exercise that, for the
first time, had me creating a table not right in the MySQL monitor, but,
rather, via a script that I
Oliver,
Thanks for responding. Foolish of me to be in such a rush that I wasn't
watching what I was copying and pasting. I actually did use the command
you suggest below. And that's what drew the error message.
So I'm back to the drawing board.
Take care, and thanks again--
Steve
Hy Steve,
Hy Steve,
> bin/mysql -p http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I'm doing all kinds of exercises and tutorials to get up to speed on MySQL
on my PowerBook with OS X.2 running. I just tried an exercise that, for the
first time, had me creating a table not right in the MySQL monitor, but,
rather, via a script that I saved as a textfile--Temp.sql--and then call
th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I have, with the generous help of Michael Babcock, worked out what I
think is a reasonable way to protect the credit card numbers in my
database from improper access. Basically, only the server (better yet,
some other server) can access th
Greetings!
Introducing JudoScript, a full-fledged scripting
language that supports genuine JDBC scripting. Free
form SQL statements can be specified and executed
either individually or in a group or batch.
Expressions can be embedded in the SQL statements.
SQL statements can be prepared and run
Hello all,
I'm working on a tcsh script (using MacOSX 10.0.4) that performs a mysql
query and pipes the output to the mail command.
When I execute the script from the command line as root, it executes
perfectly.
However, when I allow the script to execute via /etc/crontab, (which is
what I r
I just saw something on freshmeat.net called EPM (ESP Package Manager)
that purports to be able to assemble AT&T .pkg files for you (as well as
other popular package formats, .bpkg, .rpm, etc). Haven't tried it, let
me know if it works out for you.
-Aaron
On Tue, 23 Jan 2001, James Raff wrote:
Are there any facilities or gurus who could write a .pkg file to help us Linux newbies
upgrade MySQL on a RaQ4 box? The most recent version from Cobalt is 3.22.32 and we
would like to go to 3.23.30 but do not feel confident to write a .pkg for this
machine. We are prepared to pay for the file a
37 matches
Mail list logo
