HI,
I need to do a select query that can do the following:
select * from table where col1 like hex(somestring);
My problem is HOW do I get the % in there???
The Mysql Server is 4.0.4 and the table has a blob field with hex stored in
it
Thanks
Tonino
Hello,
I upgrade my server from Mandrake 8.2 to Mandrake 9.0 and i have a little problem with
MySql 3.23 (Ver 3.23.52 for pc-linux-gnu on i686):
When i try to start MySQL with this command with root user :
# safe_mysqld --user=mysql
I obtains the following response:
# Starting
Hello,
I upgrade my server from Mandrake 8.2 to Mandrake 9.0 and i have a little
problem with MySql 3.23 (Ver 3.23.52 for pc-linux-gnu on i686):
When i try to start MySQL with this command with root user :
# safe_mysqld --user=mysql
I obtains the following response:
# Starting mysqld
On Fri, 6 Dec 2002 09:36:17 +0100
David Bordas [EMAIL PROTECTED] wrote:
Hello,
I upgrade my server from Mandrake 8.2 to Mandrake 9.0 and i have a little
problem with MySql 3.23 (Ver 3.23.52 for pc-linux-gnu on i686):
When i try to start MySQL with this command with root user :
#
sql, query
Right now, every day I run the equivalent of a mysqlhotcopy on my
database (read-lock the tables, copy the files, unlock the tables).
This freezes up everything (websites, etc.) that uses the database for
10 minutes. That is too long.
Is there a way to get a snapshot of the database
Description:
mysqlcheck is not able to work on one table called `table`,
mysqldump does have an option to quote table and column name, but mysqlcheck
doesn't
How-To-Repeat:
create a table `table`, then run mysqlcheck on the database
Fix:
Just copy the behavior of
Have a look to the mysql error log to see if you can find your problem
...
This file should be in /usr/local/mysql/data
I have no log file, the only file created is serveur name.err with the
number of the thread who crash.
touch13
This file IS the mysql error log.
On one of mine i can see
On Friday 06 December 2002 01:11, Qunfeng Dong wrote:
Hi,
I wish to tune our MySQL Server Parameter to increase
the speed of Join. I was trying to do a simple join
with two tables. One is big (~2,500,000 records); the
other one is small. The current join seems to take
forever to finish even
On Thu, 5 Dec 2002, Heikki Tuuri wrote:
the table definition below does not match the index records below. In the
index records one of the datetime columns seems to appear twice.
Heikki, you are right. The old definition of that MySQl table had two
columns twice. When I REgenerated the table,
Hi,
You can also use mysql replication: you install a slave server and
run mysqlhotcopy on it. This way, you never freeze the master server.
Hope this helps
Joseph Bueno
Philip Mak wrote:
sql, query
Right now, every day I run the equivalent of a mysqlhotcopy on my
database (read-lock the
The problem with this idea is that mysql replication doesn't always work so
you'd end up with data missing from the backup. If you don't explicitly
select or 'use' a database, the sql query is never written to the binary log
and thus the slaves don't pick it up.
- Original Message -
Dobrý den,
sexta-feira, 6 de dezembro de 2002, 07:15:43, napsal jste:
PM sql, query
PM Right now, every day I run the equivalent of a mysqlhotcopy on my
PM database (read-lock the tables, copy the files, unlock the tables).
PM This freezes up everything (websites, etc.) that uses the database
On Fri, 6 Dec 2002 10:18:12 +0100
David Bordas [EMAIL PROTECTED] wrote:
Have a look to the mysql error log to see if you can find your problem
...
This file should be in /usr/local/mysql/data
I have no log file, the only file created is serveur name.err with the
number of the thread
Hi
I tried to do the
GRANT FILE ON *.* TO repl@% IDENTIFIED BY 'password';
as a part of getting repliaction working. When I later tried to replicate
all I got was 'access denied'.
I have had similar problems earlier when I have tried to to use the '%' in
the host field of the user table in
Hello.
In an attempt to use innoDB tables I added this to my 'my.cnf':
innodb_data_home_dir =
innodb_data_file_path = /var/mysql/admin/ibdata1:100M:autoextend
mysqld claimed this was an syntax error if I removed 'autoextend' it works
but I really want the autoextend capability.
Any and all
Description:
Tables marks crashed after few minutes after repair.
I repair it with `myisamchk -sfo /var/db/mysql/*/*.MYI` and after a while
(2-15 minutes) some
tables (which is with high loading, I suppose) corrupts:
# myisamchk -se /var/db/mysql/*/*.MYI
[...skiped...]
Hi Michael,
Using two select's we already solved the problem. The challenge is to make
the same thing using just one select. I need to know if is there an way to
get the last date or the 10th index to make the WHERE part. Like the
LAST_INDEX() function, that gets the last AUTO_INCREMENT...but I
Hello,
I tried to execute the following form:
html
head
title/title
/head
body
FORM method=POST action=jokehandle.php
INPUT TYPE=submit name=addjoke value=InsertBR/
INPUT TYPE=submit name=deletejoke value=Delete
/FORM
/body
/html
and the following script PHP:
HTML
HEADTITLEOperazioni su
* Will Standley
1 - When I create a new db using MySQL...
Can I tell MySQL where (what path directory) to store the new db files?
No, not at runtime. This can only be changed while the server is not
running. Edit the 'datadir' or 'basedir' parameter in the my.cnf file, or
use a startup option
* tag
I need to do a select query that can do the following:
select * from table where col1 like hex(somestring);
This was a bit confusing... :)
hex(somestring) will always return 0, unless the string is a numerical
value:
mysql select hex('65'),hex(65),hex(A);
Roger,
Are the files that you mentioned stored in the directory for the db ?
thanks for the help,
Will
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 6:31 AM
To: [EMAIL PROTECTED]
Cc: Will Standley
Subject: Re: What are basic db files
* Tonino Greco
Thanks - but I got it working :
select * from table where col1 like concat(%, hex(somestring), %);
the hex(somestring) - returns :736F6D65737472696E67
* me
hex(somestring) will always return 0, unless the string is
a numerical value
Sorry for that, this was changed in 4.0.1,
mysql 3.23.49a
From: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED]
Reply-To: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED]
To: Carlos A. [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: mysqldump error
Date: Thu, 5 Dec 2002 22:02:49 +0100
Dear Carlos,
ERROR 2013 at line 1:
mysql select sum(trial_signups) from campaign_t where
datestamp='20021204'\g
++
| sum(trial_signups) |
++
|100 |
++
mysql SELECT site_id, sum(raws) As RawHits, sum(uniques) As
UniqueHits,
sum(trial_signups)
Hello,
I tried the modify two fields in a table and MyCC and MySqlFront return the
following error:
Error: 7 - Error on rename of '.\aziendeseat\aziendege.MYI' to
'.\aziendeseat\#sql2-610-1a.MYI' (Errcode: 13)
The Table is named aziendege and contains the fields:
ID NOT NULL AUTO_INCREMENT,
Nome
Kittiphum,
Friday, December 06, 2002, 12:19:47 PM, you wrote:
KW REALFROM: Kittiphum Worachat [EMAIL PROTECTED]
KW On Wed, 4 Dec 2002 17:38:00 +0200, Victoria Reznichenko wrote:
Kittiphum,
Wednesday, December 04, 2002, 1:49:08 PM, you wrote:
K This query can find the record in Table1 that not
Run your database from a RAID 0. At some point during the night. Down one of
the drives, mount it and copy the data. Then unmount it bring it back
on-line. The RAID card should re-sync them without any down time.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original
Will,
Friday, December 06, 2002, 7:01:46 AM, you wrote:
WS 2 - To back up the db... can I just copy the files in that directory to a
WS backup device like a CD or floppy?
You can .. but it's not recommended way. For more info about database
backups refer to the manual:
Rich,
Friday, December 06, 2002, 2:23:49 AM, you wrote:
RA if i have the following mySQL tables
RA create table list (
RA id int,
RA name char(20)
RA );
RA insert into list values(1, 'bob');
RA insert into list values(2, 'joe');
RA create table list2 (
RA id1 int,
RA id2 int
RA );
RA insert
Hello Joseph,
Thursday, December 05, 2002, 8:39:18 PM, you wrote:
NJ Victoria,
NJ I am trying to get the hang of this also. In your statement below you
NJ show, what appears to me, two tables, mytest ( I see this one ) and t1.
NJ Where did table t1 come from? Could you explain your sql a
Will,
Friday, December 06, 2002, 7:01:47 AM, you wrote:
WS When I create a new db using MySQL...
WS What files does MySQL create?
MySQL create the directory with database name in the MySQL data dir.
WS I'm asking because a MySQL sample db was created on the machine I am using
WS and they don't
Mike,
Thursday, December 05, 2002, 7:11:39 PM, you wrote:
MD I'm wondering if it's possible to specify multiple hosts for a user when
MD setting up permissions, but without using wildcards.
MD For example.. if I have these two GRANT statements:
MD GRANT SELECT on database.* to [EMAIL
MySQL folks,
I have a server which handles hundreds of connections at a time typically.
Many of these are actually inserting data. It is currently configured as a
replication master. Let's call it A. The slave is currently only used as a
backup. Let's call the slave B. But this is not really
* Rich Allen
if i have the following mySQL tables
create table list (
id int,
name char(20)
);
insert into list values(1, 'bob');
insert into list values(2, 'joe');
create table list2 (
id1 int,
id2 int
);
insert into list2 values(1,2);
insert into list2 values(2,1);
what
Thanks! I copied
/usr/share/doc/mysql-server-3.23.49/my-huge.cnf into
/etc/my.cnf and restarted mysqld from
/etc/rc.d/init.d/mysqld
but it's not improving anything.
my join query is very simple
select count(B.columnb) from B left join A on
B.columnb = A.columna.
Both columna and columnb are
Really, the issue is that you don't want a primary key that is volatile.
It doesn't matter if it has business meaning.
Or user meaning, ie users find them useful signs. Fair enough, but if you
take that as a rationale for choosing PK values that begin by having meaning
to users, you leave your
Actually, I do google searches first before asking on any list - and it
didn't turn up a darn thing.
-Mike
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 6:19 PM
To: Mike At Spy
Cc: [EMAIL PROTECTED]
Subject: Re: mysql port
Robert,
thank you for your answer. I will be using the server
strictly for MySQL database. That will be a backend
for several Web Applications written mostly in PHP.
What hardware is advised in such a configuration ?
--- Robert Adkins [EMAIL PROTECTED] wrote:
I am running a few AMD based
That, of course, isn't even getting into the point that you didn't answer my
question. I asked how I could tell, not what the default port was!
Thank you to the others that did. :)
-Mike
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December
sql,query
First off, we are using Innodb tables on version 3.23.53a-max.
If the command STOP SLAVE is issued in the middle of the following type of
transaction:
set autocommit = 0;
update...;
update...;
update...;
commit;
does it roll back the current transaction or wait for it to complete?
From what I've been reading in the MySQL documentation, 3.23.43b InnoDB features
foreign key constraints, which is great!
But from the MySQL 4.1 wishlist items found here (scroll to the bottom):
http://www.mysql.com/products/mysql-4.0/index.html
They mention hopes to support foreign key
In the last episode (Dec 06), kayamboo said:
When I tried to drop the key, this was the error
mysql alter table town_db drop primary key ;
ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db' (errno:
150)
And what does perror 150 return (it's a shell command, not an SQL
Hi,
I just send this email again. Does anyone care about
HPUX build?
Zengfa
--- Zengfa Gao [EMAIL PROTECTED] wrote:
Hi,
I tried to compile mysql-3.23.49 on HPUX 11.11
system.
When I run:
CC=cc CXX=aCC CFLAGS=+DD64 CXXFLAGS=+DD64
./configure
Everything is fine, no errors.
But
Hi all,
I seem to have a problem with query caching with MySQL 4.0.5a.
Check the two results below to see what I mean (the 2 queries were run one
after another with no other changes.)
I have tried it with and without and various combos of the following my.cnf
settings - same result!
Lo all,
If I have a database with various tables, and I want to upgrade the tables
and the data in the tables, will it screw up the permissions assigned to
users if I use DROP TABLE / CREATE TABLE (to recreate the changed tables),
and then just populate them with the data again?
I'm doing it
Hi I just downloaded version 3.23.53 for evaluation.
when I try to use LOAD DATA LOCAL INFILE 'some.txt
into TABLE sometable I get a message saying 'the used
command is not allowed in this version of mySQL. IS
there any update on this? I could not find any info on
your web site.
Thanks
KP
X-Sender: [EMAIL PROTECTED]
X-Mailer: QUALCOMM Windows Eudora Version 5.0
Date: Fri, 06 Dec 2002 09:20:55 -0700
To: [EMAIL PROTECTED]
From: Mariella Di Giacomo [EMAIL PROTECTED]
Subject: --enable-assembler error and MySQL 64 bits compilation error
on Solaris 2.8
Hello,
I have been running
Dear Will,
When I create a new db using MySQL...
What files does MySQL create?
CREATE DATABASE mynewone will create a directory called mynewone in the
MySQL datadir. You can check where this is by issuing SHOW VARIABLES LIKE
'datadir' on the SQL command line.
HTH!
--
Stefan Hinz [EMAIL
Helmut,
I suppose that depends really upon the composition of your database.
Unfortunately, I am far from an expert when it comes to MySQL or
virtually any other database, I just happen to know a little bit about
hardware and some performance related information. All of that is
after trying this it shows mysql as running, but /tmp/mysql.sock as not being created.
i stopped mysql and then started it again, and the same thing happened...still no
mysql.sock? should i just reinstall? what is the best way to go about fixing this
problem? thank you.
jeff
ps -wef |
ʱ´´ÍøÂçÍƳöÆóÒµ½¨Õ¾×¨Óÿռ䣬´úÀíÀûÈó¿É´ï50%!
ÎÒ˾ÍƳöÆóÒµ½¨Õ¾×¨Óÿռ䣬ȫÃæÖ§³ÖJSP¡¢ASP¡¢ASP.NET¡¢PHP£¬ÏÖÕýÃæÏòÈ«¹ú¸÷µØ³ÏÑ
û´úÀí£¬ÀûÈó¿É´ï40%£¡
*
ÉêÇëʱ´´ÍøÂçµÄ´úÀí£¬³ýÁË¿ÉÒÔÏíÊÜÈ«·½Î»µÄ»¥ÁªÍø²úÆ··þÎñ£¬»¹¿ÉÒÔÃâ·Ñ»ñµÃÓòÃû¡¢¿
ռ䡢ÖÇÄܽ¨Õ¾¡¢¶¯Ì¬IPµÈµÄÔÚÏß×¢²á´úÂ룬·½±ãÄú¼°Ê±¿ªÕ¹ÒµÎñ¡£
*
I am new to this list and have not been able to find an answer in the
searchable archive, So I am sorry if this question has been asked
before.
The documentation (section 4.10.7) mentions 2 way replication but does
not give any information about how to set it up. I have searched the
I got a MySQL depot file, but I have some suggestions:
1. On HPUX system, we should not put executable under
/usr/local/mysql, we should be it under /opt/mysql
2. The Data directory for MySQL should be
/var/opt/mysql, not /var/lib/mysql.
Just a thought!
Zengfa
I have a large blob column with encrypted data and also i have other
non-blob columns. I get results when i do the following
Note: ID = non blob column
Select ID from table
i get records returned
when i select from a blob column for example:
select blobcolumn from table
it hangs no results.
Heikki and all,
I've got a quick question which may be more general sql related but
since I'm using innodb tables specifically for the row locking.
The following process description is specifically designed to prevent
duplicates.
My current process:
select * from run where job_id = 111 and
* Will Standley
Question:
When I create a new db using MySQL...
What files does MySQL create?
None. It creates a new directory only.
When you create a table, and the used table handler is MyIsam, three new
files are created: *.frm, *.MYI (index) and *.MYD (data). If the table
handler is
kayamboo,
Friday, December 06, 2002, 9:15:04 AM, you wrote:
k When I tried to drop the key, this was the error
k mysql alter table town_db drop primary key ;
k ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db'
k (errno: 150)
k I suppose some lock in the index somewhere
I have a couple of test MySQL data bases on my Linux/Apache box and want
to delete them for a clean start...
How do I delete all the files associated with the two db's ?
Thanks,
Will
-
Before posting, please check:
Hi,
When trying to use 'LOAD DATA LOCAL INFILE' with Apache2.0.43 (running a
module) and MySQL 3.23.53, it returns the error the command is not
supported. This is because the function is disable for security issue, but
when I tried to start mysql with 'c:\mysql\bin\mysqld-nt --local-infile=1'
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Qunfeng Dong wrote:
Thanks! I copied
/usr/share/doc/mysql-server-3.23.49/my-huge.cnf into
/etc/my.cnf and restarted mysqld from
/etc/rc.d/init.d/mysqld
but it's not improving anything.
my join query is very simple
select count(B.columnb) from B
Hello friends, newbie here.
1. I need to know if these features are supported or not by MySql ver 4.05a.
- Referencial integrity constraint
- Stored Procedure
- View
- Trigger
2. How to use SSL ?
3. How to add a user that can login from any host ?
4. What are the differences between standard and
show variables
that will show you what you need.
you can use a like statement, because there is a lot of stuff
hope that helps
brian
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 9:51 AM
To: [EMAIL PROTECTED]
Subject: RE: mysql port
Hello, yes I've thought of using less fields, separated by commas, but I'd
like to use much more SQL queries than PHP to process the result.
I have one question : if I go the RestTimes route, that is having a row per
day and so 7 row per restaurants : can I, in one SQL request, know if THAT
MySQL does not provide conflict resolution mechanism yet. So, although
two-way replication
is theoretically possible, it may cause serious problems, e.g. data
inconsistency between
two servers.
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz
Open the mysql monitor, and ...
DROP DATABASE databasename;
- Original Message -
From: Will Standley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 06, 2002 5:56 PM
Subject: How to delete MySQL db ?
I have a couple of test MySQL data bases on my Linux/Apache box and
On Fri, Dec 06, 2002 at 07:51:54PM +1000, Jason Brooke wrote:
The problem with this idea is that mysql replication doesn't always
work so you'd end up with data missing from the backup.
What? I've never had that happen. If it does, it's a bug. File a
bug report if it's not documented as
On Fri, Dec 06, 2002 at 08:36:32AM -0600, Cal Evans wrote:
Run your database from a RAID 0. At some point during the night. Down one of
the drives, mount it and copy the data. Then unmount it bring it back
on-line. The RAID card should re-sync them without any down time.
I think you mean
Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǵĿռä
Hi folks.
I have an application in which I require the only case equivalencies
to be a-z A-Z. What I mean is, e/E should be regarded as identical
in strings, but neither e/É (E-acute) nor é (e-acute)/É (E-acute)
should be regarded as identical.
When the application was first written I was
i believe that this security issue came up with the .51 version of mysql
you can remove this block by adding this to your my.cnf file
[mysqld]
local-infile=1
[mysql]
local-infile=1
- hcir
On Friday, December 6, 2002, at 10:16 AM, Padma kuruganti wrote:
Hi I just downloaded version 3.23.53
I have a test case that says otherwise.
I just connected to my master, inserted a record into a table (never
having done a USE), and then checked a slave. It was there as
expected.
I have an array of test cases that says otherwise.
I just connected to one of my masters, inserted a record
Hi,
I am running mysql 3.23.53 on FreeBSD 4.4. I compiled mysql from source with
the following configure command:
--prefix=/usr/local --localstatedir=/var/db/mysql
Every now and then, the server seems to change its database directory to
/var/tmp. When it happens, show
On Sat, Dec 07, 2002 at 01:45:04AM -0500, Cedric Veilleux wrote:
Hi,
I am running mysql 3.23.53 on FreeBSD 4.4. I compiled mysql from source with
the following configure command:
--prefix=/usr/local --localstatedir=/var/db/mysql
Every now and then, the server seems to
73 matches
Mail list logo