Have you tried single quotes (ie. registry_program='EA')?
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Mon, 30 Jun 2003
New list member and mysql newbie with first time post.
I'm running into a problem getting MyODBC ver3.51 configured on my RH7.3
server running mysql 4.0.12. Anyone happen to be familiar with this
error when configuring MyODBC:
Could not find 'libmysqlclient' from '/usr/local/mysql/lib/mysql' or
Thought I might share this with others.
I recently upgraded MyODBC from 2.50-39 to 3.51.06
When I ran simple select statements from an ASP page in which the fields
were empty, I would get the following errors:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation
You can try one or the other
mysql -h localhost -u root -ppasswd db
or
mysql -h `uname -n` -u root -ppasswd db
in solaris
On Mon, 30 Jun 2003, Twibell, Cory L wrote:
> Did you flush the privileges after you gave root a password?
> The error you get is a result of not using a password to login.
2003年 7月 1日 火曜日 04:11、David Brodbeck さんは書きました:
> > -Original Message-
> > From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
> >
> > It's true that mysqldump doesn't put the data for the index itself
> > into the dump file. That does not automatically mean that the dump
> > files will be sma
Did you flush the privileges after you gave root a password?
The error you get is a result of not using a password to login.
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 6:05 PM
To: [EMAIL PROTECTED]
Subject: Access Denied for User: [EMAIL PRO
Please somebody help me.
I have installed MySql 4.0.13 and it works up until I try to apply security settings
to the root user at localhost.
I see the mysql database and I check the privileges and there is no password for the
roo user. But when I assign a password to make it secure, I can run p
check out http://www.phpbuilder.com
thay have a lot of things and that is one off them.
--
eschew obfuscation.
-Original Message-
From: Digital Directory USA [mailto:[EMAIL PROTECTED]
Sent: 29 June 2003 19:28
To: [EMAIL PROTECTED]
Subject: inserting images to mysql - is it possible?
I
That is my conclusion as well. I think you should post it as such
barring any comments otherwise.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 30, 2003 4:51 PM
> To: Mike Hillyer; [EMAIL PROTECTED]
> Su
Yes, I have the UPDATE for table B. I belive this is a bug.
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 4:47 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with privilege tables - IMPORTANT
Hmm, if you have UPDATE privilege on
Hmm, if you have UPDATE privilege on A and SELECT on A and B then it
should work. Do you have UPDATE granted on B (though I know you should
not need it)?
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 30,
Ok, the user has the appropriate privileges in the db table.
The user can select, insert, update, deletewhatever.
What he CAN'T do is a MULTI-TABLE UPDATE using just the db
privileges table.
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 4:2
Well, with that in mind, does the user have the appropriate INSERT
privileges?
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 30, 2003 3:49 PM
> To: Mike Hillyer; Twibell, Cory L; [EMAIL PROTECTED]
> Subj
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 30 Jun 2003, Peter Moscatt wrote:
> I am trying to install MySQL-server onto my Mandrake 9.1.
>
> When I first install 'mysql' using the latest RPMs all goes well and it
> places the mysql.sock into '/var/lib/mysql'
>
> But when I reboot and t
Todd Burke wrote:
so mysql can take full advantage of the dual cpu w/out a recompile?
Mysql create a separate thread for each connection. So a single
connection won't use more than one CPU. If you have lots of active
connections, then yes, it will take advantage of the dual cpu without a
rec
Hi,
You could either pass it as an attribute to the command line mysqld or
specify it in your my.cnf :
http://www.mysql.com/doc/en/Command-line_options.html
Or logical link the /usr/local/mysql/data to some other filesystem (ln -s)
Cheers,
Andrew
-Original Message-
From: Claudio Alonso
so mysql can take full advantage of the dual cpu w/out a recompile?
Thanks
--Todd
On Mon, 30 Jun 2003, Mike Wexler wrote:
>
>
> Todd Burke wrote:
>
> >Which is the better option to host mysqld:
> >
> >MACHINE A:
> >
> > 2.4 GHz CPU
> > 1024 MB Ram
> > 2x 18 GB SCSI
> > HDD RA
My user in the user table has NO privileges. All privileges for that user
are done in the db table. Using MySQL 4.1.0-alpha
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 3:41 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with priv
Well, you do not show what UPDATE privileges your user possesses, so I
am not sure where your problem lies. However, 2.23.57 has a fix that may
be relevant to your situation:
"Fixed security problem where mysqld didn't allow one to UPDATE rows in
a table even if one had a global UPDATE privilege a
- Original Message -
From: "Kevin Stone" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 30, 2003 1:34 PM
Subject: Comparison Operators?
> I'm having a lot of trouble with a simple query. Does anyone have any
idea
> why this might not be working?
>
> The query:
> SELECT
All,
I have the user table which contains user record
| Host | User| Pass | Select...|
---
|% || | N... |
The db record is
| Host | Db| User | Select...|
--
| %| Test1 || 'Y'
On 30 Jun 2003 at 22:43, [EMAIL PROTECTED] wrote:
> oops, i forgot this one...
> isn't that parameter binding only available from mysql 4.1 on?
> at least, when i browse through the php doc, it's part of the
> "improved mysql extension (mysqli)", available for mysql 4.1. does
> anyone know about v
anders thoresson schrieb:
I'm building a planning system for a newspaper. Article ideas are
defined as articles with no deadline, no publication date or no reporter
assigned. I wan't to show all entries from table un_article that matches
those three criterias.
I have three tables:
CREATE TABLE
oops, i forgot this one...
isn't that parameter binding only available from mysql 4.1 on?
at least, when i browse through the php doc, it's part of the "improved mysql
extension (mysqli)", available for mysql 4.1.
does anyone know about version 4.0?
-yves
-Ursprüngliche Nachricht-
Von
The standard solution is to use binding.
JDBC and Perl DBI both support it, and I imagine most other environments
do as well.
In such case, your query will turn from:
"INSERT INTO someTable values ('foo\'')"
Into:
"INSERT INTO someTable values (?)"
You're use a prepared statement, and before
Hi,
I did post a request for help earlier today, on how to select rows from
two tables based on missing information in a third. I have now come some
way on my own. I have two different queries that together does what I want.
But I don't know how to combine them to one. Would appreciate any help
Just shutdown mysql, move the data and create a symlink.. or start
safe_mysqld with --datadir= option
On Mon, 30 Jun 2003, Claudio Alonso wrote:
> Hi, I'd like to know if there's a way to change where the datadir is
> located.
> I've installed mysql in a Sun Solaris, in the /usr/local/mysql
>
I'm having a lot of trouble with a simple query. Does anyone have any idea
why this might not be working?
The query:
SELECT * FROM `asio_linkpop_queries` WHERE `domain` =
'www.legendsandlore.com' AND `date` > 1056957929
The row in the database:
domain | date
www.legendsandlore.com | 1057000554
Hi, I'd like to know if there's a way to change where the datadir is
located.
I've installed mysql in a Sun Solaris, in the /usr/local/mysql
directory, but I want the databases to be located in another filesystem.
Is there a way to relocate them?
Thanks in advance,
--Claudio
___
i don't believe there is another solution,
but anyway, how many characters per second can your users type that this string
replacement could be a measurable slowdown of the process?
-yves
-Ursprüngliche Nachricht-
Von: "harsh" <[EMAIL PROTECTED]>
An: "My Sql List" <[EMAIL PROTECTED]>
Greetings,
Lenz Grimmer <[EMAIL PROTECTED]> writes:
> On Tue, 24 Jun 2003, David Griffiths wrote:
>
> > A 64-bit CPU won't have the 4-gig memory limit that a 32-bit processor
> > will; even worse, Linux is apparently limited to about a 2-gig process.
>
> It depends - there is a BIGMEM patch fr
> -Original Message-
> From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
> It's true that mysqldump doesn't put the data for the index itself
> into the dump file. That does not automatically mean that the dump
> files will be smaller than the .MYD, .MYI, and .frm files combined.
> The
I have to take a text input from users and store
it in table,to avoid ' error i can replace ' with \',
is there any other solution as that might slow down the process ?
harsh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
Greetings!!
I'm trying this insert and it will not run in batch mode. I think the '' syntax is
right but what else am I missing??
insert into registry set registry_program="EA", registry_key="BASE_PATH",
registry_value="f:auction";
Robin E. Kopetzky
Black Mesa Computers/Internet Se
I have tried installing MySql on Apache 2.0.46 and PHP latest version. I actually
thought that my installation was okay, I was even able to use PHPMYADMIN to create
another user. I basically created a user with my name and gave it all the same rights
as the root user.
Somehow, each time I creat
Todd Burke wrote:
Which is the better option to host mysqld:
MACHINE A:
2.4 GHz CPU
1024 MB Ram
2x 18 GB SCSI
HDD RAID 1
MACHINE B:
Dual Xeon
1.8 GHz CPU
1024 MB Ram
3x 18 GB SCSI
HDD RAID 5
I would recommend using RAID 1
Which is the better option to host mysqld:
MACHINE A:
2.4 GHz CPU
1024 MB Ram
2x 18 GB SCSI
HDD RAID 1
MACHINE B:
Dual Xeon
1.8 GHz CPU
1024 MB Ram
3x 18 GB SCSI
HDD RAID 5
In other words will mysql benefit from the dual c
I would like to be able to set a user variable on startup of MySQL. I
have review the documentation and searched the archives and I haven't
seen anything about being able to do, or not do this.
Can this be done? Since I'm unable to find reference to it, my guess is
no, but I thought I'd give the
On 28 Jun 2003 at 10:12, Nils Valentin wrote:
> I understood that the backup done by f.e mysqldump would dump the
> create statement only for the index - not the actually data fo the
> index. That would make the backup option create smaller files than
> lets say if you copy it 1x1 on the OS comman
I'm running into a problem updating a blob column. The table is:
CREATE TABLE product(
product_id int(11) NOT NULL auto_increment,
name varchar(60) NOT NULL,
cat_id int(11) DEFAULT 0 NOT NULL,
releasedate date,
price decimal(10,2),
description text,
imagedata blob,
PRIMARY KEY (pro
[snip]
>That will only result in deletion,I want it to be displayed
>and simultaneously deleted.more precisely the effect of following
>two commands in one
>
>SELECT from data where name='harsh';
>DELETE from data where name='harsh';
[/snip]
Write a .sql script with both queries and call it from t
Hi,
I'm building a planning system for a newspaper. Article ideas are defined
as articles with no deadline, no publication date or no reporter assigned.
I wan't to show all entries from table un_article that matches those three
criterias.
I have three tables:
CREATE TABLE un_article
(
a_id IN
artem wrote:
please clarify use of set autocommit
Here's an unsolicited opinion: AVOID using autocommit within
applications. Based on my experiences with other DBMSs, it's a very
likely source of hard-to-find program bugs. The problem occurs when
it's turned on and off in a program -- it's
Joseph Bueno <[EMAIL PROTECTED]> написа :
> [EMAIL PROTECTED]
> wrote:
> > Hello,
> > i build one query in my mysql:
> > mysql> select timestamp from lastauth where month(from_unixtime(timestamp) =
> 6);
> > Empty set (0.00 sec)
> > Query is empty, but:
> > my timestamp table:
> > ++
[EMAIL PROTECTED] wrote:
Hello,
i build one query in my mysql:
mysql> select timestamp from lastauth where month(from_unixtime(timestamp) = 6);
Empty set (0.00 sec)
Query is empty, but:
my timestamp table:
++
| timestamp |
++
| 1056981323 |
++
1 row in set (0.0
Hello,
i build one query in my mysql:
mysql> select timestamp from lastauth where month(from_unixtime(timestamp) = 6);
Empty set (0.00 sec)
Query is empty, but:
my timestamp table:
++
| timestamp |
++
| 1056981323 |
++
1 row in set (0.00 sec)
mysql> select from
Ivan,
if you have already dumped all InnoDB tables, then there is no need to keep
ibdata files and ib_logfiles. You can delete them and recreate them from
scratch and reimport the tables.
But in the printout which you pasted below you do not have
innodb_force_recovery set to 4?
When I test 4.0.1
Hi Gerald-
I understand the pros and cons of db vs filesystem, and for images (static,
rarely changing) it makes sense. I was pursuing any info about large chunk
transfers or fragmented storage issues for large field tables.
I'm working with a table containing historical information for 67,000
At 9:21 +0300 6/30/03, artem wrote:
please clarify use of set autocommit
SET AUTOCOMMIT = 0 ==> mean start transaction
... - some actions
COMMIT ==> transaction end
now to return to autocommit mode
just one line:
SET AUTOCOMMIT = 1
or two?
SET AUTOCOMMIT = 1
COMMIT
than
Bob:
This question comes up over and over on the list ... do a search for
'images' of the list archive and you can read the accumulated pros and cons.
Gerald Jensen
- Original Message -
From: "Bob Ostermann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 30, 2003 7:35 AM
Nevermind. I installed Postgresql. It compiles perfectly on NetBSD.
Thanks for the pointers though and sorry for sending my emails to the
wrong mailing list. I don't like to use pkgsrc because it usually
installs all of these other packages; I only have 3 GB on my harddrive, so I
have to worry a
Armand-
Why is it not recommended to store images in a database? I've not heard this...
bob.
At 09:51 PM 6/29/03 +0200, you wrote:
Hi,
You have to insert a new blob field where you can store binary data. But
it is not recommanded to store images in a database. I recommande you to
store image
MaFai wrote:
Hello, mysql,
p_asset CREATE TABLE `p_asset` (\
`ano` int(11) NOT NULL auto_increment,\
`asset_name` varchar(50) NOT NULL default '',\
`asset_type` int(11) default NULL,\
`asset_format` varchar(50) default NULL,\
`asset_keywords` varchar(200) default NULL,\
`asset_duration
I am mildly surprised that nobody has answered this yet - bit you did post
on the weekend - so I will put in my $0.02.
On http://www.mysql.com/doc/en/Multiple_servers.html your NFS idea is
described as "a bad idea". I concur. I believe that MySQL makes a lot of
use of cacheing - locking updates w
Hello, mysql,
p_asset CREATE TABLE `p_asset` (\
`ano` int(11) NOT NULL auto_increment,\
`asset_name` varchar(50) NOT NULL default '',\
`asset_type` int(11) default NULL,\
`asset_format` varchar(50) default NULL,\
`asset_keywords` varchar(200) default NULL,\
`asset_duration` bigint(20)
Hi.
Please help.
During long delete operation from one InnoDB table there was PC shutdown due to power
supply failure. After that I was unable to start database server so I have started it
with set-variable = innodb_force_recovery=4 option and I have dropped all databases
with InnoDB tables. S
Agree with you Armand, but i'm not in charge of the database so i can't do anything
about it. I've just been asked to create a query which shall be used in a report.
Regards
Paal
Armand Turpel <[EMAIL PROTECTED]> wrote: Hello,
Sone or later your get tired with this table construct. I recommand
Hello,
Sone or later your get tired with this table construct. I recommande you
to split this table into 4 tables:
Tables:
- country
ex.: id_country country_name
- company
ex.: id_company company_name
- activity
ex.: id_activity activity_name
- relation-country-compan
I am trying to install MySQL-server onto my Mandrake
9.1.
When I first install 'mysql' using the latest RPMs all
goes well and it places the mysql.sock into
'/var/lib/mysql'
But when I reboot and then come back to run mysql I
get an error indicating that it can't connect though
mysql.sock.
When
I'm using under WINDOWS NT4 sp6 the 4.0.13 version as a slave from a 3.52
master. During the night to I use a bacth file (starting on 22.30 )to stop
the mysql and copy all then file of mysql. But till the 3.52 version (on my
slave) using
the same scripts no problem. Now when the computer execute t
sorry insane is ozzy slang for awesome, the best whatever u want to call it
.
well , ok from what i know and have asked about , they are precompiled
functions , actually embedded into the server which do routines , so
therefore all u have to do is call the procedure from the API, therefore ok
now
sorry, should have said - I get the record created, but with a null
value in the blob - as you would for a file larger than the
max_allowed. but I've checked numerous times (and have gone up to
longblob) and still can't load above around 1mb.
I should also mention that it's running on the same m
Hi i have a challenge for you. I'm struggling with this self join query. I have a
table which among several contains theese fields: id, strname, iparentid
id is primary key and iparentid show who the child of id. There are 4 level deepth in
this table, i.e. like this
iIDstrName---
Hi Artem,
I understood the AUTOCOMMIT command different.
SET AUTOCOMMIT = 0 ==> deactivate AUTOCOMMIT
SET AUTOCOMMIT = 1 ==> activate AUTOCOMMIT
The commands
BEGIN
. some instructions
COMMIT
are used to start or finish a transaction.
Anybody, please correct me if I talk rubbish ;-
I have just installed 'MySQL-server' and
'MySQL-client' onto a Mandrake 9.1 system.
The two RPMs installed without error and running mysql
from the shell was fine and did what was expected of
it.
I have now rebooted the system and when I go to the
shell to issue the 'mysql' command I get the foll
65 matches
Mail list logo