On 1/8/2016 3:14, Nitin Mehta wrote:
Looks like some kind of locking mechanism in the application. Should not be a
database issue.
On Friday, January 8, 2016 10:47 AM, geetanjali mehra
wrote:
Hi all,
Suddenly I have started getting below error from our web site:
'command
Am 08.01.2016 um 10:14 schrieb Nitin Mehta:
Looks like some kind of locking mechanism in the application. Should not be a
database issue.
no true - this is a native mysql error message!
honestly both of you should have used Google
http://dev.mysql.com/doc/refman/5.7/en/commands-out-of
Hi all,
Suddenly I have started getting below error from our web site:
'commands out of sync, you can't run this command now'
This error is generated sometimes when opening a page ,and immediately
after refreshing the page, error gone.
Can you please help me to troubleshoot this
9.3.388.rhel6.x86_64 it does not
> seem to work. I've added "syslog"/"syslog ON" to my my.cnf server
> configuration file but no info about executed commands in logs.
>
> I've also read
> http://www.mysqlperformanceblog.com/2008/07/08/logging-your-mysql-com
cona
> Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64 it does not
> seem to work. I've added "syslog"/"syslog ON" to my my.cnf server
> configuration file but no info about executed commands in logs.
>
> I've also read
> http://www.mysqlperforma
Hi,
You can check out the McAfee MySQL Audit Plugin at:
https://github.com/mcafee/mysql-audit
It is an open source plugin providing audit capabilities for MySQL. It can be
used to log executing commands. It can log to a file or over a unix domain
socket to syslog-ng.
Best,
Guy
=1#client-variables
but despite the fact that I use percona
Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64 it does not
seem to work. I've added "syslog"/"syslog ON" to my my.cnf server
configuration file but no info about executed commands in logs.
I've also re
Wrapping even just selects around a transaction absolutely matters,
depending if you care about isolation.
Consider the following two clients running on the same mysql instance, w/
--transaction_isolation=serializable. Suppose we have the following innodb
table:
CREATE TABLE FOO (i INTEGER, j INTE
Hello
COMMIT statements may or may not force the database to call fflush() to flush
your double-write to disk. This may or may not affect your performance,
depending on your scale, traffic, and how much you're trying to squeeze your
hardware. If you're working on the borderline like I am, benc
I vote 1) yes 2) no
It could be result of the app developer's convenience to just wrap anything
they submit to the database in a transaction. Selects are not transaction but
autocommit/commit do no harm. That might be the thinking.
On 09.04.2012, at 11:38, Rozeboom, Kay [DAS] wrote:
> We
We have an application with blocks of code that begin with setting autocommit
off, and end with a commit. The code in between does only selects, no updating.
1) Am I correct in thinking that the autocommit and commit statements
don't really accomplish anything useful?
2) If the autoc
Not sure exactly what you mean by 'setting date/time right'. Mind
clarifying a little?
-Original Message-
From: Pintér Tibor [mailto:tib...@tibyke.hu]
Sent: Thursday, November 19, 2009 9:10 AM
To: James Coffman
Subject: Re: MySQL being hacked with commands through URL
Jam
Coffman
Cc: mysql@lists.mysql.com
Subject: Re: MySQL being hacked with commands through URL
The bits in your date_format call are confusing your sprintf call
"date_format(updated, '%W, %M %D, %Y %r' )"
elseif ($pageID == "ss" && $item != "mostCurrent")
egrate it into code that I did not write. Is there anyone out
> there that may have some insight to this problem?
>
> -Original Message-
> From: Wm Mussatto [mailto:mussa...@csz.com]
> Sent: Wednesday, November 18, 2009 11:55 AM
> To: mysql@lists.mysql.com
> Subject: Re
e out there
that may have some insight to this problem?
-Original Message-
From: Wm Mussatto [mailto:mussa...@csz.com]
Sent: Wednesday, November 18, 2009 11:55 AM
To: mysql@lists.mysql.com
Subject: Re: MySQL being hacked with commands through URL
On Thu, November 19, 2009 09:47, Jame
James Coffman wrote:
Hello all,
My website has been hacked using a url such as:
-1%20union%20all%20select%201,2,concat(username,char(58),password),4,5,6%20f
rom%20users-- .
I have been searching on the web for a solution/fix to this issue and I
cannot seem to find one. The
only accept
0-9s as input. Hope this helps.
How do you have your database server setup? How are the commands being
passed to the database?
--
William R. Mussatto
Systems Engineer
http://www.csz.com
909-920-9154
--
MySQL General Mailing List
For list archives: http://lists.mysql
With respect, denying all access to 'users' for anything except
r...@localhost sounds like trying to cure dandruff by decapitation.
Firstly your web app shouldn't be using root to access your data
tables and secondly there's every chance his web server is seperate
from his db server. You should hav
Hi
First things first - prevent access apart from r...@localhost to the users
table
Neil
On Wed, Nov 18, 2009 at 5:50 PM, Gary Smith wrote:
> James Coffman wrote:
>
>> Hello all,
>>
>>My website has been hacked using a url such as:
>>
>> -1%20union%20all%20select%201,2,concat(u
James Coffman wrote:
Hello all,
My website has been hacked using a url such as:
-1%20union%20all%20select%201,2,concat(username,char(58),password),4,5,6%20f
rom%20users-- .
I have been searching on the web for a solution/fix to this issue and I
cannot seem to find one. The
> From: James Coffman [mailto:webmas...@cadc.com]
> Hello all,
>
> My website has been hacked using a url such as:
> -1%20union%20all%20select%201,2,concat(username,char(58),passw
> ord),4,5,6%20f
> rom%20users-- .
Without more information, it sounds like simple SQL insertion
holder mechanism.
For example if I'm expecting a page number (or other whole number) from
form variable PAGEID I do something like this.
($pid) = $q->param('PAGEID') =~/(\d+)/; Basically it will only accept
0-9s as input. Hope this helps.
How do you have your database server
> From: James Coffman [mailto:webmas...@cadc.com]
> Hello all,
>
> My website has been hacked using a url such as:
> -1%20union%20all%20select%201,2,concat(username,char(58),passw
> ord),4,5,6%20f
> rom%20users-- .
Without more information, it sounds like simple SQL insertion
Hello all,
My website has been hacked using a url such as:
-1%20union%20all%20select%201,2,concat(username,char(58),password),4,5,6%20f
rom%20users-- .
I have been searching on the web for a solution/fix to this issue and I
cannot seem to find one. The command above is showing
> See if that improves the numbers on the prepared statement.
>
> - michael dykman
>
>
> On Tue, Sep 2, 2008 at 5:41 PM, Jim Lyons <[EMAIL PROTECTED]> wrote:
> > I have a question about the prepare/execute commands provided by mysql.
> >
> > I devised
then, at the end insert
COMMIT
See if that improves the numbers on the prepared statement.
- michael dykman
On Tue, Sep 2, 2008 at 5:41 PM, Jim Lyons <[EMAIL PROTECTED]> wrote:
> I have a question about the prepare/execute commands provided by mysql.
>
> I devised a benchmark
I have a question about the prepare/execute commands provided by mysql.
I devised a benchmark, comparing updating a table using a
statement-at-a-time versus using a prepare/execute pair. The table had a
million rows.
The statement-at-a-time file looked like:
reset query cache;
update company
> > > I wonder if there are any tools to do a "diff" between two tables
> > > struture to result alter command to convert table A
> > > structure to table B structure ?
> >
> > Yes, our tool "Database Workbench" includes a so-called
> > "Schema Compare" tool which allows you to compare structures
2007/3/19, Martijn Tonies <[EMAIL PROTECTED]>:
Hi,
> I wonder if there are any tools to do a "diff" between two tables
> struture to result alter command to convert table A structure to table
> B structure ?
Yes, our tool "Database Workbench" includes a so-called
"Schema Compare" tool which all
Hi,
> I wonder if there are any tools to do a "diff" between two tables
> struture to result alter command to convert table A structure to table
> B structure ?
Yes, our tool "Database Workbench" includes a so-called
"Schema Compare" tool which allows you to compare structures
and create a change
Hello,
I wonder if there are any tools to do a "diff" between two tables
struture to result alter command to convert table A structure to table
B structure ?
Thanks for your information.
Stephane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
rom: Michael Williams [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 11:30 PM
To: mysql@lists.mysql.com
Subject: SHOW commands.
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will output
the commands to fully duplicate a table; data and all? I want to
retrieve
Michael Williams wrote:
Thanks for the responses everyone. Just a quick FYI, I am using
Python as an intermediary to sync the DBs (I'm fine with using
whatever as long as it's Debian compatible). I suppose I should have
explained before, but I'm using the Python script to connect from a
- Original Message - From: "Michael Williams"
<[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:30 PM
Subject: SHOW commands.
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will
output the commands to fully duplicate a table;
Michael
>Is there a command similar to "SHOW CREATE TABLE. . ." that will
>output the commands to fully duplicate a table; data and all? I want to
>retrieve the command and write it to a text file.
See the docs for mysqldump.
PB
-
Michael Williams wrote:
Hi all,
utput
the commands to fully duplicate a table; data and all? I want to
retrieve the command and write it to a text file.
Basically what I need is a "SHOW" on "CREATE TABLE copy SELECT * FROM
original", but SHOW doesn't seem to work here. I need a copy of this
comman
- Original Message -
From: "Michael Williams" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:30 PM
Subject: SHOW commands.
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will output
the commands to fully duplicate a ta
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will
output the commands to fully duplicate a table; data and all? I want
to retrieve the command and write it to a text file.
Basically what I need is a "SHOW" on "CREATE TABLE copy SELECT * F
a one-liner, though, the above will work.
>
> -Sheeri
>
> On 10/21/05, Dustin Krysak <[EMAIL PROTECTED]> wrote:
> > Hi there, I was wondering if it was possible to issue multiple
> > commands to mysql from a regular command line? For example i know you
> >
Dustin Krysak wrote:
> Hi there, I was wondering if it was possible to issue multiple commands
> to mysql from a regular command line? For example i know you can issue
> a single by the following:
>
> mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
e.g.,
On Fri, 2005-10-21 at 14:34 -0700, Dustin Krysak wrote:
> Hi there, I was wondering if it was possible to issue multiple
> commands to mysql from a regular command line? For example i know you
> can issue a single by the following:
>
> mysql -u${DB_USER} -p${DB_PASSWORD} -e
Hi there, I was wondering if it was possible to issue multiple
commands to mysql from a regular command line? For example i know you
can issue a single by the following:
mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
Now what if for example i needed to select a database
[EMAIL PROTECTED] wrote:
> The system commands you execute through the MySQL client are not performed
> at the server ...
Ah, OK, got it. Of course. I plead temporary under-caffeination :-)
Thanks for the clarification.
--
Hassan Schroeder - [EMAIL PRO
Hassan Schroeder <[EMAIL PROTECTED]> wrote on 09/28/2005 11:58:35 AM:
> Wolfram Kraus wrote:
>
> >> can we execute shell commands inside mysql client
>
> > Use \!
>
> Whoa. I didn't know that. Is that controlled in any way by GRANT?
> Or by conf/s
Wolfram Kraus wrote:
>> can we execute shell commands inside mysql client
> Use \!
Whoa. I didn't know that. Is that controlled in any way by GRANT?
Or by conf/startup options?
It seems like something you might (strongly!) want to disallow in
a shared environment :-)
--
Ha
> hi..
>
> I searched the documentation and googled for sometime, but didnt find
> anything related to this
> can we execute shell commands inside mysql client (like using ! in oracle),
> and if possible please tell me how.
>
> sujay
system(\!) Execute a system
Thanks a ton :)
sujay
-Original Message-
From: David Ziggy Lubowa [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 4:37 PM
To: mysql@lists.mysql.com
Cc: Sujay Koduri
Subject: Re: Can we run linux commands from inside the msql client
Yes you can ... e.g mysql>\!
gt; can we execute shell commands inside mysql client (like using ! in oracle),
> and if possible please tell me how.
>
> sujay
--
--
Fanaticism consists of redoubling your effort when you have forgotten your
aim.
-- George Santayana
--
MySQL General Mailing L
Sujay Koduri wrote:
hi..
I searched the documentation and googled for sometime, but didnt find
anything related to this
can we execute shell commands inside mysql client (like using ! in oracle),
and if possible please tell me how.
sujay
Use \!
E.g. \! ls
More information :\?
HTH
hi..
I searched the documentation and googled for sometime, but didnt find
anything related to this
can we execute shell commands inside mysql client (like using ! in oracle),
and if possible please tell me how.
sujay
Wolfram wrote :
>[EMAIL PROTECTED] wrote:
>> Hi,
>>
>>
>> using mysql 4.0.22-standard-log.
>> one instance on port 3307
>> one instance on port 3306
>> (each binary in its own independent directory)
>>
>> unix 'root' account s
[EMAIL PROTECTED] wrote:
Hi,
using mysql 4.0.22-standard-log.
one instance on port 3307
one instance on port 3306
(each binary in its own independent directory)
unix 'root' account submits following commands and connects to mysql on default
3306 port instead of awaited 3307 port
Hi,
using mysql 4.0.22-standard-log.
one instance on port 3307
one instance on port 3306
(each binary in its own independent directory)
unix 'root' account submits following commands and connects to mysql on default
3306 port instead of awaited 3307 port :
~mysqld/bin/mysql --po
thanks but I already have a bash version that logs to local filesystem
(then hacks the log into insert statements).
what I'm working on is something to log to another MySQL DB (outside
replication environment) to which I point (f)cgi (, etc.)
I think I've answered my own ?:
it seems DBI will par
does MySQL have a "pretty" way to persist snapshots of various show
commands?
for example in Oracle you could just do:
insert into sysstat_log select sysdate, * from v$sysstat;
--(an ugly, overly simple example)
can the show commands be called/parsed with DBD/DBI?
so far the onl
does MySQL have a "pretty" way to persist snapshots of various show commands?
for example in Oracle you could just do:
insert into sysstat_log select sysdate, * from v$sysstat;
--(an ugly, overly simple example)
can the show commands be called/parsed with DBD/DBI?
so far the onl
ese tests was dumped from a server running
> 4.0.13-standard. (Or not. Dunno.)
>
> - Mark
>
> Here is the transcript:
>
> ==begin quote==
>
> claspc2:marki:1026> mysql -uroot mysql
> Reading table information for completion of table and column names
> Yo
;
>>
> That is what I thought. Because of the sorting I should not have to
> worry about the order of issuing the grant commands. That's why I posted.
>
>>What output does the following statement produce:
>>
>> show grants for current_user();
>&g
ff this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 152 to server version: 4.1.11-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> revoke all on testdb.* fr
hould not have to
worry about the order of issuing the grant commands. That's why I posted.
What output does the following statement produce:
show grants for current_user();
Now there's an excellent idea! Here is what I get in the "bad"
configuration:
==begin quote==
&
s for current_user();
"Mark M. Ito" <[EMAIL PROTECTED]> wrote:
> Dear MySQL List,
>
> Is order important when issuing grant commands?
>
> Linux, Fedora Core 3
> MySQL server version: 4.1.11-standard, installed via RPM.
> perl DBI module
Dear MySQL List,
Is order important when issuing grant commands?
Linux, Fedora Core 3
MySQL server version: 4.1.11-standard, installed via RPM.
perl DBI module installed from CPAN on top of this version.
I am trying to allow all privileges to a given user to a given
database from inside my
Hi,
Which version of Mysql you are using? My query browser executes mutiple
commands -semicolon as seperated, and my ant script too works !! The
version Im using is 4.0.24.
Thanks
Usha
- Original Message -
From: "Justin Moore" <[EMAIL PROTECTED]>
To:
Sent: Wed
know ANT at all so I can't say how each ANT command/statement is
to be terminated. But, if you are executing SQL commands through an ANT
connection to the database, I think you will need to send (execute,
process, whatever the verb is in ANT...) your SQL statements one at a time
as your c
: Wednesday, March 23, 2005 10:39 AM
To: mysql@lists.mysql.com
Subject: semicolon commands causing problems
Hi,
Anyone know why I can't run multiple commands from the query browser using
semicolons to separate the commands?
ex:
The following command works fine:
select now();
Howeve
"Justin Moore" <[EMAIL PROTECTED]> wrote on 03/23/2005 10:38:48 AM:
> Hi,
>
> Anyone know why I can't run multiple commands from the query browser
> using semicolons to separate the commands?
>
> ex:
> The following command works fine:
> select now
Hi,
Anyone know why I can't run multiple commands from the query browser using
semicolons to separate the commands?
ex:
The following command works fine:
select now();
However the following commands do not
select now();
select version();
Your help is appreciated,
-JM
--
MySQL Ge
Brian Reichert wrote:
On Fri, Apr 23, 2004 at 10:47:53AM -0400, Chris Stevenson wrote:
Anyone out there have any experience with the book MySQL by Paul DuBois?
I'm having trouble figuring out how to save/reuse executed commands
(primarily creating tables at this point). Perhaps I could bou
Paul book is killer, I have the 1st and second addition - but to answer your
question the mySQL client can save commands, but if your looking for
something in mySQL itself to do that it can't. To create tables you can do
something like this.
%>mysql -h -uroot -p -f <
The ddl file
On Fri, Apr 23, 2004 at 10:47:53AM -0400, Chris Stevenson wrote:
> Anyone out there have any experience with the book MySQL by Paul DuBois?
> I'm having trouble figuring out how to save/resuse executed commands
> (primarily creating tables at this point). Perhaps I could bounce a f
Anyone out there have any experience with the book MySQL by Paul DuBois?
I'm having trouble figuring out how to save/resuse executed commands
(primarily creating tables at this point). Perhaps I could bounce a few
questions offline if you've got used this book before or think you can
On Thursday 25 March 2004 03:11 pm, Erich Beyrent wrote:
> Is there any way I can show all
> the sql commands for creating and populating a table
> from within mysql?
Here's the first half of your task:
SHOW CREATE TABLE MyTableName;
--John
On Thursday 25 March 2004 03:11 pm,
What do you have access to? SSH? ODBC? Port Access?
On Thu, 25 Mar 2004, Erich Beyrent wrote:
> Hi there,
>
> I am running a website on a host who has blocked access to mysqldump.
> Is there any way I can show all the sql commands for creating and
> populating a table from within m
Hi there,
I am running a website on a host who has blocked access to mysqldump.
Is there any way I can show all the sql commands for creating and
populating a table from within mysql? Again, I don't have access to
mysqldump.
Thanks!
-Erich-
--
MySQL General Mailing List
For list arc
See my original post below prior to reading the next 4 lines..
In addition to what I tried below, I tried the following (with this result):
$ ld -lmysqlclient -o myprog myprog.o
ld: warning: cannot find entry symbol _start; defaulting to 08048208
/usr/lib/libmysqlclient.so: undefined reference to
I am attempting to interface between a simple C program and MySQL, but without luck.
I searched the MySQLforum archives to see if there was info specific to this problem.
While there
were other folks who had problems connecting C/C++ to MySQL, none of the issue were
similar to this,
that is lin
At 02:03 3/18/2004, olinux wrote:
>--- "W. D." wrote:
>> I am a relative newbie to MySQL and PHPmyAdmin. I
>> tried adding
>> data into an existing table by 'uploading' a file in
>> PHPmyAdmin.
>> I know the INSERT INTO commands are valid, s
--- "W. D." wrote:
> I am a relative newbie to MySQL and PHPmyAdmin. I
> tried adding
> data into an existing table by 'uploading' a file in
> PHPmyAdmin.
> I know the INSERT INTO commands are valid, since I
> can import
> several hundred records usin
Hi Folks,
I am a relative newbie to MySQL and PHPmyAdmin. I tried adding
data into an existing table by 'uploading' a file in PHPmyAdmin.
I know the INSERT INTO commands are valid, since I can import
several hundred records using PHPmyAdmin. However, when I
try to import a few thousa
"Knepley, Jim" <[EMAIL PROTECTED]> wrote:
>
> The docs explicitly say that wildcards are allowed when specifying
> database names in GRANT commands, but don't say anything about wildcards
> being allowed in table names.
> For example, in one large database I ha
The docs explicitly say that wildcards are allowed when specifying
database names in GRANT commands, but don't say anything about wildcards
being allowed in table names.
For example, in one large database I have table names that are grouped
by function:
security.ids_e
At 4:26 PM +0200 9/16/03, VIVES Ariel wrote:
Hello the list,
sorry for my english, i'm french :-p
i've got a php script with a mysql database.
everything works fine.
but today, i've got this message :
Commands out of sync; You can't run this command now
i've done N
On 16 Sep 2003, VIVES Ariel wrote:
> i've got a php script with a mysql database.
> everything works fine.
> but today, i've got this message :
>
> Commands out of sync; You can't run this command now
>
> i've done NOTHING.
> nothing on my php script
Hello the list,
sorry for my english, i'm french :-p
i've got a php script with a mysql database.
everything works fine.
but today, i've got this message :
Commands out of sync; You can't run this command now
i've done NOTHING.
nothing on my php scripts.
nothing on
compiling my programs on MacOS X, they compile fine, but in many cases I am
getting a "Commands out of Sync" error when previously I had no errors.
They seem to fail consistently in the same place, but I'm having a really
tough time telling why they're failing.
The problem se
day, August 26, 2003 10:23 PM
Subject: Re: How to Track error - Commands Out of Sync
> Jocelyn,
> We use PHP for our application. We are running version 4.2.3. Thanks for
the
> help.
>
>
> On 8/26/03 2:16 PM, "Jocelyn Fournier" <[EMAIL PROTECTED]> wrot
Hi,
Do you use PHP ? If so, which version is installed ?
Regards,
Jocelyn
- Original Message -
From: "Free Grafton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:05 PM
Subject: How to Track error - Commands Out of Sync
> We ar
We are currently running about 50 databases on MySQL 4.0.14. Occasionally
our users will get the error:
Couldn't select database. Message: Commands out of sync; You can't run this
command now Message Number: 2014
When this happens to one customer, it affects them all. We end up
MySql,
Hope you can help.
I'm suddenly, after updgrading to MySQL 4.0.13-max-log Linux, getting
the error:
(2014) Commands out of sync; You can't run this command now
On the second command I send to MySQL. First, no problem.
I'm using MyC libruary, which has worked before.
Victoria Reznichenko wrote:
On Friday 04 April 2003 18:20, Jason Joines wrote:
Is there any way to combine MySQL commands? For example I want to
display the columns and indexes from a table. I can issue the two
commands on one line as
show fields from dbname.tblname; show index from
On Friday 04 April 2003 18:20, Jason Joines wrote:
> Is there any way to combine MySQL commands? For example I want to
> display the columns and indexes from a table. I can issue the two
> commands on one line as
>
> show fields from dbname.tblname; show index from
Is there any way to combine MySQL commands? For example I want to
display the columns and indexes from a table. I can issue the two
commands on one line as
show fields from dbname.tblname; show index from dbname.tblname;
Is there some way to say
show fields and index from
Hi, i'am new in this list.
In my subscrition I did give wrong mailbox ...
How can i change mailbox from my subscrition ?
Thanks
Fernando
mySQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
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
1 - 100 of 214 matches
Mail list logo
