On Sat, Aug 11, 2001 at 10:54:58PM -0700, Joe Sheble (Wizaerd) wrote:
I have a text field that contains some plain text intermingled with
html tags. In querying the database, if the keyword I'm searching
for falls within the plain text, that record should be returned.
However, if the
hi,
FYI our company start evaluted mysql version 3.23.38. We can
succesfully make installation but unfortunely we can't start services for
mysql. Not have any message pop up. After i start winmysqladmin.exe in
installation path, we just right click
image in our right conner in windows bar
an example would be:
this is some text that would fall within the text field (somefield):
if you want to see some nice images, check out a
href=http://www.photoshopuser.comthis website/a
and the query would be:
WHERE somefield like '%photoshop%'
the above record should not be returned.
On Sun, Aug 12, 2001 at 11:43:31PM -0700, Joe Sheble (Wizaerd) wrote:
an example would be:
this is some text that would fall within the text field (somefield):
if you want to see some nice images, check out a
href=http://www.photoshopuser.comthis website/a
and the query would be:
Dear Members!
How can I convert a Corel-Paradox table (.db) to MySQL database ?
Thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Then yes, it should be returned.
-Original Message-
On Sun, Aug 12, 2001 at 11:43:31PM -0700, Joe Sheble (Wizaerd) wrote:
an example would be:
this is some text that would fall within the text field (somefield):
if you want to see some nice images, check out a
Hiya !
I run a website with a PHP and MySQL driven front backend. The sites
hits increase day by day, and today I got the messege: too many mysql connections ..
well I thought, just check the my.conf ..
But there is no :(
I have MySQL v.8.21 Distrib 3.23.40 installed, with the RPMs given @
- Original Message -
From: Horvath Gyula
To: [EMAIL PROTECTED]
Sent: Saturday, August 11, 2001 4:52 PM
Subject: Converting
Dear Members!
How can I convert a Corel-Paradox table (.db) to MySQL database ?
Thanks!
Hi
I am reposting this just in case someone who would be able to assist me did
not see it first time around.
Thanks
Deon.
I am currently putting together a backup system for our MySQL server. The
way I want to do this is to make use of mysqldump to perform the backup and
have the binary log
Hello list
I want to save a database in order to replace it in case of
manipulating error.
Is there a way to save database (like export and import)?
Because I tried to copy files .frm, .ISD and .ISM, but when
I want to replace theses by old files, I obtain a
message key error.
How can I do that?
Hello,
Having trawled through the documentation for a while I'm none the wiser -
is there any way of retrieving the data type of a single column using
MySQL? Any suggestions would be most appreciated.
Thanks,
Matthew Marcus
Try mysqldump.
You should if there is no data being saved to the database be able to copy
the files.
It mite be a good thing to make shore that there is not a problem with the
DB?
Simon
-Original Message-
From: Guillaume Denizot [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2001 12:31
To:
Hi
This is my first question to this group.
Is there anyway to grant access for all users to a table but two columns in
that table should be readonly, and
if username is something else it should have access to those two columns
with read and write and change.
Regards
Jonas Arvidsson
Hi,
Is anyone out there happily developing applications on RAQ4 / Chillisoft ASP
/ mySQL in the UK?
My company is looking to migrate some apps to this platform - I would be
very grateful if there is someone out there UK based willing to answer a
couple of questions I have.
any responses much
If you use a same MySQL handle for several threads you have to put
mutex locks around each {mysql_query() ..}
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_,
Hey there,
sorry about the cross post, but whenever i mail the ODBC list, i tend not
to get any replies.
I posted a couple of weeks ago with this problem, basicially I am using
lotus approach to access a mysql database through myodbc.
it seems that i can only ever return approx 200 or so
which version are u using?
and pls state other info about ur OS!
using with 3.23.38-max-nt in Windows2000 Advanced Server without problem when I
search exactly your example.
about the case %0xF4 0xF4%, have u really used it to search in where clause,
or u just want to elaborate ur example?
hi people
this is the correct syntax:
delete from TABLE_NAME where DATE_ADD(TIMESTAMP_COLUMN, interval 3 day)
now()
the function to be used is outside the parenthesis, the column name inside;
this way mysql applies the function to the column (using the specified
parameters interval...
Hi,
I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql
server as root and trying to use a sample database from Paul Dubois book MySql, I '
ve got the error 13, can't create directory/file ./samp_db/president.xxx.
The thing is I'm using an example DB, any help ?
On Sunday 12 August 2001 01:01, Bennett Haselton wrote:
I've written a CGI script that runs a database query on a MySQL database (I
know that's risky -- it's password-protected though, for what it's
worth). (...)
It's a free world ;-)
When I run the script with the first of these two lines
I get the following error when running configure on a mysql-3.22.32 source
distribution for Solaris 2.7:
==
checking for restartable system calls... configure: error can not run test
while cross compiling
hi,
I have pretty bad performance on the following query. Could someone help me to define
the indexes I need on the tables to improve this.
Thanks in advance.
select a.field_1,a.date,b.field_1,b.field_2,sum(a.subtotal) as total
from table_a as a, table_b as b
group by b.field_2,a.field_1
Horvath Gyula wrote:
Dear Members!
How can I convert a Corel-Paradox table (.db) to MySQL database ?
Thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
It seems that it is not possible to write a non blocking select query in
C (if the server is not responding, the program is hung till the timeout
expires).
If the above is true, is it possible to use threads (on a Linux machine)
along with the MySQL client library?
--
Jean-Luc Fontaine
Help! I can't get the DriverManager.getConnection() method with the 3-arg
signature to work (need it for DreamWeaver). Here are the two statements,
which should be equivalent:
WORKS:
Connection myConn =
DriverManager.getConnection(jdbc:mysql:///wroxjsp?user=xxxpassword=yyy);
DOESN'T WORK:
Description:
Index analysis and optimization is choosing wrong index when a
table involved in a JOIN is compound. MySQL should still be using
the first part of the GECK_STATE PRIMARY key (geck_id) since it is the column being
used to JOIN on the GECK table.
How-To-Repeat:
You should
Hi,
I guess somthing happenned this weekend and mysql
restarted.
After the doing a recovery scanning . message
I get the following:
Warning difficult to find free block try to increase memory buffer pool
size.
I have killed the process and increased the memory so now mysql is using
about
Hi,
I just created a table which only accepts one record. I can delete and then
add a record but I can't have more than one record at the same time. I have
another table which only accepts 10 records . I can delete and then add
records but I can't have more than 10 records. I created these
How do I benchmark 2 queries that return same results
without having mysql read from cache?
Example:
if i run the first query it will take 2 seconds, when I run the query
again, it takes 0.05 seconds.
And
What is the max. size of the index file that fits into 512M memmory, so that
mysql
try using SHOW FIELDS FROM TABLE LIKE EXPR, where 'TABLE' is the
name of the name of the table, and 'EXPR' is an expression indicating what
you wish to match.
for example, to get the information about a column called 'ckey' in table
'config', you would do: SHOW FIELDS FROM CONFIG LIKE 'CKEY'.
Hi!
This release mainly removes some of the old limits for InnoDB tables.
We have already moved most development to 4.0 and plan to release 4.0-alpha
by to the end of this month or at the start of September.
Changes in release 3.23.41
--
* Added option
Xavier,
I assume you have increased
innodb_buffer_pool_size
to 16M or bigger?
The fsync problem fixed in .40b could cause
that InnoDB was not able to flush modified
pages quickly enough to disk, causing the
error message 'Difficult to find free block...
Please download the brand-new 3.23.41
Go error 127 from table handler.. fixed itself in about 10 minutes..
don't know what this is or why it happened.. anyone know?
It happened while doing an update SQL command to a table.
I'm not even sure what it means.. can't find any error codes.
Hi folks,
Wondering if anybody can help me with this one.
I've got a table with 6.2 million rows in it, and MySQL seems to be straining a bit
with it. It's a basic table storing stock trading prices:
++-+--+-++---+
| Field | Type| Null |
It is possible using the columns_priv table in the mysql database. Check
out http://www.mysql.com/doc/P/r/Privilege_system.html for more information.
Good Luck,
David Price
-Original Message-
From: Jonas Arvidsson [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 3:09 AM
To:
I've put an index on date and symbol combined,
and tried putting one on just date.
Did you then do an EXPLAIN ... before your query
to see the results?
select min(date) from stockmarket where symbol='abc'
explain select min(date) from stockmarket ...
That will tell you if your indexes
Dan Makovec wrote:
Hi folks,
Wondering if anybody can help me with this one.
I've got a table with 6.2 million rows in it, and MySQL seems to be straining a bit
with it. It's a basic table storing stock trading prices:
++-+--+-++---+
|
I'm having a problem with mysql forgetting the location
of it's datadir. After the server has been running for
some time, it looses track and starts throwing errors
when I attempt to select a database. Killing mysqld
and letting safe_mysqld restart it fixes the problem
for a while, but having
And is there some way to download the previous posts to this list? I
found one list admin function that will download up to 100 posts
concatenated into one email, but I'd like to be able to d/l them
individually, with their own subject line and threading info. I just
think it would be
Go error 127 from table handler.. fixed itself in about 10 minutes..
don't know what this is or why it happened.. anyone know?
It happened while doing an update SQL command to a table.
I'm not even sure what it means.. can't find any error codes.
Try running perror 127
I apologize in advance for jumping in with a hardware suggestion,
but I just joined the list to sort out some similar questions.
Our production sql server (Microsoft's) is sitting on a box
that's now outdated w/ 2 200mhz processors and maybe .5G
of RAM. A query that takes 30 seconds on that box
hi,
I have pretty bad performance on the following query. Could
someone help me to define the indexes I need on the tables to
improve this.
Thanks in advance.
select a.field_1,a.date,b.field_1,b.field_2,sum(a.subtotal) as total
from table_a as a, table_b as b
group by
I know I'm getting away ahead of myself here, but is there a GUI
application development tool for mySQL? Something like Paradox or
Access, that lets you create complete applications with attractive
screens/forms and even start-up/splash screens. This would be on an NT
workstation.
Any
Hi !
)-Original Message-
)From: Conor McTernan [mailto:[EMAIL PROTECTED]]
)Sent: Monday, August 13, 2001 4:20 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: mysql/lotus approach question(sort of)
)
)
)Hey there,
)
)sorry about the cross post, but whenever i mail the ODBC
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Thanks for pushing me in the right direction :) It turns out that it
wasn't the semicolon on the end of $sql_query -- it was the newline. I had
been invoking it as follows:
./rundatabasequery.cgi
sql_query=SELECT+*+FROM+newssites_dynamicdata%3B%0D%0A
and the %0D%0A was a hex-encoded newline
Hello, I am starting to notice some funny behaviour in our MySQL setup.
(3.23.39)
Our database server will randomly stop accepting connections on port 3306 ,
or rather, they simply hang in limbo and appear to cause a TIME_WAIT
connection on our database server. This causes our website to hang ,
Rene Churchill writes:
I'm having a problem with mysql forgetting the location
of it's datadir. After the server has been running for
some time, it looses track and starts throwing errors
when I attempt to select a database. Killing mysqld
and letting safe_mysqld restart it fixes the
Anybody know how to deal with this problem?
-Original Message-
From: Kevin [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 9:40 AM
To: [EMAIL PROTECTED]
Subject: Compile error (checking for restartable system calls...
configure: error can not run test while cross
Hey everyone,
Has anyone had any experience establishing a secure connection between a
palm device and MySQL database that's on the net? I've setup secure web
pages on our webserver that are visible on the web and viewable by wireless
palms (securely). Scripts on that interface provide a
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...
Warning:
Yes I'm missing the query line in this posting my error (frustration is
taking over me G). The error occurs on line 5, which is the $dbconnection
line.
-Original Message-
From: Adam Douglas [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 2:00 PM
To: Mysql@Lists. Mysql. Com
Hey guys and gals
my problem for the day:
insert into USERS (User,Pass) values ('TestUser',PASSWORD('TestPass'))
No problems.
But how do i, as administrator, select the users password and decrypt it?
This is supposed to be used on a forgotten password page.
Select User,PASSWORD(Pass) from
I hope that someone here can help me with a little problem. We have a
database that has a lot of duplicate entries in it for one of the fields
(email). I need to find a way to search the database, find all of the
duplicate entries and delete all but one of the entries. It would not be
Doc wrote:
Hey guys and gals
my problem for the day:
insert into USERS (User,Pass) values ('TestUser',PASSWORD('TestPass'))
No problems.
But how do i, as administrator, select the users password and decrypt it?
This is supposed to be used on a forgotten password page.
You don't.
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...
Warning:
But how do i, as administrator, select the users password and decrypt it?
This is supposed to be used on a forgotten password page.
This is a hash function -- you _don't_ recover the password. Period.
On a recovery page, allow the user to set a new password (they didn't
remember the old one
Hi
Y try to use mysql but when i try to execute mysql
the next error apears.
ERROR 2002 Can't connect with local MYsql Server
Trought Socket '/var/lib/mysql/mysql.sock (2)'
i see the the files in this directory but don't apear
this file only files with .frm, .MYD, .MYI extension,
Can you
Dejan,
It seems that you have to add blahblahblah.com to the hosts allowed to
connect to the server.
Check the privilegies table and add that domain to the list.
On Fri, 27 Jul 2001 22:49:32 -0700 Dejan Nikic [EMAIL PROTECTED] wrote:
| Warning: Host 'blahblahblah.com' is not
Friend,
I think this is a JSP problem (mm driver). =)
Try to see if your driver is using an user that is allowed to connect to it
from where you are trying to. ;)
On Sun, 29 Jul 2001 22:30:46 +0800 gokeeper [EMAIL PROTECTED] wrote:
| i am running mysql 3.23.40 and tomcat 3.2.3
Exactly what question(s) would you like help with?
Did WinMySQLAdmin request a username/password?
Did you remove the service before you uninstalled?
- Original Message -
From: Lim Joo Tiong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 13, 2001 1:17 AM
Subject:
Martin,
If you want you can change memory configurations at my.cnf. Look at sample
configurations that comes with the source tarball. Use mysqladmin to see the
variables:
--
# mysqladmin -p variables
--
On Sun, 29 Jul 2001 02:50:25 -0400 martin [EMAIL PROTECTED] wrote:
Selva,
Try to use the ports collection (http://www.FreeBSD.org/ports) and do a:
--
cd /usr/ports/databases/mysql323-server
make clean install
--
It will install all things needed, if they aren't installed yet. =)
If you want I have packages of MySQL
Michael,
Use FreeBSD (http://www.FreeBSD.org) and install MySQL in a K6-3 700 or better
with good motheboard (Asus), ethernet (3com) and as much RAM as you can. I don't
think you need SCSI drives.
Of course it depends on how big it will be. =)
On Sat, 28 Jul 2001 20:12:34
Friend,
I learned that 8 + 4 = 12. Maybe you just missed that class ... :D
Before talk, think. ;)
On Thu, 26 Jul 2001 12:31:23 -0700 [EMAIL PROTECTED] wrote:
| 8.00user1
| 14.00 user2
| 160.00 user 3
|
| Now, where I went to school, this adds up to 184!
Cya
Antonio
Description:
Error When trying to install rpm (v 3.23.41-1.i386)
How-To-Repeat:
just run:
shell rpm -i MySQL-3.23.41-1.i386.rpm MySQL-3.23.41-1.i386.rpm
error: unpacking of archive failed on file /usr/doc/MySQL-3.23.41/manual.txt: cpio:
MD5 sum mismatch
Giving mysqld a couple of
Thank you guys. I guess there is a big backlog, plus it seems a pretty
active list. Maybe I'd better just stick with the archives. As I
become more familiar with MySQL I'll probably have more specific
questions, and can search the archives a little more productively.
Thank you.
Mike Kimball
Would the submitter of this Email to the list (seen below as
mailto:[EMAIL PROTECTED]) please fix your /etc/hosts file to
display your 'real' system name and 'domain'...
Also, you should create an account for yourself on the system, and send
your emails to the list as that user (how is anyone
Can MySQL have multiple unix domain sockets per mysqld instance, or would
you know of another way this can be done..?
I have postfix running chroot /var/spool/postfix .. and it can't open
/var/run/mysqld/mysqld.sock .. it works fine over tcp 127.0.0.1 but i'd
rather use a unix socket, is this
On Mon, Aug 13, 2001 at 06:32:34PM -0700, David Raufeisen wrote:
Can MySQL have multiple unix domain sockets per mysqld instance
I don't think so.
or would you know of another way this can be done..?
There's always a way. :-)
I have postfix running chroot /var/spool/postfix .. and it
Hi,
I am new to mysql, but as I know, the daemon can be set to use the
socket in different locations, by the configuration files or at the
time you start the daemon. Use 'mysqladmin variables' to see where
the socket is in your configuration.
You can set the default location of the socket in
Hello.
Im wondering whats up with lock tables in mysql.
i need to lock one table but also insert into another table that does not
have to be locked.
why does it need to lock both tables? this is pointless to me if one table
does not need
to be locked.
Also, from the mysql documentation :
If a
I'm trying to create a php/mysql user auth script that has a built in
mechanism that will allow me to distinguish between user types. For
example...if a student logs into the site, i would like them transfered to a
web page built specifically for them. Likewise with Professors. Any
Is there a common approach to searching within text columns that
contain fairly large blocks of text (30,000 - 65,000 characters)? Is
the recommendation, simply don't do it or is there some sort of
workaround? I suppose one can search within these columns using the
LIKE and % wildcards and
Hi,
I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which
include MySQL rpm installation, I saw the file named mysqld under /etc/init.d .
I set up symlink to it under /etc/rc3.d and etc/rc5.d. I intended to start
MySQL while Linux booting. But I failed to start it.
Sveiki, mysql,
I have a databse on the server. It os called ads. I want to make
copy of it on my PC. I have Win32, Apache with PHP and MySQL. And I
also have phpMyAdmin on that server. I'm writing this:
mysqldump -A ads /home/myaccount/www/backup.sql
But it says that i'm making a mistake.
Shu Xiao [EMAIL PROTECTED] writes:
Hi,
I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which
include MySQL rpm installation, I saw the file named mysqld under /etc/init.d .
I set up symlink to it under /etc/rc3.d and etc/rc5.d. I intended to start
MySQL while Linux
I am trying to create a database in my account at an
ISP with a Unix Solaris server.
The error message:
mydomain.com% mysqladmin create newdb
/usr/local/mysql/bin/mysqladmin: create of 'newdb'
failed
error: 'Access denied for user: '@localhost' to
database 'newdb''
mydomain.com%
Could someone
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...
On 13 Aug 2001 21:11:21 -0700, Michael Collins wrote:
Is there a common approach to searching within text columns that
contain fairly large blocks of text (30,000 - 65,000 characters)? Is
the recommendation, simply don't do it or is there some sort of
workaround? I suppose one can search
On 14 Aug 2001 06:32:16 +0300, Marius Pertravius wrote:
Sveiki, mysql,
I have a databse on the server. It os called ads. I want to make
copy of it on my PC. I have Win32, Apache with PHP and MySQL. And I
also have phpMyAdmin on that server. I'm writing this:
mysqldump -A ads
On 13 Aug 2001 21:11:21 -0700, Michael Collins wrote:
Is there a common approach to searching within text columns that
contain fairly large blocks of text (30,000 - 65,000 characters)? Is
Oh NO! Sorry, I messed my mail folders. Please forget about my previous
mail :(
--
For technical
On 13 Aug 2001 21:36:47 -0700, Manuel Velasco wrote:
I am trying to create a database in my account at an
ISP with a Unix Solaris server.
The error message:
mydomain.com% mysqladmin create newdb
/usr/local/mysql/bin/mysqladmin: create of 'newdb'
failed
error: 'Access denied for user:
Can anyone explain why this is happening?
root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Here is the permissions table:
mysql select host,db,user from db where db like cdgcatalog;
Hi,
I have a databse on the server. It os called ads. I want to make
copy of it on my PC. I have Win32, Apache with PHP and
MySQL. And I also have phpMyAdmin on that server.
I'm writing this:
mysqldump -A ads /home/myaccount/www/backup.sql
But it says that i'm making a mistake.
85 matches
Mail list logo